本文共 3024 字，大约阅读时间需要 10 分钟。
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官方文档：
PL/SQL functions and procedures that operate on BLOBs, CLOBs, NCLOBs, and BFILEs are summarized in the following:
To modify persistent LOB values, see
To read or examine LOB values, see
To create, free, or check on temporary LOBs, see
For read-only functions on external LOBs (BFILEs), see
To open or close a LOB, or check if LOB is open, see
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 |
| CONVERTTOCLOB | Converts a |
| 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 |
| 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 |
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 ( |
| GETLENGTH | Gets the length of the LOB value. |
| GETOPTIONS | Returns options (deduplication, compression, encryption) for |
| 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 |
| READ | Reads data from the LOB starting at the specified offset. |
| SETOPTIONS | Sets options (deduplication and compression) for a |
| SUBSTR | Returns part of the LOB value starting at the specified offset. |
转载地址：http://iutdi.baihongyu.com/