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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1248918/