Oracle Database: Program with PL/SQL — Question 23

Which two statements are true about the DBMS_ LOB package?

Answer options

• A. DBMS_LOB.COMPARE can compare parts of two LOBs.
• B. DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
• C. DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
• D. If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.
• E. Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.

Correct answer: D, E

Explanation

Option D is correct because it highlights the requirement of locking the row when dealing with a temporary LOB. Option E is also accurate since both LOB instances must be present to perform the conversion. Options A, B, and C are incorrect as they do not pertain to the necessary conditions for using DBMS_LOB.CONVERTTOBLOB.