How does the processing of a correlated subquery

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How does the processing of a correlated subquery differ from a non correlated subquery ?

The subquery in a correlated subquer is reevaluated for every row of the table or view named in the outer query, while the subquery of a non correlated subquery is evaluated only once.

(Continued on next question...)

Other Job Interview Questions

• What is a thread?
• Where are plans stored ?
• What is a DB2 bind?
• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• What is the format (internal layout) of "TIMESTAMP"?
• Where besides the DB2 catalog is database object information stored by DB2?
• If I have a view which is a join of two or more tables, can this view be updatable?
• What is a collection?
• What is REORG? When is it used
• Why might full image copies be faster to implement than an incremental image copy?
• More...