Oracle Database: Program with PL/SQL — Question 17

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?

Answer options

• A. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
• B. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
• C. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
• D. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.

Correct answer: D

Explanation

Option D is correct because DBMS_LOB.SETOPTIONS allows enabling compression on a table after it has been created without it. Options A, B, and C are incorrect as they misrepresent the capabilities of the DBMS_LOB functions; for instance, GETOPTIONS can be used with various data types, SETOPTIONS can operate on entire columns, and not all specified option types are accurate.