單項選擇題

View the Exhibit and examine the undo tablespace attributes.

Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces.
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

你可能感興趣的試題

多項選擇題

Which two statements are true regarding undo tablespaces（）

A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C.Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
D.An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

多項選擇題

Which three operations require undo data（）

A.committing a transaction
B.flashing back a transaction
C.recovering a failed transaction
D.running a read-consistent query
E.changing a tablespace status from READ ONLY to READ WRITE

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

Which two statements are true regarding undo tablespaces（）

Which three operations require undo data（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久