Quiz 2 (SQL Server SSMS)

Welcome to your Quiz 2 (SQL Server SSMS)

1. 
What is the purpose of the SQL SELECT statement?
2. 
Which SQL keyword is used to retrieve unique records from a table?
3. 
What is the purpose of the SQL WHERE clause?
4. 
Which SQL function is used to find the total number of rows in a table?
5. 
What is the purpose of the SQL ORDER BY clause?
6. 
In SQL, what is a primary key used for?
7. 
Which SQL statement is used to update data in a table?
8. 
What is the purpose of the SQL GROUP BY clause?
9. 
Which SQL operator is used to combine rows from two or more tables based on a related column between them?
10. 
What is the purpose of the SQL HAVING clause?
11. 
Which SQL function is used to find the average value of a numeric
12. 
In SQL, what is a foreign key used for?
13. 
What is the purpose of the SQL BETWEEN operator?
14. 
Which SQL function is used to find the highest value in a column?
15. 
What is the purpose of the SQL DELETE statement?
16. 
Which SQL clause is used to add a new record to a table?
17. 
What does the SQL acronym "DDL" stand for?
18. 
In SQL, what is the purpose of the NULL value?
19. 
Which SQL operator is used to combine the result sets of two or more SELECT statements without returning duplicate rows?
20. 
What is the purpose of the SQL TRUNCATE TABLE statement?

Leave a Reply

Your email address will not be published. Required fields are marked *

This website uses cookies. By continuing to use this site, you accept our use of cookies.