MSSQL Objective Questions & Answers for Professionals Set-3

1. What is the purpose of the SQL Server function GETUTCDATE()?


2. Which SQL Server system function is used to retrieve the current user's login name?


3. What is the purpose of the SQL Server function LEFT()?


4. Which of the following SQL Server statements is used to rename a table?


5. In SQL Server, what is the purpose of the keyword "OPTIMIZE FOR" in a query?


6. Which SQL Server system view provides information about the current database connections and their status?


7. In SQL Server, what is the purpose of the keyword "EXCEPT" in a query?


8. Which SQL Server system view provides information about the execution plans of cached queries?


9. Which SQL Server statement is used to grant permissions to a user or role on an object?


10. What is the purpose of the SQL Server function XML PATH()?


11. Which SQL Server system view provides information about the database schema, such as tables, columns, and indexes?


12. In SQL Server, what is the purpose of the function LAG()?


13. What is the purpose of the SQL Server function FORMAT()?


14. In SQL Server, what is the purpose of the keyword "OVER" in a window function?


15. In SQL Server, what is the purpose of the keyword "PIVOT" in a query?




Rate Your Experience

: 89 : 1


Last updated in November, 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