【2019】OCP考試062題庫近期考試原題解析-第55題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢2018年的時候,OCP 11g考試題庫大更新,052 053出現了很多新題,
2019年,11g即將停考的前期,Oracle又出現了一次大變動,12c出現了很多新題,比如062 063題庫大更新
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:http://ke.qq.com/course/326223
OCP解析群資料分享:1015267481 驗證:ocp
-------------------------------------------------------
55題、choose two
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 generates lots of redo.
Which two actions would you take to solve this problem?
A) Increase the size of the redo log buffer.
B) Enable undo retention guarantee.
C) Increase the size of the temporary tablespace.
D) Enable Automatic Memory Management (AMM).
E) Enable temporary undo for the database.
Answer:CE
(解析:12c有個針對臨時表的dml操作的解決方案,為了減少redo的產生和undo表空間的使用,可以啟用臨時undo的功能,這樣子把undo數據存放在臨時表空間。)