單項(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

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

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（）

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

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（）