Oracle Database Advanced PL SQL 12c 1z0 148

Question : 13 of 54

Marks: +1, -0

Which statement is true about internal and external LOBs?

An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.
A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
Internal and external LOBs can be written using DBMS_LOB.
After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.

Go to Question:

Prev Question

Next Question