Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged?
A)Bulk logged
B)Full
C)Simple
D)Complete

Question

Quizplus · Accepted Answer

The Full recovery model in SQL Server supports logging of all database changes, allowing for point-in-time restores and minimizing data loss in the event of a failure. The other recovery models have different considerations and limitations, such as reduced logging and only allowing for simple recovery in case of a failure (Simple model). Bulk logged model allows minimal logging for certain types of operations, but cannot be used with all operations. Complete is not a recognized recovery model in SQL Server.

Which of the Following Is a Type of Recovery Model