多項選擇題

Which 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 onlineredo log files

你可能感興趣的試題

多項選擇題

After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN；
Which two statements are true（）

A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked

單項選擇題

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

A.When the data file of the undo tablespace is autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which statements are true about checkpointing（）

你可能感興趣的試題

After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN；
Which two statements are true（）

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）