You executed this command to create a temporary table:
SQL>CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class
CHAR(20)) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a
transaction?
A.
The rows stay in the table only until session termination
B.
The rows stay in the table only until the next transaction starts on the table
C.
The rows are visible to all current sessions after the transaction in committed
D.
The rows stay available for subsequent sessions after the transaction is committed
The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for the whole session, or just for the current transaction.
PRESERVE ROWS
The rows of the table will be preserved.
ON COMMIT
Specifies the action taken on the global temp table when COMMIT .