SQL Quiz 7 Copy

Question 1 of 15

1. Question

What does the distinct keyword return?

used to add distinct (different) values
used to return only similar values
used to return only distinct (different) values
used to add similar values

Question 2 of 15

2. Question

What does an “in” operator do?

allows you to specify multiple values in a UPDATE clause
allows you to specify multiple values in a WHERE clause
allows you to specify multiple values in a ALTER clause
allows you to specify multiple values in a SELECT clause

Question 3 of 15

3. Question

BETWEEN operator selects values within a given range

True
False

Question 4 of 15

4. Question

What is the functionality of the count function?

returns the number of rows that matches a specified criterion
used to find out the average of a field in various records
calculates the sum of a set of values
none of the above

Question 5 of 15

5. Question

What is the functionality of AVG function?

returns the number of rows that matches a specified criterion
used to find out the average of a field in various records
calculates the sum of a set of values
none of the above

Question 6 of 15

6. Question

What is the function of the sum function?

returns the number of rows that matches a specified criterion
used to find out the average of a field in various records
calculates the sum of a set of values
none of the above

Question 7 of 15

7. Question

Aggregate functions such as SUM, COUNT, AVG, MAX, and MIN exclude NULL values.

True
False

Question 8 of 15

8. Question

What does the “as” keyword do?

used to create a column or table with an alias
used to replace a column or table with an alias
used to rename a column or table with an alias
none of the above

Question 9 of 15

9. Question

“order by” keyword is used to sort the result

True
False

Question 10 of 15

10. Question

“order by” keyword

enables you to specify conditions that filter which group results appear in the results
groups rows that have the same values
sort the result-set in ascending or descending order
none of the above

Question 11 of 15

11. Question

“group by” keyword

enables you to specify conditions that filter which group results appear in the results
groups rows that have the same values
sort the result-set in ascending or descending order
none of the above

Question 12 of 15

12. Question

“having” keyword

enables you to specify conditions that filter which group results appear in the results
groups rows that have the same values
sort the result-set in ascending or descending order
none of the above

Question 13 of 15

13. Question

The HAVING Clause enables you to specify conditions that filter which group results appear in the results

True
False

Question 14 of 15

14. Question

GROUP BY statement sort the result-set in ascending or descending order

True
False

Question 15 of 15

15. Question

The ORDER BY keyword sorts the records in ascending order by default

True
False