Oracle
1Z0-071 · Question #109
Examine these SQL statements that are executed in the given order: What will be the status of the foreign key EMP_MGR_FK?
The correct answer is C. It will remain disabled and can be re-enabled manually. See the full explanation below for the reasoning.
Question
Examine these SQL statements that are executed in the given order:
What will be the status of the foreign key EMP_MGR_FK?
Exhibit
Options
- AIt will be enabled and immediate.
- BIt will be enabled and deferred.
- CIt will remain disabled and can be re-enabled manually.
- DIt will remain disabled and can be enabled only by dropping the foreign key constraint and re-
How the community answered
(29 responses)- A10% (3)
- B7% (2)
- C79% (23)
- D3% (1)
Community Discussion
No community discussion yet for this question.
