试题详情
- 单项选择题 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 atransaction ()
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
关注下方微信公众号,在线模考后查看
热门试题
- You have a very larg
- Which statemen
- Given: Whatistheres
- Consider the&e
- Which constraint can
- 在数据库中,()使数据库程序无须对整个表
- A PL/SQL procedure q
- 在关闭数据库时,要求当前尚未处理完成的事
- Examinethefollowings
- Your database&
- I guide
- Youwanttosetthefollo
- You want
- You have
- 限制从EMP表中只选出前5条记录的查语句
- Given: Whatistheres
- In your
- View the E
- 要重新启动ORACLE数据库服务器,首先
- Which statement most