执行DROP TABLE命令会删除表及其所有索引、域索引和定义在表上的触发器，无论创建者是谁或它们位于哪个模式下。如果表分区，相应的局部索引分区也会被删除。此外，DROP TABLE作为DDL语句，会导致未提交的事务被自动提交。
一、原题
二、题目翻译
You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)
A. All data in the table are deleted but the table structure will remain
B. All data along with the table structure is deleted
C. All views and synonyms will remain but they are invalidated
D. The pending transaction in the session is committed
E. All indexes on the table will remain but they are invalidated
答案: B,C,D
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)
A. All data in the table are deleted but the table structure will remain
B. All data along with the table structure is deleted
C. All views and synonyms will remain but they are invalidated
D. The pending transaction in the session is committed
E. All indexes on the table will remain but they are invalidated
答案: B,C,D
二、题目翻译
PRODUCTS表执行drop table products;命令,
这个命令执行后会发生什么结果?
这个命令执行后会发生什么结果?
最低0.47元/天 解锁文章
667
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
