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
答案解析:有

微信扫一扫手机做题