177.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 the 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.
答案:ACE
解析:
一、临时表
1.另外一种创建方式
create global temporary table wahaha
on commit preserve rows
as
select * from emp where job not like 'SAL%';
2.临时表和普通表一样,可以创建索引、视图和触发器、可以导入导出程序或者数据泵对临时表的定义进行导入导出
但是无法将数据导出
3.临时表中的数据只对当前Session有效,每个Session都有自己的临时数据,并且不能访问其它Session的临时表中的数据。因此,临时表不需要DML锁。
这里主要说C选项,如果用户没有临时表空间的话,那么system会作为他的临时表空间,排序和临时表也会存储在里面
A.Indexes and views can be created on temporary tables.
B.Both the data and the 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.
答案:ACE
解析:
一、临时表
1.另外一种创建方式
create global temporary table wahaha
on commit preserve rows
as
select * from emp where job not like 'SAL%';
2.临时表和普通表一样,可以创建索引、视图和触发器、可以导入导出程序或者数据泵对临时表的定义进行导入导出
但是无法将数据导出
3.临时表中的数据只对当前Session有效,每个Session都有自己的临时数据,并且不能访问其它Session的临时表中的数据。因此,临时表不需要DML锁。
这里主要说C选项,如果用户没有临时表空间的话,那么system会作为他的临时表空间,排序和临时表也会存储在里面