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

COBOL SQL 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 Interview Questions

• What is the difference between IN subselects and EXISTS subselect?
• What is a subselect? It is different from a nested select ?
• What is referential integrity?
• Explain the EXPLAIN statement?
• Describe the elements of the SELECT query syntax?
• What is a results table?
• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• What is minimum authority required for one to create a tablespace?
• Describe the elements of the SELECT query syntax?
• What is an object?
• More...