Which of the following scripts would set the database recovery model for sys.database?
A)
B)
C)
D)
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.
Limited Time Offer
25%
Off
Kattie
15 days agoCelestina
21 days agoJanessa
26 days agoAlfred
1 month agoCarlton
1 month agoJimmie
1 month agoLoren
2 months agoMajor
2 months agoMauricio
2 months agoArdella
2 months agoGlenn
2 months agoDeeanna
2 months ago