What is UNION, UNION ALL?

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

(Continued from previous question...)

What is UNION, UNION ALL?

UNION eliminates duplicates
UNION ALL retains duplicates
Both these are used to combine the results of different SELECT statements.

(Continued on next question...)

Other Job Interview Questions

• What is a NULL value? What are the pros and cons of using NULLS ?
• Describe the elements of the SELECT query syntax?
• How would you retrieve row from a DB2 table in embedded SQL?
• What is the difference between static and dynamic SQL?
• What are foreign keys?
• What are foreign keys?
• Explain the EXPLAIN statement?
• Why SELECT * is not preferred in embedded SQL programs ?
• What is a subselect? It is different from a nested select ?
• What is referential integrity?
• More...