2019年OCP 062近期新出现的考试原题-29题

文章来源：更新时间:2019/5/7 8:58:10

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，

2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：1015267481 验证：ocp

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

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表空间都用完了，那么新的事务就会失败。)