gs gs115 SQL Joins - SQL Union - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL Joins. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which operator is used to combine the result-set of two or more SELECT statements?
Combine
Merge
Union
Join
Question 2: By default, the UNION operator selects ______
Only duplicate values
Only distinct values
Only null values
All values
Question 3: How many result-sets can be combined using UNION operator?
Two
One
Two or more
Three or more
Question 5: The columns in each SELECT statement with UNION operator should be in ____________
Random order
Reverse order
Same order
Numeric data type
Question 6: Data types of the corresponding columns of SELECT statements with UNION operator _______
Must be different
Must be similar
Can be similar or different
Should not belong to date data type
Question 7: Which of the following conditions are required to make a set of SELECT statements as union-compatible?
Columns must be in same order, same number and same data type
Columns must be in same order, any number and same data type
Columns must be in any order, same number and same data type
Columns must be in same order and same number
Question 8: To fetch duplicate values along with the distinct values while combining the result-sets of two or more tables, which operator is used?
Union
All
Union All
Union Duplicates
Question 10: Column names in the resultset of a UNION are ______
The column names of the first SELECT statement
The column names of the last SELECT statement
The combination of column names of first and last SELECT statements
The column names of any of the SELECT statements
