多项选择题
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.
多项选择题 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（）
单项选择题 Given below is a list of scenarios： 1）A user terminates his session abnormally. 2）The connection between the server and the client application terminates because of a network failure. 3）A schema is accidentally dropped. 4）The tablespace is accidentally dropped from the database. 5）The hard disk gets corrupted and the data files in the disk are lost. 6）The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery（）