單項(xiàng)選擇題

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

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 temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

你可能感興趣的試題

單項(xiàng)選擇題

View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces.
What happens to the new DML operations in this scenario（）

A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces.
C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

單項(xiàng)選擇題

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）

A.CLOB
B.BLOB
C.BFILE
D.LONG RAW

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

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

你可能感興趣的試題

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）