ocp試題解析：11g-1Z0-051-v9.02-037題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp試題解析：11g-1Z0-051-v9.02-036題，完整題庫請點擊這里聯系老師咨詢了解
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正確，表結構以及表中所有數據都刪除。
B正確，提交所有待定的事務處理。
C錯誤，刪除表后，在數據庫中會失去表的所有數據以及與表關聯的所有索引。
D正確，保留視圖和同義詞，但不再有效。
E錯誤，表結構以及表中所有數據都刪除。
