Which three statements are true?

You issued the following command:
SQL> DROP TABLE employees;
Which three statements are true?

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



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Veronica

Veronica

The correct answer is A,B,F

9jansen

9jansen

B, C, F

josto

josto

Why B and not A?

josto

josto

Sorry, why C and not A i mean

josto

josto

Wich is the correct? I think A, B, F