Oracle
1Z0-071 · Question #271
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
The correct answer is C. A trigger can be created on a GLOBAL TEMPORARY TABLE. D. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view. F. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO. See the full explanation below for the reasoning.
Question
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
Options
- AA GLOBAL TEMPORARY TABLE can have multiple indexes.
- BA GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.
- CA trigger can be created on a GLOBAL TEMPORARY TABLE.
- DA GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
- EA GLOBAL TEMPORARY TABLE can have only one index.
- FData Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
How the community answered
(29 responses)- A3% (1)
- B10% (3)
- C79% (23)
- E7% (2)
Community Discussion
No community discussion yet for this question.