Microsoft
70-432 · Question #142
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…
The correct answer is B. Run the following Transact-SQL statements. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should implement the statement below:
- BRun the following Transact-SQL statements.
- Cmdf'); ALTER DATABASE Finance SET MULTI_USER;
- DYou should utilize the following Transact-SQL statement.
- EALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;
- FALTER DATABASE TesterDB
- Gmdf'); ldf'); ALTER DATABASE TesterDB SET ONLINE;
How the community answered
(52 responses)- B75% (39)
- C8% (4)
- D13% (7)
- E2% (1)
- G2% (1)
Community Discussion
No community discussion yet for this question.