Database Maintenance interview questions
Database Maintenance interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 10
1. The SQL Server Maintenance Solution comprises scripts for running __________ maintenance on all editions of Microsoft SQL Server.
Correct Answer is : all of the mentioned
2. Point out the correct statement related to database maintenance :
Correct Answer is : Performing SQL Server Maintenance with No Maintenance Window
3. Which of the following is used to determine the fragmentation for tables and indexes ?
Correct Answer is : DBCC SHOWCONTIG
4. Which of the following is used to Validate the database objects ?
Correct Answer is : DBCC CHECKDB
5. Point out the wrong statement :
Correct Answer is : The command DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database
6. Which of the following command defragments clustered and secondary indexes of the specified table ?
Correct Answer is : DBCC INDEXDEFRAG
7. ______________ runs UPDATE STATISTICS against all user-defined tables in the current database.
Correct Answer is : sp_updatestats
8. Purpose of DBCC DBREINDEX command is to :
Correct Answer is : Rebuilds one or more indexes for a table in the specified database
9. What types of database maintenance should be executed ?
Correct Answer is : All of the mentioned
10. Create a Database Maintenance Plan that creates a ________ backup within SQL Server.
Correct Answer is : Full
