Oracle Database Administration I — Question 3

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

Answer options

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

Correct answer: A, D, E

Explanation

The correct answers are A, D, and E. A states that the TRUNCATE command only affects the current session's rows, which is true. D is correct because rows are cleared upon session termination, and E is true as the table's structure is shared across sessions. Options B and C are incorrect because rows inserted by one session are not visible to others, and space allocation does not happen at the session start but when the table is created. F is also incorrect as a DELETE command can be rolled back if it's within a transaction.