Dietmar Weickert (8/17/2009)
It is comprehensive and validates the logical and physical integrity of all the objects in the specified database including tables, indexes, indexed views & statistics.
What's wrong with this statement?
I picked this option and it's the only reason I was wrong, be nice to know why that particular option is incorrect (I'm assuming it's the stats, but can't confirm that in BOL anywhere).
For the few mentioning that DBCC CHECKDB does not fail on master or tempdb, you're right, but the way I read the question, it's not stating otherwise is it?
--------I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams