OCP-1Z0-051-题目解析-第37题

来源：互联网发布：golang redis incr 编辑：程序博客网时间：2024/06/06 08:34

37. You issued 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 along with the table structure is deleted.
B. The pending transaction in the session is committed.
C. All indexes on the table will remain but they are invalidated.
D. All views and synonyms will remain but they are invalidated.
E. All data in the table are deleted but the table structure will remain.

Answer: ABD
A：表中所有的数据和表结构都会被删除（正确，truncate和delete只会删除数据，drop会同时删除数据和表结构）
B：未提交的事务将会被提交（正确，事务中遇到drop或create等DDL语句时，会提交事务）
C：表中的索引将会保留，但会无效（错误，索引也会一起删除）
D：表中的视图和同义词将会保留，但是会无效（正确）
E：所有的数据将会被删除但是保留表结构（错误，表结构会一同删除）

0 0