SQL Server Practice Test – 2 1. SQL Server Practice Tests How does SQL Server handle deadlocks by default? Terminates all connections Automatically restarts the server Kills one of the conflicting processes Notifies the administrator None 2. SQL Server Practice Tests What is the primary advantage of a COVERING INDEX? Reduces index size Speeds up insert operations Avoids lookups by including all needed columns Automatically optimizes queries None 3. SQL Server Practice Tests How does the WITH (NOLOCK) hint affect a SQL query? A) Prevents reading dirty data B) Allows reading uncommitted data C) Locks all rows until query completion D) Speeds up insert operations None 4. SQL Server Practice Tests What is the main purpose of EXTERNAL TABLES in SQL Server? To import data from other databases To connect to external files and sources To store data temporarily To create memory-optimized tables None 5. SQL Server Practice Tests What does the CROSS APPLY operator do in SQL Server? Joins two tables with a filter Applies a function to each row of a table Adds indexes dynamically Updates data based on conditions None 6. SQL Server Practice Tests In SQL Server, what does sp_who2 display? List of running queries Performance metrics Active processes and users System errors None 7. SQL Server Practice Tests What is Query Store used for in SQL Server? Index management Tracking query performance Backup management Log file analysis None 8. SQL Server Practice Tests What is the purpose of the OUTPUT clause in SQL Server? Filters rows in the WHERE clause Returns data from modified rows Generates a summary of operations Rolls back transactions None 9. SQL Server Practice Tests What does the SET STATISTICS TIME ON command do? Measures the execution time of a query Analyzes index performance Displays memory usage Optimizes the query plan None 10. SQL Server Practice Tests Which function returns the first non-null expression among its arguments? ISNULL() COALESCE() NULLIF() IFNULL() None Time's up
