They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.
B.
Backup and recovery operations are available for these tables.
C.
If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.
D.
Their data is always stored in the default temporary tablespace of the user who created them.
E.
Indexes can be created on them.
F.
If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.
The Answer Is:
E, F
This question includes an explanation.
Explanation:
E. True. Indexes can be created on global temporary tables just like they can on permanent tables. The indexes on global temporary tables are also temporary and only exist for the duration of the session or transaction, based on how the table was defined.
F. True. If the ON COMMIT clause is specified as DELETE ROWS, then all rows in the global temporary table are deleted after each COMMIT or ROLLBACK within the transaction. This clause defines the scope of the data's persistence within the global temporary table.
[Reference: Oracle Database SQL Language Reference 12c, Global Temporary Tables - CREATE GLOBAL TEMPORARY TABLE, ]
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"