MSSQL Objective Questions and Answers for Practitioners Set-3

1. Which SQL statement is used to create a new view in MSSQL?


2. What is the purpose of the SQL Server function "FORMATMESSAGE"?


3. Which SQL statement is used to rename a table in MSSQL?


4. What is the purpose of the SQL Server function "TRY_CAST"?


5. Which SQL statement is used to retrieve the first row from a result set in MSSQL??


6. What is the purpose of the SQL Server function "OFFSET" when used with the "FETCH" clause?


7. Which SQL statement is used to create a new user-defined function (UDF) in MSSQL?


8. What is the purpose of the SQL Server function "INDEXPROPERTY"?


9. Which SQL statement is used to grant specific privileges to a user or role in MSSQL?


10. What is the purpose of the SQL Server function "STRING_SPLIT"?


11. Which SQL statement is used to retrieve data from multiple tables based on related columns in MSSQL?


12. What is the purpose of the SQL Server function "SESSION_ID"?


13. Which SQL statement is used to change the data type of a column in MSSQL?


14. What is the purpose of the SQL Server function "CONCAT"?


14. Which SQL statement is used to roll back a transaction and undo its changes in MSSQL?




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