Oracle
1Z0-082 · Question #3
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 A. A table can have only one primary key but multiple foreign keys C. The foreign key columns and parent table primary key columns must have the same names E. It is possible for child rows that have a foreign key to be deleted automatically from the child table G. Primary key and foreign key constraints can be defined at both the column and table level. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
Options
- AA table can have only one primary key but multiple foreign keys
- BA table can have only one primary key and one foreign key
- CThe foreign key columns and parent table primary key columns must have the same names
- DIt is possible for child rows that have a foreign key to remain in the child table at the time the
- EIt is possible for child rows that have a foreign key to be deleted automatically from the child table
- FOnly the primary key can be defined at the column and table level
- GPrimary key and foreign key constraints can be defined at both the column and table level
How the community answered
(43 responses)- A72% (31)
- B7% (3)
- D16% (7)
- F5% (2)
Topics
#primary key#foreign key#referential integrity#constraint levels
Community Discussion
No community discussion yet for this question.