You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()
- AThe rows stay in the table only until session termination.
- BThe rows stay in the table only until the next transaction starts on the table.
- CThe rows are visible to all current sessions after the transaction is committed.
- DThe rows stay available for subsequent sessions after the transaction is committed