Practice Questions--The Transaction Log

A checkpoint writes all committed transactions to the database unless another process has already written them.

A checkpoint writes all changed pages to the database unless another process has already written them.

A checkpoint writes all pages that were changed before the preceding checkpoint to the database unless another process has already written them.

A checkpoint writes all transactions that were committed before the preceding checkpoint to the database unless another process has already written them.

From Enterprise Manager, set the server properties entry for checkpoint interval.

From Enterprise Manager, set the server properties entry for recovery interval.

From Enterprise Manager, select the database, then set the database properties for checkpoint interval.

From Enterprise Manager, select the database, then set the database properties for recovery interval.

Set the recovery interval to zero.

Run the stored procedure sp_configure to set auto_recovery off.

Start the SQL Server service using net start mssqlserver with no recovery.

You can't turn off automatic recovery.

The recovery process doesn’t have to do anything. Because the transaction wasn't committed yet, it wasn't written out at the checkpoints.

In SQL Server 7.0, the recovery process must undo everything written to the database for this transaction from the checkpoint before the last one.

The recovery process must undo all changes written to the database for this transaction at each previous checkpoint.

The recovery process must undo all changes written to the database for this transaction by any process, including checkpoints.