Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can

来源：互联网发布：南京软件外包公司编辑：程序博客网时间：2024/04/30 08:10

Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables
B. Both the data and structure of temporary tables can be exported
C. Temporary tables are always created in a user's temporary tablespace
D. The data inserted into a temporary table in a session is available to other sessions
E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables

Correct Answer: ACE

关于临时表的描述正确的是?

建临表两种类型:事务型和会话型. 事务类型:数据存在于事务处理期间. 会话类型:数据存在于会话期间.

A: 正确,临时表上可以创建索引,视图及触发器.

B: 错误,导出exp或expdp动作开启了一个新的会话,只能导出临时表定义,不会导出数据.

C: 正确,临时表使用用户临时表空间存储临时数据.

D: 错误,临时表中的数据是基于一个会话或者一个事务的,其他的会话不能访问到.

E: 正确,临时表是私有的,每个会话仅可查看和修改自己的DML数据,每个会话互不干涉, 不需要DML锁.

0 0