adplus-dvertising
frame-decoration

Question

The _______ recovery model is a special-purpose model that works in a similar manner to the full recovery model.

a.

Simple

b.

Full

c.

bulk-logged

d.

None of the mentioned

Answer: (c).bulk-logged

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The _______ recovery model is a special-purpose model that works in a similar manner to the full recovery model.

Similar Questions

Discover Related MCQs

Q. Which of the following statement is used for changing Recovery Model with T-SQL?

Q. Backing up your SQL Server database is essential for _______ your data.

Q. Point out the correct statement.

Q. How many types of backups are provided by SQL Server?

Q. Features provided by SQL Server backups include ________________

Q. Point out the wrong statement.

Q. Backup can occur while the database is in ___________ state.

Q. Which of the following is not a type of backup?

Q. _________ backups represent the whole database at the time the backup finished.

Q. Which of the following backups contain transaction logs?

Q. ____________ contains data from only some of the filegroups in a database.

Q. The SQL Server Maintenance Solution comprises scripts for running __________ maintenance on all editions of Microsoft SQL Server.

Q. Point out the correct statement related to database maintenance.

Q. Which of the following is used to determine the fragmentation for tables and indexes?

Q. Which of the following is used to Validate the database objects?

Q. Point out the wrong statement.

Q. Which of the following command defragments clustered and secondary indexes of the specified table?

Q. ______________ runs UPDATE STATISTICS against all user-defined tables in the current database.

Q. Purpose of DBCC DBREINDEX command is to ____________

Q. What types of database maintenance should be executed?