Home » Oracle » 1z0-061 » 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.
Correct Answer: ABF
Explanation/Reference:
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.
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm
Download Printable PDF. VALID exam to help you PASS.
|
|