What is subselect? Is it different from a nested

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

(Continued from previous question...)

What is subselect? Is it different from a nested select ?

A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the innner select passes to the where criteria for the outer select.

(Continued on next question...)

Other Job Interview Questions

• What is the maximum number of tables that can be stored on a Partitioned Tables Space?
• What is Maximum number of rows per page
• What information is used as input to the bind process?
• What are column-name qualifier used ?
• How do you do the EXPLAIN of a dynamic SQL statement ?
• How do you filter out the rows retrieved from a DB2 table ?
• What is the difference between IN subselects and EXISTS subselect?
• Under what circumstances will DB2 allow an SQL satement ...
• What are the various locking levels available ?
• What is lock contention?
• More...