Which is true for recovery models :
-
(a) In the Bulk-Logged recovery model, all transactions are logged
-
(b) In the Simple recovery model, all transactions are logged.
-
(c) In the Full recovery model, most transactions are minimally logged
-
(d) In the Simple recovery model, most transactions are minimally logged
SQL Server recovery models control logging behavior. In Simple recovery, bulk operations like BULK INSERT are minimally logged for performance - only page allocations are logged, not individual row changes. Full recovery logs all operations completely. Bulk-Logged recovery minimally logs bulk operations but fully logs other transactions. Option D is correct because Simple recovery specifically uses minimal logging for bulk operations to reduce log space and improve performance.