SQL Union MCQs

11. Which keyword used with UNION retains duplicate rows?

A. ALL
B. NARROW
C. STRICT
D. DISTINCT

View Answer


12. Which table is used to run a UNION-type query on MyISAM tables?

A. TRADITIONAL
B. MERGE
C. SERVELET
D. UNITE

View Answer


13. What does UNION operator do in a SQL Server statement?

A. Bring common data from the listed tables.
B. Bring data which is not common from the listed tables.
C. Bring all data from the listed tables.
D. Bring all distinct from the listed tables.

View Answer


14. What is true about order by with Union operator?

A. Order By can be issued in each result set.
B. It can be issued for the overall result set.
C. Both A & B.
D. None of the above

View Answer


15. Which of the following statement is TRUE about UNION?

A. Each query in a UNION can be sorted independently in different sort orders
B. All the queries in a UNION must be against the same table
C. UNION clause is used to subtract rows of second query from the first query
D. UNION and UNION ALL give same result if the participating queries are mutually exclusive

View Answer


16. Which of the following is not Constraint in SQL?

A. Primary Key
B. Not Null
C. Check
D. Union

View Answer


17. Which of the following is one of the basic approaches for joining tables?

A. Subqueries
B. Union Join
C. Natural join
D. All of the above

View Answer






Also check :


Discussion


* You must be logged in to add comment.