Oracle OCP 1Z0-050（24题）解析

Oracle OCP 1Z0-050（24题）解析

QUESTION 24:

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

A. only encryption and deduplication settings for only SecureFile CLOBs

B. only encryption and compression settings for all SecureFile LOBs

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

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

Answer: C

解析；

参考Oracle官方文档：

https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_api_overview.htm#i1032166

PL/SQL Functions and Procedures for LOBs

PL/SQL functions and procedures that operate on BLOBs, CLOBs, NCLOBs, and BFILEs are summarized in the following:

• To modify persistent LOB values, see Table 7-4

• To read or examine LOB values, see Table 7-5

• To create, free, or check on temporary LOBs, see Table 7-6

• For read-only functions on external LOBs (BFILEs), see Table 7-7

• To open or close a LOB, or check if LOB is open, see Table 7-8

PL/SQL Functions and Procedures to Modify LOB Values

Here is a table of DBMS_LOB procedures:

Table 7-4 PL/SQL: DBMS_LOB Procedures to Modify LOB Values

Function/Procedure	Description
APPEND	Appends the LOB value to another LOB
CONVERTTOBLOB	Converts a CLOB to a BLOB
CONVERTTOCLOB	Converts a BLOB to a CLOB
COPY	Copies all or part of a LOB to another LOB
ERASE	Erases part of a LOB, starting at a specified offset
FRAGMENT_DELETE	Delete the data from the LOB at the given offset for the given length
FRAGMENT_INSERT	Insert the given data (< 32KBytes) into the LOB at the given offset
FRAGMENT_MOVE	Move the given amount of bytes from the given offset to the new given offset
FRAGMENT_REPLACE	Replace the data at the given offset with the given data (< 32kBytes)
LOADFROMFILE	Load BFILE data into a persistent LOB
LOADCLOBFROMFILE	Load character data from a file into a LOB
LOADBLOBFROMFILE	Load binary data from a file into a LOB
SETOPTIONS	Sets LOB features (deduplication and compression)
TRIM	Trims the LOB value to the specified shorter length
WRITE	Writes data to the LOB at a specified offset
WRITEAPPEND	Writes data to the end of the LOB

PL/SQL Functions and Procedures for Introspection of LOBs

Table 7-5 PL/SQL: DBMS_LOB Procedures to Read or Examine Internal and External LOB values

Function/Procedure	Description
COMPARE	Compares the value of two LOBs
GETCHUNKSIZE	Gets the chunk size used when reading and writing. This only works on persistent LOBs and does not apply to external LOBs (BFILEs).
GETLENGTH	Gets the length of the LOB value.
GETOPTIONS	Returns options (deduplication, compression, encryption) for SECUREFILE LOBs.
GET_STORAGE_LIMIT	Gets the LOB storage limit for the database configuration.
INSTR	Returns the matching position of the nth occurrence of the pattern in the LOB.
ISSECUREFILE	Returns TRUE if the BLOB or CLOB locator passed to it is for a SECUREFILE LOB or FALSE if it is not.
READ	Reads data from the LOB starting at the specified offset.
SETOPTIONS	Sets options (deduplication and compression) for a SECUREFILE LOB. overriding the default LOB column settings. Incurs a server round trip.
SUBSTR	Returns part of the LOB value starting at the specified offset.