READ Free Dumps For Oracle- 1z0-007
Question ID 8051 | Which three statements about subqueries are true? (Choose three.) |
Option A | A main query can have more than one subquery. |
Option B | A subquery can have more than one main query. |
Option C | The subquery and main query must retrieve data from the same table. |
Option D | The subquery and main query can retrieve data from different tables. |
Option E | Only one column or expression can be compared between the subquery and main query. |
Option F | Multiple columns or expression can be compared between the subquery and main query. |
Correct Answer | ADE |
Question ID 8052 | Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? |
Option A | remove the ORDER BY clause |
Option B | remove the table alias prefix from the WHERE clause |
Option C | remove the table alias from the SELECT clause |
Option D | prefix the column in the USING clause with the table alias |
Option E | prefix the column in the ORDER BY clause with the table alias |
Option F | replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40" |
Correct Answer | CE |