Oracle Database SQL — Question 114

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Answer options

• A. A GLOBAL TEMPORARY TABLE can have only one index.
• B. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view
• C. DML on GLOBAL TEMPORARY TABLES generates no REDO.
• D. A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.
• E. A GLOBAL TEMPORARY TABLE can have multiple indexes.
• F. A trigger can be created on a GLOBAL TEMPORARY TABLE.

Correct answer: B, E, F

Explanation

Options B, E, and F are correct because a GLOBAL TEMPORARY TABLE can indeed be referenced in views, can have multiple indexes, and triggers can be created on them. Options A, C, and D are incorrect as a GLOBAL TEMPORARY TABLE can have multiple indexes, DML operations do generate REDO, and a PUBLIC SYNONYM can be created for a GLOBAL TEMPORARY TABLE.