Multiple choice technology databases

You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery?

  1. IN

  2. Between

  3. Exists

  4. Like
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The EXISTS operator is specifically designed to test for the existence of rows returned by a subquery and cannot function without one. IN, BETWEEN, and LIKE can operate on literal values or lists.

Keep practicing — related questions