PrepAway - Latest Free Exam Questions & Answers

Tag: a power failure dbcc checkdb dbcc checkfilegroup

which encompass the system catalogs.What should he do?

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?

What is the result of issuing this statement?

You are the database administrator for a banking firm. Your company stores information regarding all itscustomers in a database named Customers . A power failure causes your server to shut down unexpectedly. Thiscauses the database to close improperly. After restoring the power, you restart the server, and start up the database. To ensure that the database is notcorrupted, you issue the following statement:
DBCC CHECKDB;
What is the result of issuing this statement? (Choose all that apply.)