Which of the following is used to determine the fragmentation for tables and indexes ? Options: A . &nbspDBCC SHOWCONTIG B . &nbspDBCC CHECKDB C . &nbspDBCC CHECKCATALOG D . &nbspNone of the mentioned

Which of the following is used to determine the fragmentation for tables and in

Question

Which of the following is used to determine the fragmentation for tables and indexes ?

Options:

A . DBCC SHOWCONTIG

B . DBCC CHECKDB

C . DBCC CHECKCATALOG

D . None of the mentioned

Answer: Option A

In SQL Server 2005 DBCC SHOWCONTIG remains a viable short term option to determine the database fragmentation.

Was this answer helpful ?

Next Question

Question 1. Which of the following scenario prefers not to use database snapshots ? ....

Question 2. Which of the following SQL Server tools is used to enhance data management and governance ....

Question 3. In which of the following modes, the database is read-only ? ....

Question 4. Which of the following is policy based management tip related to administration ? ....

Question 5. How many types of recovery model is provided by SQL Server ? ....

Question 6. SQL Agent Job definitions are specified in which database ? ....

Question 7. Which is not the preferred way of copying a database ? ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0