Which fact about DBCC CHECKDB in SQL Server 2008 R2 is not true?
- DBCC CHECKDB uses an internal database snapshot for the transactional consistency needed to perform these checks
- DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.
- DBCC CHECKDB does not check binary large objects (blobs) stored in the database.
- DBCC CHECKDB performs parallel checking of objects
I'm not sure I agree that's the same as checking BLOB's actually stored in the database, but I guess that's splitting hairs.