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
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
- Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can
- 177.Which three statements are correct about temporary tables? (Choose three.)
- 42.Which three statements are true regarding views? (Choose three.)
- 135 Which three statements are true about windows? (Choose three.) A. Only one window can be open at
- 155 Which three statements are true about windows? (Choose three.) A. Only one window can be open at
- 134 Which three statements are true about persistent configuration? (Choose three.) A. A user cannot
- 154 Which three statements are true about persistent configuration? (Choose three.) A. A user cannot
- 139.Which three statements are true about multiple-row subqueries? (Choose three.)
- 21.Which three statements are true about logical structures of the Oracle database? (Choose three.)
- 133. Which three statements are true? (Choose three.)
- 135.Which three statements are true regarding subqueries? (Choose three.)
- 053-6 Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose
- 46.Which statements are correct regarding indexes? (Choose all that apply.)
- 118.Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
- 128 Which two statements are true about a job chain? (Choose two.) A. A job chain can contain a nest
- 171.Which three statements/commands would cause a transaction to end? (Choose three.)
- 167.Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choo
- OCP 053 31.Which two statements are correct about database transportation? (Choose two.)
- 3505: [Cqoi2014]数三角形 组合数学
- Oracle-本地连接没问题,远程连接有问题解决方案
- 使用TabLayout小总结(Pager.setCurrentItem())
- JVM学习篇(2)之类相关内容
- [bzoj1189][HNOI2007]紧急疏散
- Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can
- Android利用Fiddler进行网络数据抓包
- DOM事件详解(二)
- 战五渣系列之三(6个命令)
- Windows + IDEA + SBT 打造Spark源码阅读环境
- NS-2.35中添加gpsr
- 浅谈线程
- Cocos2dx下的selector对比!
- 构建基于Nginx的web服务器