Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

A.
only encryption and compression settings for all SecureFile LOBs

B.
only encryption and deduplication settings for only SecureFile CLOBs

C.
deduplication, encryption, and compression settings for all SecureFile LOBs

D.
deduplication, encryption, and compression settings only for SecureFile CLOBs

Explanation:
Refer to here.
DBMS_LOB.SETOPTIONS()

This procedure sets compression, deduplication and encryption features. It enables the
features to be set on a per-LOB basis, overriding the default LOB settings. This call incurs a
round trip to the server to make the changes persistent.



Leave a Reply 0

Your email address will not be published. Required fields are marked *