OCP-1Z0-051-2015-42题

QUESTION NO: 42
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  所有表的序列仍存在，但不再有效
Answer: B,C,D

Explanation:语句：SQL>DROP TABLE products; drop命令含义

A 错误，表结构以及表中所有数据都删除。

B 正确，表结构以及表中所有数据都删除。

C 正确，保留视图和同义词，但不再有效

D 正确，提交所有待定的事务处理。

E 错误，删除表后，在数据库中会失去表的所有数据以及与表关联的所有索引。