You issued the following command:
SQL> DROP TABLE employees;
Which three statements are true?
A.
All uncommitted transactions are committed.
B.
All indexes and constraints defined on the table being dropped are also dropped.
C.
Sequences used in the employees table become invalid.
D.
The space used by the employees table is reclaimed immediately.
E.
The employees table can be recovered using the rollback command.
F.
The employees table is moved to the recycle bin.
Explanation:
A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the
transaction in progress (if any) will be committed.
B: Dropping a table invalidates dependent objects, such as indexes and constraints.
F: The DROP TABLE statement moves a table or object table to the recycle bin.
Incorrect:
Not B: In general sequences used in the table would not by affected when the table is dropped.
Not D: Unless you specify the PURGE clause, the DROP TABLE statement does not result in space being
released back to the tablespace for use by other objects, and the space continues to count toward the user’s
space quota.
Not E: Dropping a table invalidates dependent objects and removes object privileges on the table. If you want to
re-create the table, then you must regrant object privileges on the table, re-create the indexes, integrity
constraints, and triggers for the table, and respecify its storage parameters.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm