Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. Which of the following is used to determine the fragmentation for tables and indexes ?
  2. A.
    DBCC SHOWCONTIG
    B.
    DBCC CHECKDB
    C.
    DBCC CHECKCATALOG
    D.
    None of the mentioned

    View Answer

    Workspace

    Answer : Option A

    Explanation :

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


Be The First To Comment