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:
http://www.sqlcourse.com/drop.html
A, B, F are correct. C of course is false. A Sequence is an independent object, and has nothing to do with the Employees table (other than some of the sequence generated numbers may have been used with the Employees table during DML statements, or even used as a default. But dropping the Employees table DOES NOT make ANY sequence invalid.
A: IS CORRECT! ( ALL uncommitted transactions are Committed – DDL commands commits immediately )
B: IS CORRECT!
C: IS WRONG (sequences used in table are not affected)
D: IS WRONG ( The space isn’t reclaimed immediately, Unless if used PURGE option )
E: IS WRONG ( The table just can recovered with clause FLASHBACK TABLE, sure if the PURGE option was not used)
F: IS CORRECT!
Donald & Karan are correct
Specify answer C please