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;
  • 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?