Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB?

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is
used to create a temporary LOB? (Choose two.)

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is
used to create a temporary LOB? (Choose two.)

A.
It can be used for transforming data in permanent internal LOBs.

B.
It is used only for the migration of BasicFile to the SecureFile format.

C.
It is used only for the migration of the LONG column to the LOB column.

D.
It creates a LOB variable that is not associated with any table and is stored in the user’s
temporary tablespace.

E.
It creates a LOB variable that is associated with a specific table and is temporarily stored in the
user’s default tablespace.

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

RF

RF

A is not clear:
A temporary LOB instance can be accessed and modified using appropriate OCI and DBMS_LOB statements, just as for regular permanent internal LOBs. To make a temporary LOB permanent, you must explicitly use the OCI or DBMS_LOB COPY command, and copy the temporary LOB into a permanent one.

in:http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#BABDDFDH

however:
You create a temporary LOB with the OCILobCreateTemporary() function. The parameters passed to this function include a value for the duration of the LOB. The default duration is for the length of the current session. All temporary LOBs are deleted at the end of the duration. Users can reclaim temporary LOB space by explicitly freeing the temporary LOB with the OCILobFreeTemporary() function. A temporary LOB is empty when it is created.

When creating a temporary LOB, you can also specify whether the temporary LOB is read into the server’s buffer cache.

To make a temporary LOB permanent, use OCILobCopy2() to copy the data from the temporary LOB into a permanent one. You can also use the temporary LOB in the VALUES clause of an INSERT statement, as the source of the assignment in an UPDATE statement, or assign it to a persistent LOB attribute and then flush the object. Temporary LOBs can be modified using the same functions that are used for standard LOBs.

in:http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/oci07lob.htm#LNOCI16522

B: It is used DBMS_REDEFINITION

C: http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_long_lob.htm#i1018656

D: This procedure creates a temporary BLOB or CLOB and its corresponding index in your default temporary tablespace.

Reply