Oracle
1Z0-074 · Question #58
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
The correct answer is E. A table can have only one primary key but multiple foreign keys F. Primary key and foreign key constraints can be defined at both the column and table level G. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the. See the full explanation below for the reasoning.
Question
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
Options
- AIt is possible for child rows that have a foreign key to remain in the child table at the time the parent row
- BOnly the primary key can be defined at the column and table level
- DA table can have only one primary key and one foreign key
- EA table can have only one primary key but multiple foreign keys
- FPrimary key and foreign key constraints can be defined at both the column and table level
- GIt is possible for child rows that have a foreign key to be deleted automatically from the child table at the
How the community answered
(34 responses)- A12% (4)
- B3% (1)
- D6% (2)
- E79% (27)
Community Discussion
No community discussion yet for this question.