SQL Server Practice Test – 5 1. SQL Server Practice Tests What is a key benefit of indexing in SQL Server? Increases data storage requirements Enhances data retrieval speed Automates backup operations Improves transaction consistency None 2. SQL Server Practice Tests Which command would you use to change the schema of a table? ALTER SCHEMA ALTER TABLE SWITCH RENAME SCHEMA MODIFY TABLE None 3. SQL Server Practice Tests Which SQL Server tool helps diagnose locking issues? SQL Profiler Activity Monitor SP_LOCK Execution Plan None 4. SQL Server Practice Tests Which SQL Server command is used to remove a table from the database? REMOVE TABLE DELETE TABLE DROP TABLE CLEAR TABLE None 5. SQL Server Practice Tests Which function returns a specific part of a date in SQL Server? DATEADD() DATEDIFF() DATEPART() DATENAME() None 6. SQL Server Practice Tests What is the main purpose of CHECKSUM in SQL Server? Encrypts data for security Generates a hash to verify data integrity Manages database consistency Indexes text columns None 7. SQL Server Practice Tests Which type of index automatically updates with changes in the table? STATIC INDEX NON-CLUSTERED INDEX CLUSTERED INDEX FILTERED INDEX None 8. SQL Server Practice Tests What does the DBCC DROPCLEANBUFFERS command do? Backs up buffers Clears the cache for testing purposes Enhances performance by caching data Deletes unused indexes None 9. SQL Server Practice Tests Which feature helps in managing version control of database objects in SQL Server? TRANSACTION LOG DATABASE SNAPSHOTS CHANGE TRACKING TEMPORAL TABLES None 10. SQL Server Practice Tests Which statement is used to undo changes in SQL Server? ROLLBACK REVERSE UNDO REJECT None Time's up
