ExamGecko
Question list
Search
Search

Question 14 - DS0-001 discussion

Report
Export

Which of the following scripts would set the database recovery model for sys.database?

A)

B)

C)

D)

A.
Option A
Answers
A.
Option A
B.
Option B
Answers
B.
Option B
C.
Option C
Answers
C.
Option C
D.
Option D
Answers
D.
Option D
Suggested answer: A

Explanation:

The script that would set the database recovery model for sys.database is option A. This script uses theALTER DATABASEstatement to modify the recovery model of the sys.database to full with no wait. The other options either have syntax errors, use incorrect keywords, or do not specify the recovery model correctly.Reference:CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.1 Given a scenario, perform common database maintenance tasks.

asked 02/10/2024
Colin Huisman
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first