OCP-1Z0-052-V8.02-176题

来源：互联网发布：搜图片出处软件编辑：程序博客网时间：2024/05/03 06:00

176. 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 is committed.

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

Answer: A

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/13015519

下列子句控制着行的生存期：

• ON COMMIT DELETE ROWS ：指定插入行的生存期仅为事务处理的持续时间

• ON COMMIT PRESERVE ROWS ：指定插入行的生存期为会话的持续时间