Oracle Database 12c: SQL Fundamentals - 1z1-061 Exam Questions

A. You want to use another schema's tables. B. You have too many tables. C. Your tables have difficult names. D. You want to work on your own tables. E. You have too many columns in your tables. F. Your tables names are too long.

A. Performance would improve in query 2. B. Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column. C. Performance would degrade in query 2. D. There would be no change in performance.

A. Only statement 2 executes successfully and gives the required result. B. Both statements 1 and 2 execute successfully and give different results. C. Both statements 1 and 2 execute successfully and give the same required result. D. Only statement 1 executes successfully and gives the required result.

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database. B. It fails because no SQL *Loader control file location is specified. C. It fails because no SQL *Loader data file location is specified. D. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

A. RDB allows the definition of relationships between different tables, whereas OODB does not allow this. B. OODB incorporates methods with data structure definition, whereas RDB does not allow this. C. RDB supports E.F. Codd's rules, whereas OODB does not support them. D. OODB supports multiple objects in the same database, whereas RDB supports only tables.

A. They can be created on tables and simple views. B. You can create only one index by using the same columns. C. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns. D. They can be created on tables and clusters.

A. You can use EM express to manage multiple databases running on the same server. B. You can perform basic administrative tasks for pluggable databases by using the EM express interface. C. You can create and configure pluggable databases by using EM express. D. By default, EM express is available for a database after database creation. E. You cannot start up or shut down a database Instance by using EM express.

A. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department_id; B. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10, 20) GROUP BY job_id HAVING SUM(salary) > 20000; C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY
department_id, job_id; D. SELECT *FROM emp_dept_vu; E. None of the statements produce an error; all are valid.

A. difference, projection, join B. intersection, projection, join C. selection, projection, join D. difference, projection, product E. selection, intersection, join