Microsoft
70-432 · Question #142
70-432 Question #142: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
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;
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.