Which statements are true about temporary LOBs? (Choose all that apply.)
A.
They can be created only for CLOB and NCLOB data.
B.
They can be accessed only by the user who creates them.
C.
They generate more redo information than persistent LOBs.
D.
They exist for the duration of the session in which they are created.
E.
They are stored temporarily in the default tablespace of the user who creates them.
The following are the features of temporary LOBs:
• Data is stored in your temporary tablespace, not in tables.
• Temporary LOBs are faster than persistent LOBs, because they do not generate redo or
rollback information.
• Temporary LOBs lookup is localized to each user’s own session. Only the user who creates
a temporary LOB can access it, and all temporary LOBs are deleted at the end of the session
in which they were created.
• You can create a temporary LOB by using DBMS_LOB.CREATETEMPORARY.
B,D,E
http://docs.oracle.com/cd/B10501_01/appdev.920/a96591/adl11tmp.htm
The answers are B and D. E is incorrect, user’s default tablespace is not the same as temporary tablespace. And the doc suggets it’s stored in temporary tablespace.