SQL Quiz 9 Copy

Question 1 of 16

1. Question

UNION operator is used to combine the result-set of two or more SELECT statements.

True
False

Question 2 of 16

2. Question

What is the difference between union and union all clause?

UNION ALL operator selects only distinct values by default. To allow duplicate values, use UNION ALL
UNION ALL operator selects only distinct values by default. To allow duplicate values, use UNION
UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL
UNION operator selects only distinct values by default. To allow duplicate values, use UNION

Question 3 of 16

3. Question

What does intersection clause perform

return different data between two datasets
return common data between two datasets
return entire data from different datasets
none of the above

Question 4 of 16

4. Question

What does intersection clause perform

return different data between two datasets
return common data between two datasets
return entire data from different datasets
none of the above

Question 5 of 16

5. Question

EXCEPT statement is used to filter records based on the intersection of records returned via two SELECT statements

True
False

Question 6 of 16

6. Question

Which of the following are set clauses

Union
Union all
Intersect
Intersect all

Question 7 of 16

7. Question

Are joins and clauses similar?

True
False

Question 8 of 16

8. Question

Indexes are used to

slow down the data retrieval
maintain data format
speed up the data retrieval
none of the above

Question 9 of 16

9. Question

What is the correct query to create an index?

Create index <index name> on <index name>(column name);
Create table <index name> on <table name>(column name);
Create index <table name> on <table name>(column name);
Create index <index name> on <table name>(column name);

Question 10 of 16

10. Question

Which query will drop the index?

drop index<table name> on <table name>;
drop index<index name> on <table name>;
drop index<table name> on <table name>;
drop index<index name> on <index name>;

Question 11 of 16

11. Question

Which of the following are indexes

implicit index
explicit index
non clustered index
hybrid index

Question 12 of 16

12. Question

Which of the following index is based on cluster?

implicit index
explicit index
non clustered index
hybrid index

Question 13 of 16

13. Question

Which of the following indexes is based on numbering?

implicit index
explicit index
non clustered index
hybrid index

Question 14 of 16

14. Question

Indexes are automatically created for primary key constraints and unique constraints.

True
False

Question 15 of 16

15. Question

Implicit index is also known as

curser index
null index
true index
false index

Question 16 of 16

16. Question

A non-clustered index doesn’t sort the physical data inside the table

True
False

Quiz Summary

Information

Results