Which two statements are true about SecureFile LOB options? (Choose two.)

The correct answer is B. The COMPRESSION HIGH option can be enabled for all internal LOBs. D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or. I haven't found any limitation for using HIGH COMPRESSION in Oracle documentation. 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…

Handling Large Objects

Question

Options

AThe COMPRESSION HIGH option can be enabled only for CLOBs.
BThe COMPRESSION HIGH option can be enabled for all internal LOBs.
CThe DECRYPT option can be used to remove encryption only if the LOB column is empty.
DThe DECRYPT option can be used to remove encryption from LOB columns that are empty or

How the community answered

(31 responses)

A
6% (2)
B
81% (25)
C
13% (4)

Explanation

I haven't found any limitation for using HIGH COMPRESSION in Oracle documentation. 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."

Topics

#SecureFiles#LOB compression#LOB encryption#DECRYPT option

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice