Which three statements are true about GLOBAL TEMPORARY TABLES?
A.
GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
B.
A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
C.
A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
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.
GLOBAL TEMPORARY TABLE space allocation occurs at session start.
The Answer Is:
B, D, E
This question includes an explanation.
Explanation:
Global temporary tables (GTTs) in Oracle have unique properties related to session-based visibility and data persistence:
B. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted: True, TRUNCATE is session-specific for GTTs and will remove all rows inserted by the session that issues the TRUNCATE command.
D. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions: The structure of a GTT is persistent and shared across sessions, but the data within is session-specific.
E. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted: The data in GTTs is private for the session, and when the session ends, the data is deleted automatically.
References:
Oracle Database Concepts and SQL Language Reference 12c, especially the sections on temporary tables.
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"