Multiple choice technology databases

Another name for the EXCEPT operator is __________.

  1. INSTEAD OF

  2. NOT IN

  3. INTERSECT

  4. MINUS

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The SQL EXCEPT operator returns rows from the first query that are not in the second query. In Oracle SQL, this operation is called MINUS. INSTEAD OF is for triggers, NOT IN is a comparison operator, and INTERSECT finds common rows.