多項(xiàng)選擇題

Which two statements are true about checkpointing（）

A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.

你可能感興趣的試題

多項(xiàng)選擇題

Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.

單項(xiàng)選擇題

ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation（）

A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction.

Which two statements are true about checkpointing（）

你可能感興趣的試題

Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）

ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation（）