176.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report

最新推荐文章于 2025-05-12 09:10:51 发布

原创最新推荐文章于 2025-05-12 09:10:51 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-052

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文探讨了在数据库中创建临时表的方法，并重点分析了带有ON COMMIT PRESERVE ROWS选项的全局临时表的行为。此类表中的数据在提交事务后并不会立即清除，而是保留到用户会话结束。文章通过一个具体示例，解释了不同情况下临时表中数据的持久性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.
答案：A
解析：这里考察的是临时表
on commit [preserve|delete] rows
指明临时表中行的有效期，
delete 说明这些行在事务的末尾要被删除，
preserve 说明这些行在用户会话的末尾被删除
如果没有指定on commit 那么默认为 delete