Multiple choice technology testing

Sub-queries can be nested in…

  1. UPDATE, DELETE, INSERT and SELECT statements.

  2. UPDATE statements only.

  3. DELETE statements only.

  4. INSERT statements only.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Subqueries can be nested within all Data Manipulation Language (DML) statements including UPDATE, DELETE, INSERT, and SELECT. This flexibility allows complex data operations to be performed in a single statement. Options B, C, and D are incorrect because they unnecessarily limit subqueries to only one type of statement.

Keep practicing — related questions