【12c】OCP 062近期新出现的考试原题-第29题

第29题、choose one

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  UNDOTBS1

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 wait until space becomes available in UNDOTBS1.

B) Transactions write their undo in a temporary tablespace.

C) Transactions fail.

D) Transactions write their undo in the SYSTEM undo segment.

Answer：C

(解析：该题故意弄了几个参数的值，特别是temp_undo_enabled，然后告诉我们Resumable space功能没有打开，以及默认undo表空间都用完了，那么新的事务就会失败。来自3组：1015267481)