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

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

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Answer: A

Explanation:

The script that would set the database recovery model for sys.database is option A. This script uses the ALTER DATABASE statement 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.