SQL Server Practice Test – 3 1. SQL Server Practice Tests What is the use of the IDENTITY property in SQL Server? Specifies a primary key Generates unique values for a column automatically Adds constraints to columns Allows NULL values None 2. SQL Server Practice Tests Which SQL Server function is used to convert data types? TRY_CONVERT() CAST() CONVERT() FORMAT() None 3. SQL Server Practice Tests What is the primary use of the MERGE statement? Joins two tables Creates new tables Performs insert, update, or delete operations in one statement Analyzes table structure None 4. SQL Server Practice Tests Which SQL Server function returns the last identity value generated in the session? IDENT_CURRENT() SCOPE_IDENTITY() @@IDENTITY NEXT VALUE FOR None 5. SQL Server Practice Tests Which type of join returns rows only when there is a match in both tables? LEFT JOIN RIGHT JOIN INNER JOIN FULL JOIN None 6. SQL Server Practice Tests What does the RAISEERROR statement do in SQL Server? Fixes errors Returns an error message to the client Logs errors Suppresses errors None 7. SQL Server Practice Tests How can SQL Server indexes impact performance? Speed up query retrieval time Slow down inserts and updates Reduce storage space Ensure data integrity None 8. SQL Server Practice Tests Which SQL Server isolation level allows dirty reads? READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE None 9. SQL Server Practice Tests What does the DBCC CHECKDB command do?v Backs up the database Restores the database Checks the logical and physical integrity of the database Deletes corrupted data None 10. SQL Server Practice Tests What is the purpose of FULL OUTER JOIN? Matches rows only from the first table Returns all rows when there is a match in either table Returns unmatched rows only Combines tables without duplicates None Time's up
