Interview Questions

When can an insert of a new primary key value threaten referntial integrity?

COBOL SQL Interview Questions


(Continued from previous question...)

When can an insert of a new primary key value threaten referntial integrity?

Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables. And updates of primary key values may require changes in foreign key values to maintain referential integrity.

(Continued on next question...)

Other Interview Questions