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.
B,D
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#BABDDFDH
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#i1015757
“Temporary LOBs can be either BLOBs, CLOBs, or NCLOBs.” – A is wrong
“Security is provided through the LOB locator. Only the user who created the temporary LOB is able to see it. Locators are not expected to be able to pass from one user’s session to another. Even if someone did pass a locator from one session to another, they would not access the temporary LOBs from the original session. Temporary LOB lookup is localized to each user’s own session. Someone using a locator from somewhere else is only able to access LOBs within his own session that have the same LOB ID. Users should not try to do this, but if they do, they are not able to affect anyone else’s data.” – B is correct
“There is no support for consistent read (CR), undo, backup, parallel processing, or transaction management for temporary LOBs. Because CR and rollbacks are not supported for temporary LOBs, you must free the temporary LOB and start over again if you encounter an error.” – C is wrong
“A temporary LOB is empty when it is created. By default, all temporary LOBs are deleted at the end of the session in which they were created. If a process dies unexpectedly or if the database crashes, then temporary LOBs are deleted, and the space for temporary LOBs is freed.” – D is correct
“Your temporary tablespace stores the temporary LOB data.” – E is incorrect
B D E
E) is incorrect, the temporary LOB is stored into TEMP table space.
OPS B ,D