1z0-062 題庫解析2

Examine the parameters for a database instance:

NAME TYPE VALUE

-------------------------------- -------------- ---------------

temp_undo_enabled boolean TRUE

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBSl

Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.

What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

A. Transactions write their undo in the system undo segment.

B. Transactions wait until space becomes available in undotbs1.

C. Transactions write their undo in a temporary tablespace.

D. Transactions fail.

Answer: D

【解析】

UNDO表空間中，活動事務使用的空間是不能夠被覆寫的。如果UNDO表空間空間滿，無法覆寫時，新的事務無法配置設定UNDO空間，是以會失敗。