Multiple choice technology databases

Which of the following is not a multiple-row operator?

  1. IN

  2. OF

  3. ALL

  4. ANY
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Multiple-row operators in SQL are IN, ANY, ALL, EXISTS, and their negations (NOT IN, etc.). OF is not a valid SQL operator - it's not listed among single-row operators (=, !=, <, >, <=, >=) or multiple-row operators. Option A (IN), C (ALL), and D (ANY) are all valid multiple-row operators.

Keep practicing — related questions