1. In SQL Server, what is the purpose of the TRY...CATCH block?
2. Which of the following SQL Server views provides information about the columns, data types, and constraints in a database table?
3. What is the purpose of the SQL Server function RANK()?
4. Which SQL Server system stored procedure is used to execute a dynamic SQL statement?
5. Which SQL Server system view contains information about the execution plans of stored procedures?
6. In SQL Server, what is the purpose of the keyword "NOLOCK" in a SELECT statement?
7. Which SQL Server system view provides information about the active connections to the database?
8. What is the purpose of the SQL Server function CHOOSE()?
9. In SQL Server, which of the following is used to handle NULL values in expressions?
10. Which SQL Server system view provides information about the current locks on a database?
11. What is the purpose of the SQL Server function STUFF()?
12. What is the purpose of the SQL Server function PATINDEX()?
13. Which SQL Server system view provides information about the database files and their sizes?
14. In SQL Server, what is the purpose of the keyword "CASCADE" in a FOREIGN KEY constraint?
15. Which of the following SQL Server statements is used to change the data type of a column in a table?