SQL> DROPTABLE products;
What is theimplication of this command? (Choose all that apply.)
A. All dataalong with the table structure is deleted.
B. The pendingtransaction in the session is committed.
C. All indexeson the table will remain but they are invalidated.
D. All views andsynonyms will remain but they are invalidated.
E. All data inthe table are deleted but the table structure will remain.
答案: ABD
B. The pending transaction in the session is committed.-- 将提交会话中的待定事务。
Drop操作会提交会话中的待定事务,如下:
但是如果打开的是两个会话,则drop表的时候会报错,如下: