Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. (Choose all that apply.)
A correlated sub-query is a sub-query where a column of a table referred in the outer parent query is referenced in the sub-query. Two tables are involved in a correlated sub-query and both have data in them. The two tables are linked to each other using a common column. In the UPDATE and DELETE
SQL statements the table can have data and can be linked with a common column. However, the same is not true for INSERT statements as in the INSERT statement the table does not contain any data, and hence, cannot be correlated with the inner query table.
SELECT is incorrect because it is not DML
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
rogeriosolano
2 years, 11 months ago