Which three statements are true about GLOBAL TEMPORARY TABLES?
A.
A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.
B.
A GLOBAL TEMPORARY TABLE can have multiple indexes
C.
A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
D.
Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
E.
A GLOBAL TEMPORARY TABLE can have only one index.
F.
A trigger can be created on a GLOBAL TEMPORARY TABLE
The Answer Is:
B, C, D
This question includes an explanation.
Explanation:
A. Incorrect. There is no such restriction in Oracle that a global temporary table cannot have a public synonym. B. Correct. Global temporary tables can have more than one index, just like permanent tables. C. Correct. Global temporary tables can be referenced in the defining query of a view. However, any data selected by the view will be session-specific if it comes from the global temporary table. D. Correct. DML operations on global temporary tables do not generate redo log entries for the data changes; however, undo information for these tables is stored in the undo tablespace and can generate redo entries. E. Incorrect. As stated in B, global temporary tables can have more than one index. F. Correct. Triggers can be created on global temporary tables.
These properties are documented in the Oracle Database SQL Language Reference and Oracle Database Concepts Guide.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"