Multiple choice technology databases

Which of the following does not hold true for the subqueries?

  1. Can be the object of an IN or NOT IN clause

  2. Can be the object of EXISTS or NOT EXISTS

  3. Support quantifiers ALL, ANY, SOME

  4. Support LIKE or NOT LIKE used with a

  5. Cannot specify more than one column to match
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The statement "Cannot specify more than one column to match" does not hold true generally, as subqueries can return multiple columns when used with operators like EXISTS or in column comparison lists (e.g., (A, B) IN (SELECT X, Y...)). Other options describe correct standard behaviors of subqueries.

Keep practicing — related questions