MSSQL Objective Questions and Answers for Professionals Set-1
corpline

1. What is the purpose of the SQL Server CHECK constraint?


2. Which of the following is used to retrieve only unique rows from the result set in SQL Server?


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


4. Which of the following SQL Server indexes physically reorder the data rows in a table?


5. What is the purpose of the SQL Server keyword "TOP" in a SELECT statement?


6. In SQL Server, what is the purpose of the LTRIM() function?


7. Which of the following is a system database in SQL Server that stores metadata and configuration information?


8. What is the purpose of the SQL Server function DATEDIFF()?


9. Which SQL Server backup type includes both data and transaction log changes since the last backup?


10. In SQL Server, which of the following is used to retrieve a specific part of a datetime value, such as the year, month, or day?


11. What is the purpose of the SQL Server function COALESCE()?


12. Which SQL Server join type returns only the rows that have matching values in both tables?


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


14. Which of the following SQL Server statements is used to permanently remove rows from a table?


15. What is the purpose of the SQL Server function @@ROWCOUNT?


Online Tests
Read more

Oracle Database
Read more

MSSQL Database
Read more

PostGres Database
Read more

Linux
Read more

ASP/C#
Read more

Navigation Panel