本文详细解释了SQL中DROP TABLE命令的执行效果，包括数据及结构的删除、索引的消失、视图和同义词的保留但失效，以及挂起事务的自动提交等关键行为。
Q11. You issue the following command to drop the PRODUCTS table:
SQL > DROP TABLE products;
Which three statements are true about the implication of this command?
A. All data in the table is deleted but the table structure remains.
B. All data along with the table structure is deleted.
C. All views and synonyms on the table remain but they are invalidated.
D. A pending transaction in the session is committed.
SQL > DROP TABLE products;
Which three statements are true about the implication of this command?
A. All data in the table is deleted but the table structure remains.
B. All data along with the table structure is deleted.
C. All views and synonyms on the table remain but they are invalidated.
D. A pending transaction in the session is committed.
E. All indexes on the table remain but they are invalidated.
Correct Answer: BCD
A.表中的所有数据都被删除，但表结构仍然存在。
B.删除表格结构中的所有数据包括表结构。
C.表格中的所有视图和同义词仍然存在，但它们失效。
D.会话中的待处理事务会被提交。
E.表中的所有索引仍然保留，但它们失效。
解析：
Drop 表，数据和结构会一起被删除；
Index 会被删除；
view 和sysnonym 会保留但是会失效；
挂起的事务会提交掉。
扫一扫
19
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
