Database Fundamentals — Question 144

Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. (Choose all that apply.)

Answer options

• A. INSERT
• B. UPDATE
• C. DELETE
• D. SELECT

Correct answer: B, D

Explanation

Correlated sub-queries can be used in UPDATE and SELECT statements because they allow for referencing columns from the outer query. INSERT and DELETE statements do not support correlated sub-queries in the same way, as they operate on different principles.