Oracle
1Z0-071 · Question #331
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
The correct answer is D. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions. E. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted. F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE. See the full explanation below for the reasoning.
Question
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
Options
- AGLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session
- BGLOBAL TEMPORARY TABLE space allocation occurs at session start.
- CA DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- DA GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.
- EAny GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- FA TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE
How the community answered
(28 responses)- A7% (2)
- B11% (3)
- C4% (1)
- D79% (22)
Community Discussion
No community discussion yet for this question.