單項(xiàng)選擇題

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）

A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporarytablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

你可能感興趣的試題

單項(xiàng)選擇題

In which situation may 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

單項(xiàng)選擇題

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）

A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）

你可能感興趣的試題

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

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