Which two statements are true about GLOBAL TEMPORARY TABLES? (Choose two.)
Which two statements are true about GLOBAL TEMPORARY TABLES? (Choose two.)
A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions, meaning the table structure is shared and can be accessed by those with necessary permissions. However, each session sees only its own data. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for that session to be deleted, which is a session-specific operation.
C,D are true The global temporary table definition is visible to all sessions. Only the data you insert into a session is visible to that session.
A – false; space is allocated when it is requested/needed, see https://asktom.oracle.com/pls/apex/asktom.search?tag=about-temporary-tables B – false; table is visible to other sessions but each session can see only its own data, see https://www.oracletutorial.com/oracle-basics/oracle-global-temporary-table/ C – true D – true E – false; commit and rollback are possible in Global Temporary Tables
Provided answer are corrects.
D C are correct