Suppose I have five SQL SELECT statements connec

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

(Continued from previous question...)

Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...

Q: Suppose I have five SQL SELECT statements connected by UNION/UNION ALL, how many times should I specify UNION to eliminate the duplicates rows?

AN:
Once

(Continued on next question...)

Other Job Interview Questions

• What is meant by null?
• What is a results table?
• What is a view? Why use it ?
• How would you retrieve row from a DB2 table in embedded SQL?
• What is the basic differnce between a join and a union?
• What is normalization and what are the five normal forms?
• What is the difference between static and dynamic SQL?
• What is an index key?
• When do you use a LINK statement ?
• What is an object?
• More...