Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm
Question:
Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?
Options:
DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
DBMS_LOSETOPTIONS can perform operations on individual SecureFiles but not an entire column.
DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
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
The Correct Answer for this Question is
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.
