DBA > Job Interview Questions > COBOL SQL Interview Questions

What is referential integrity?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is referential integrity?

Referential integrity is the automatic enforcement of referential constrains that exist between a reference table and a referencing table. When referential integrity is enforced, the value of a foreign key exists as a primary key value in the reference table. In other words, when referential integrity is enforced, all of the foreign key values in, for example, the "department code" column in an "employee" table exist as primary key values in a "department" talbe.

(Continued on next question...)

Other Job Interview Questions