MCQ King
63 – DBCC command MCQ
1 / 25
1. What does DBCC stand for in SQL Server?
2 / 25
2. Which DBCC command in SQL Server is used to check the logical and physical integrity of all the objects in a database?
3 / 25
3. What is the primary purpose of the DBCC CHECKDB command in SQL Server?
4 / 25
4. Which DBCC command is used to check the allocation structures and pages in a SQL Server database?
5 / 25
5. In SQL Server, which DBCC command is used to display information about database configuration, version, and compatibility level?
6 / 25
6. What is the primary purpose of the DBCC CHECKALLOC command in SQL Server?
7 / 25
7. Which DBCC command in SQL Server is used to check for consistency errors in the database catalog and metadata?
8 / 25
8. What does the DBCC CHECKCATALOG command check in SQL Server?
9 / 25
9. Which DBCC command in SQL Server is used to check the consistency of a specific table or index?
10 / 25
10. In SQL Server, what is the primary purpose of the DBCC CHECKTABLE command?
11 / 25
11. Which DBCC command in SQL Server is used to check the status of database objects and display information about lock requests and resources?
12 / 25
12. What does the DBCC CHECKDB command return if it finds no errors in the database?
13 / 25
13. Which DBCC command in SQL Server is used to validate the logical and physical integrity of a filegroup?
14 / 25
14. What is the primary purpose of the DBCC CHECKFILEGROUP command in SQL Server?
15 / 25
15. Which DBCC command in SQL Server is used to list the active transactions and locks in the database?
16 / 25
16. In SQL Server, what is the primary purpose of the DBCC SHOW_STATISTICS command?
17 / 25
17. Which DBCC command in SQL Server is used to display detailed information about the statistics for a specific column or index?
18 / 25
18. What is the primary purpose of DBCC DBINFO command in SQL Server?
19 / 25
19. Which DBCC command in SQL Server is used to monitor and optimize query performance?
20 / 25
20. In SQL Server, what is the primary purpose of the DBCC SQLPERF command?
21 / 25
21. Which DBCC command in SQL Server is used to display performance-related information such as wait statistics and resource usage?
22 / 25
22. What does the DBCC WAITSTATS command in SQL Server provide information about?
23 / 25
23. Which DBCC command in SQL Server is used to display a list of performance counters and their values?
24 / 25
24. In SQL Server, what is the primary purpose of the DBCC PERFCOUNTERS command?
25 / 25
25. Which DBCC command in SQL Server is used to validate the configuration of the full-text search engine?
Your score is
Restart quiz