• I firmly believe the author of this question did NOT perform due diligence when selecting possible answers.

    The original statement

    Check all that apply that are true about

    In the case of the master and temp db the question statement should have been: Check all that may apply and are true about

    From Books On Line

    DBCC CHECKDB

    Runs DBCC CHECKALLOC on the database.

    Runs DBCC CHECKTABLE on every table and view in the database.

    Runs DBCC CHECKCATALOG on the database

    From DBCC CHECKALLOC.

    http://technet.microsoft.com/en-us/library/aa258809(SQL.80).aspx

    Note NOINDEX is maintained for backward compatibility only. All indexes are checked when executing DBCC CHECKALLOC.

    So in effect using DBCC CHECKDB which in turn invokes DBCC CHECLALLOC the correct answer is: does check all indexes

    On the last possible answer also see:

    CHECK STATISTICS

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=158623

    (Bold facing entered by myself to drive home my arguement)

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]