OCP 12c考試考3科，分別是071、062、063，之前071和062都已經(jīng)做過解析，這里開始063題庫(kù)解析，希望對(duì)考063的同學(xué)有幫助，順利通過063考試。

OCP解析公開課時(shí)間：【每周五晚8點(diǎn)】

OCP解析公開課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗(yàn)證：ocp

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

29題、Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.

Which two actions would you take to solve this problem?

A. Enable temporary undo for the database.

B. Enable undo retention guarantee.

C. Increase the size of the redo log buffer.

D. Enable Automatic Memory Management (AMM).

E. Increase the size of the temporary tablespace.

Answer: A,E

(解析：12c 對(duì)臨時(shí)表進(jìn)行 dml 操作時(shí)為了減少對(duì) undo 表空間的影響，可以啟用 temporary undo 功能，這樣子就會(huì)在臨時(shí)表空間創(chuàng)建臨時(shí) undo 段，以避免對(duì)普通 undo 的占用。)