Question 16
Which of the following is true about foreign key constraints in SQL?
Question 17
What will the following query result in?
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
SELECT e.employee_id, e.manager_id
FROM employees e
WHERE e.manager_id IS NOT NULL;
Question 18
Which of the following is a valid reason to create a synonym?
Question 19
Which operator can be used in a multiple-row subquery to match a single value to a list of values?
Question 20
What is the primary purpose of granting privileges in Oracle Database?
