Oracle
1Z0-082 · Question #119
Examine these SQL statements which execute successfully: Which two statements are true after execution?
The correct answer is C. The foreign key constraint will be disabled. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Examine these SQL statements which execute successfully:
Which two statements are true after execution?
Exhibit
Options
- AThe primary key constraint will be enabled and deferred.
- BThe foreign key constraint will be enabled and deferred.
- CThe foreign key constraint will be disabled.
- DThe foreign key constraint will be enabled and immediate.
- EThe primary key constraint will be enabled and immediate.
How the community answered
(59 responses)- A2% (1)
- B5% (3)
- C81% (48)
- D10% (6)
- E2% (1)
Topics
#primary key constraint#foreign key constraint#deferred constraints#constraint states
Community Discussion
No community discussion yet for this question.