MSSQL Objective Questions and Answers for Professionals Set-2

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?




Rate Your Experience

: 89 : 1


Last updated in July, 2024

Online Tests
Read more

Cloud Technology
Read more

Oracle Database
Read more

MSSQL Database
Read more

PostGres Database
Read more

Linux
Read more

ASP/C#
Read more

Quick Access