Which type of subquery is executed once for each row returned by the outer query?
- Correlated subquery
- Derived table
- Nested subquery
- Scalar subquery
A correlated subquery is executed once for each row returned by the outer query. It depends on the values from the outer query, making it different from other subquery types.
Loading...
Related Quiz
- To ensure data integrity, DB2 provides support for ________.
- In DB2, what is the difference between shared locks and exclusive locks?
- How does Visual Explain assist in identifying potential bottlenecks in query execution?
- Which factor does Visual Explain help identify in query performance tuning?
- The IMPORT utility in DB2 supports the ________ option, which allows for skipping header rows in the input file.