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

最新推荐文章于 2022-12-17 19:57:00 发布

转载最新推荐文章于 2022-12-17 19:57:00 发布 · 156 阅读

本文探讨了关于数据库中临时表的三个正确陈述：可以为临时表创建索引和视图；临时表始终创建在用户的临时表空间中；不会对临时表的数据获取DML锁。这些知识点对于理解临时表的行为至关重要。

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-136094/