What is the purpose of a correlated subquery in DB2?
- To filter the result set
- To perform a calculation
- To perform an aggregate calculation
- To reference columns from the outer query
A correlated subquery is used to reference columns from the outer query within the subquery. This allows the subquery to be evaluated once for each row processed by the outer query, enabling more complex filtering and calculations.
Loading...
Related Quiz
- Row-level locking in DB2 provides ________ granularity for locking compared to table-level locking.
- Scenario: A DBA needs to grant access to a specific table in DB2 to a new user while ensuring the least privilege principle. How should they approach this task?
- How does a stored procedure differ from a regular SQL statement in DB2?
- Which encryption algorithm is commonly used to secure data in transit in DB2?
- Nesting tags in DB2 allows for better organization and ________ of the database structure.