Oracle
1Z0-082 · Question #115
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
The correct answer is B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session C. GLOBAL TEMPORARY TABLE space allocation occurs at session start. F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
Options
- AA TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE
- BGLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session
- CGLOBAL TEMPORARY TABLE space allocation occurs at session start.
- DAny GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- EA GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- FA DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
How the community answered
(18 responses)- A17% (3)
- B72% (13)
- D6% (1)
- E6% (1)
Topics
#global temporary tables#session-level data#TRUNCATE#DELETE rollback
Community Discussion
No community discussion yet for this question.