Oracle Database Administration I — Question 134

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

Answer options

• A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D. A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.
• E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Correct answer: C, D

Explanation

The correct answers, C and D, are accurate as a TRUNCATE command clears all rows for the current session and the table's structure is shared across sessions. Option A is incorrect because space allocation for GLOBAL TEMPORARY TABLES occurs when the table is created, not at session start. Option B is false since rows inserted by one session are not visible to other sessions. Option E is wrong because a DELETE command can typically be rolled back unless specified otherwise.