Oracle Database SQL — Question 237

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

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 rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• F. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

Correct answer: C, D, F

Explanation

Option C is correct because a TRUNCATE command only affects the data in the issuing session's instance of the GLOBAL TEMPORARY TABLE. Option D is accurate as the data is session-specific and is cleared when the session ends. Option F is also correct since the definition of a GLOBAL TEMPORARY TABLE is shared across sessions, but the data remains session-specific. Options A, B, and E are incorrect because space allocation for GLOBAL TEMPORARY TABLES does not occur at session start, rows are not accessible by other sessions, and DELETE commands can be rolled back if not committed.