ITPub博客

首页 > Linux操作系统 > Linux操作系统 > warehouse 请问temporary table可以创建index 和view吗

warehouse 请问temporary table可以创建index 和view吗

原创 Linux操作系统 作者:lijiebin 时间:2007-12-28 10:42:43 0 删除 编辑
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.

Answer : A, C, E

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8135069/viewspace-136094/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-10

  • 博文量
    145
  • 访问量
    151908