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?

  1. A.

    The value can be inserted without checking the referenced table.

  2. B.

    The value must match an existing value in the referenced primary key or unique key column.

  3. C.

    A new primary key value is automatically generated in the parent table.

  4. D.

    The foreign key checks only uniqueness of the inserted value.

  5. E.

    The foreign key column must always contain NULL values.

Attempted by 78 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Mains

Loading lesson…