What is a subselect? It is different from a nes

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

(Continued from previous question...)

What is a subselect? It is 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 inner select passes to the where criteria for the outer select.

(Continued on next question...)

Other Job Interview Questions

• What is normalization and what are the five normal forms?
• Is DECLARE CURSOR executable?
• How would you find out the total number of row in a table?
• Can you use MAX on a CHAR column?
• When is it necessary to create a table index?
• Explain an outer join ?
• What does the term "grant privileges" mean?
• What is a cursor?
• Any SQL implementation covers data types in couple of main categories. Which of the following are those data types?
• Is BETWEEN inclusive of the range values specified?
• More...