Oracle
1Z0-071 · Question #167
You issued the following command: SQL> DROP TABLE employees; Which three statements are true?
The correct answer is A. All uncommitted transactions are committed. B. All indexes and constraints defined on the table being dropped are also dropped. F. The employees table is moved to the recycle bin. See the full explanation below for the reasoning.
Question
You issued the following command:
SQL> DROP TABLE employees; Which three statements are true?
Options
- AAll uncommitted transactions are committed.
- BAll indexes and constraints defined on the table being dropped are also dropped.
- CSequences used in the employees table become invalid.
- DThe space used by the employees table is reclaimed immediately.
- EThe employees table can be recovered using the rollback command.
- FThe employees table is moved to the recycle bin
How the community answered
(58 responses)- A72% (42)
- C5% (3)
- D16% (9)
- E7% (4)
Community Discussion
No community discussion yet for this question.