The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-047 — Oracle Database SQL Certified Expert

Question 2:

Which of the following statements is true about a correlated subquery?

A. They occur when a nested subquery references a column from a table referred to in a parent statement two or more levels above the subquery.
B. A correlated subquery is evaluated once for each row processed by the parent statement.
C. Correlated subqueries only occur when the parent statement is a SELECT operation.
D. They are used to resolve multiple-part question for which the answer is independent of the row processed by the parent statement.
E. Correlating the subquery with the parent normally leads to improved query performance.