1Z0-171 Exam Question 11
What is the purpose of a correlated subquery?
1Z0-171 Exam Question 12
What happens if a privilege is revoked from a user who has granted the same privilege to others?
1Z0-171 Exam Question 13
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?
1Z0-171 Exam Question 14
What is the purpose of the DBA_OBJECTS data dictionary view?
1Z0-171 Exam Question 15
What does the following query return?
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);
SELECT employee_id
FROM employees
WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 1000);