When a foreign key constraint is enforced in a relational database, which…
PYQ IBPS SO CRP SPL-XIV (2024)
When a foreign key constraint is enforced in a relational database, which condition must normally be satisfied while inserting a non-NULL value into the foreign key column?
- A.
The value can be inserted without checking the referenced table.
- B.
The value must match an existing value in the referenced primary key or unique key column.
- C.
A new primary key value is automatically generated in the parent table.
- D.
The foreign key checks only uniqueness of the inserted value.
- E.
The foreign key column must always contain NULL values.
Attempted by 78 students.
Sign up free to check your answer
Sign up freeLoading lesson…

