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 |