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