Which two statements are true about SecureFile LOB options? (Choose two.)
A.
The COMPRESSION HIGH option can be enabled only for CLOBs.
B.
The COMPRESSION HIGH option can be enabled for all internal LOBs.
C.
The DECRYPT option can be used to remove encryption only if the LOB column is empty.
D.
The DECRYPT option can be used to remove encryption from LOB columns that are empty or
contain data.
B,D
For B:
I haven’t found any limitation for using HIGH COMPRESSION in Oracle documentation.
For D:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABGEJDE
Look for ALTER TABLE Usage Notes for Encryption
“The DECRYPT option converts encrypted columns to its cleartext form.”
B,D