Evaluate the SQL statement
DROP TABLE DEPT;
Which four statements are true of the SQL statement? (Choose four.)
A.
All synonyms based on the DEPT table are deleted.
B.
All data in the table is deleted, but the structure of the table is retained.
C.
All views based on the DEPT table are deleted.
D.
All pending transactions are committed.
E.
You cannot roll back this statement.
F.
All data in the table is deleted, and the table structure is also deleted.
G.
All indexes based on the DEPT table are dropped.
Explanation:
You cannot roll back DROP TABLE statement. All pending transactions related on this table are
committed. If the table is dropped, Oracle automatically drops any index, trigger and constraint
associated with the table as well. All data in the table is deleted, and the table structure is also
deleted.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 225
Chapter 5: Creating Oracle Database Objects