You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01.
You discover that a power failure occurred on the storage area network (SAN) where Certkiller -DB01 is located. A Domain.com employee named Clive Wilson is a junior technician in the Research and Development department. You inform Clive Wilson to check the allocation as well as the structural and logical integrity of all databases, which encompass the system catalogs.
What should he do?
A.
DBCC CHECKTABLE needs to be executed for every table.
B.
Clive Wilson needs to execute DBCC CHECKDB.
C.
It is important that Clive Wilson is able to execute DBCC CHECKCATALOG.
D.
Clive Wilson needs to execute DBCC CHECKFILEGROUP for every filegroup.
Explanation:
DBCC CHECKDB will check the logical and physical integrity of all the objects in the specified database by:-
1. Running DBCC CHECKALLOC on the database.
2. Running DBCC CHECKTABLE on every table and view in the database.
3. Running DBCC CHECKCATALOG on the database.
4. Validating the contents of every indexed view in the database.
5. Validating the Service Broker data in the database