MSSQL Objective Questions and Answers for Practitioners Set-2

1. Which SQL statement is used to remove all data from a table but keep the table structure intact in MSSQL?


2. What is the purpose of the SQL Server function "PARSE" or "TRY_PARSE"?


3. What is the purpose of the SQL Server function "FORMAT"?


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


5. Which SQL statement is used to add a new row to a table in MSSQL?


6. Which SQL statement is used to delete a database in MSSQL?


7. What is the purpose of the SQL Server function "RANK()" when used with the OVER() clause?


8. Which SQL statement is used to retrieve a random sample of rows from a table in MSSQL?


9. What is the purpose of the SQL Server function "TRY_CONVERT"?


10. Which SQL statement is used to return only distinct (unique) values from a column in MSSQL?


11. What is the purpose of the SQL Server function "SESSION_CONTEXT"?


12. Which SQL statement is used to update data in a table with values from another table in MSSQL?


13. Which SQL statement is used to retrieve the current date and time in MSSQL?


14. Which SQL statement is used to create a new database in MSSQL?


15. What is the purpose of the SQL Server function "CHOOSE"?




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