【第33題】【063題庫】2019年OCP12c認證1Z0-063考試題庫大全
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢OCP 12c考試考3科，分別是071、062、063，之前071和062都已經做過解析，這里開始063題庫解析，希望對考063的同學有幫助，順利通過063考試。
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
-------------------------------------------------------
33題、You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects.
During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
A. DEALLOCATE UNUSED
B. SHRINK SPACE CASCADE
C. SHRINK SPACE COMPACT
D. ROW STORE COMPRESS BASIC
Answer: C
(解析：如果在釋放表碎片的釋放不影響當前的操作，那么應該在 shrink 的時候加上 compact 選項，等業務空閑的時候再 DEALLOCATE UNUSE，所以 shrink space 可以分為兩部分進行操作。)
