Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the
SQL statement? (Choose four)
A.
All data in the table is deleted, but the structure of the table is retained.
B.
All synonyms based on the DEPT table are deleted.
C.
All data in the table is deleted, and the table structure is also deleted.
D.
All indexes based on the DEPT table are dropped.
E.
Allviews based on the DEPT table are deleted.
F.
All pending transactions are committed.
G.
You cannot roll back this statement.
All views and PL/SQL program units dependent on a dropped table remain, yet become invalid (not usable). See “Managing Object Dependencies” for information about how the database manages dependencies.
All synonyms for a dropped table remain, but return an error when used.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505