单选题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 

题目
单选题
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()
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 is committed.

D

The rows stay available for subsequent sessions after the transaction is committed


相似考题
参考答案和解析
正确答案: A
解析: 暂无解析