1. Which isolation level allows the highest level of concurrency and provides the least locking on the database?
2. Which type of index is designed to improve the performance of queries that return a small result set from large tables?
3. What is the purpose of the SQL Server function "RAISERROR"?
4. Which statement is used to add a new column to an existing table in MSSQL?
5. Which SQL statement is used to delete rows from a table based on a specified condition?
6. What is the purpose of the SQL Server function "COALESCE"?
7. What is the purpose of the SQL Server function "DATEDIFF"?
8. Which SQL data type would you use to store large amounts of character data that may exceed 8,000 characters in MSSQL?
9. What does the SQL Server function "CHECKSUM" do?
10. Which SQL statement is used to permanently remove a table from the database in MSSQL?
11. What is the purpose of the SQL Server function "STUFF"?
12. Which SQL statement is used to modify the structure of an existing table in MSSQL?
13. What is the purpose of the SQL Server function "STRING_SPLIT"?
14. What is the purpose of the SQL Server function "ROW_NUMBER()" when used with the OVER() clause?
15. What is the purpose of the SQL Server function "PIVOT"?