• Interesting question and have learnt something today, however I have to agree that the answer is actually wrong, as if you want to add any options to the DBCC command you have to specify the database name - and that in ().

    So i would say that the answer should be the Error due to database name being required.

    Even adding the database name and once you get the command to actually run, you still get the error that "Repair statement not processed. Database needs to be in single user mode."

    If you have that, then you will get the actual answer that has been specified!

    I definitely feel we shoudl get a point for the first error at any rate!