OCP 1Z0 053 23

23.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 
Answer: C

deduplication, encryption, and compression 仅能用于SecureFile 

即能用于blob 又可用于clob

SETOPTIONS Procedures

This procedure enables/disables CSCE features on a per-LOB basis, overriding the default LOB column settings.

Syntax

DBMS_LOB.SETOPTIONS (
   lob_loc             IN     BLOB,
   option_types        IN     PLS_INTEGER,
   options             IN     PLS_INTEGER);
 
DBMS_LOB.SETOPTIONS (
  lob_loc             IN     CLOB CHARACTER SET ANY_CS,
  option_types        IN     PLS_INTEGER, 
  options             IN     PLS_INTEGER);

Parameters

Table 69-69 SETOPTIONS Procedure Parameter

Parameter	Description
lob_loc	Locator for the LOB to be examined. For more information, see Operational Notes.
option_type	See DBMS_LOB Option Types
options	See DBMS_LOB Option Values

Table 69-2 DBMS_LOB Option Types

Constant	Definition
OPT_COMPRESS	CONSTANT BINARY_INTEGER := 1;
OPT_ENCRYPT	CONSTANT BINARY_INTEGER := 2;
OPT_DEDUPLICATE	CONSTANT BINARY_INTEGER := 4;

ALTER TABLE Usage Notes for Deduplication

ALTER TABLE syntax enables or disables LOB-level deduplication.

• This syntax alters the deduplication mode of the LOB column.

• Deduplication on existing LOBs can add significant latency.

• DBMS_LOB.SETOPTIONS can be used to enable or disable deduplication on individual LOBs.

• Deduplication can be specified at a table level or partition level. Deduplication does not span across partitioned LOBs.

• Deduplication is applicable only to SecureFiles.

  
  

ALTER TABLE Usage Notes for Compression

• This syntax alters the compression mode of the LOB column.

• Compression on existing LOBs can add significant latency.

• DBMS_LOB.SETOPTIONS can be used to enable or disable compression on individual LOBs.

• Compression can be specified at a table level or partition level.

• MEDIUM, and HIGH options provide varying degrees of compression. The higher the compression, the higher the latency incurred. The HIGH setting incurs more work, but will compress the data better. The default is MEDIUM.

• LOB compression is applicable only to SecureFiles.

ALTER TABLE Usage Notes for Encryption

ALTER TABLE is used to enable and disable LOB encryption for SECUREFILE LOBs. This syntax also enables LOB columns to be re-keyed with a new key or algorithm.

• ENCRYPT/DECRYPT options enable or disable encryption on all LOBs in the SecureFile column.

• SALT is the default for LOB encryption. NO SALT is not supported.

• The DECRYPT option converts encrypted columns to its cleartext form.

• Key management controls the ability to encrypt or decrypt.

• LOBs can be encrypted only on a per-column basis. A partitioned LOB has either all partitions encrypted or unencrypted.

• LOB encryption is applicable only to SecureFiles.