Oracle 11G OCP 1Z0-053 23

（23）Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

A. only encryption and compression settings for all SecureFile LOBs

B. only encryption and deduplication settings for only SecureFile CLOBs

C. deduplication,encryption,and compression settings for all SecureFile LOBs

D. deduplication,encryption,and compression settings only for SecureFile CLOBs

答案：（C）

解析：

參考DBMS_LOB.SETOPTIONS過程

這個過程在per-LOB基礎上開啟或禁用CSCE功能, 覆蓋預設的LOB列的設定.

DBMS_LOB包中常量的定義:

COMPRESS_OFF, COMPRESS_ON

DEDUPLICATE_OFF, DEDUPLICATE_ON

ENCRYPT_OFF, ENCRYPT_ON

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1248918/，如需轉載，請註明出處，否則將追究法律責任。