Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called TesterDB
for Home.com. The data file and the transaction log file which are located on the D: drive
that owns only 10 percent useful space. You should make sure that you move both files to
the G: drive.
Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called TesterDB
for Home.com. The data file and the transaction log file which are located on the D: drive
that owns only 10 percent useful space. You should make sure that you move both files to
the G: drive.
Which is the correct answer?

A.
You should implement the statement below: ALTER DATABASE Finance SET
RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and

B.
Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY
FILE(NAME = Finance_Data, FILENAME =

C.
mdf’); ALTER DATABASE Finance SET MULTI_USER;

D.
You should utilize the following Transact-SQL statement.

E.
ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;

F.
ALTER DATABASE TesterDB

G.
mdf’); ldf’); ALTER DATABASE TesterDB SET ONLINE;



Leave a Reply 0

Your email address will not be published. Required fields are marked *