Multiple choice technology databases

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

  1. The COMPRESSION HIGH option can be enabled only for CLOBs.

  2. The COMPRESSION HIGH option can be enabled for all internal LOBs.

  3. The DECRYPT option can be used to remove encryption only if the LOB column is empty.

  4. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

COMPRESSION HIGH is available for all internal LOB types (BLOB, CLOB, NCLOB), not just CLOBs, making option B correct. The DECRYPT option can remove encryption from LOB columns regardless of whether they contain data or are empty, making option D correct. Option A is incorrect because compression isn't limited to CLOBs, and option C is incorrect because the DECRYPT option works on non-empty columns too.

Keep practicing — related questions