2019年OCP 062近期新出現的考試原題-29題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢2018年的時候，OCP 11g考試題庫大更新，052 053出現了很多新題，
2019年，11g即將停考的前期，Oracle又出現了一次大變動，12c出現了很多新題，比如062 063題庫大更新
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
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表空間都用完了，那么新的事務就會失敗。)
