Oracle
1Z0-071 · Question #310
Examine these SQL statements which execute successfully: Which two statements are true after execution? (Choose two.)
The correct answer is B. The primary key constraint will be enabled and DEFERRED. D. The foreign key constraint will be enabled and IMMEDIATE. See the full explanation below for the reasoning.
Question
Examine these SQL statements which execute successfully:
Which two statements are true after execution? (Choose two.)
Exhibit
Options
- AThe foreign key constraint will be disabled.
- BThe primary key constraint will be enabled and DEFERRED.
- CThe foreign key constraint will be enabled and DEFERRED.
- DThe foreign key constraint will be enabled and IMMEDIATE.
- EThe primary key constraint will be enabled and IMMEDIATE.
How the community answered
(48 responses)- A4% (2)
- B73% (35)
- C15% (7)
- E8% (4)
Community Discussion
No community discussion yet for this question.