Oracle
1Z0-071 · Question #133
You issued this command: SQL > DROP TABLE employees; Which three statements are true? (Choose three.)
The correct answer is B. If there is an uncommitted transaction in the session, it is committed. C. All indexes and constraints defined on the table being dropped are also dropped. F. The EMPLOYEES table may be moved to the recycle bin. See the full explanation below for the reasoning.
Question
You issued this command:
SQL > DROP TABLE employees; Which three statements are true? (Choose three.)
Options
- ASequences used in the EMPLOYEES table become invalid.
- BIf there is an uncommitted transaction in the session, it is committed.
- CAll indexes and constraints defined on the table being dropped are also dropped.
- DThe space used by the EMPLOYEES table is always reclaimed immediately.
- EThe EMPLOYEES table can be recovered using the ROLLBACK command.
- FThe EMPLOYEES table may be moved to the recycle bin.
How the community answered
(25 responses)- A4% (1)
- B72% (18)
- D8% (2)
- E16% (4)
Community Discussion
No community discussion yet for this question.