Multiple choice technology databases

Sub-queries can be nested in…

  1. DELETE statements only.

  2. INSERT statements only.

  3. UPDATE statements only.

  4. UPDATE, DELETE, INSERT and SELECT statements.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL subqueries can be nested within all major Data Manipulation Language statements. They provide powerful query capabilities in SELECT statements for filtering and projection, and can also be used in UPDATE, DELETE, and INSERT statements to determine which rows are affected or what values are inserted.

Keep practicing — related questions