[amp_mcq option1=”It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table” option2=”It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table” option3=”It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table” option4=”None of above” correct=”option2″]<\/p>\n
The correct answer is: B. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table.<\/strong><\/p>\n Referential integrity is a set of rules that ensures that data in one table is consistent with data in another table. In MS Access, referential integrity is enforced by the primary key and foreign key constraints.<\/p>\n The primary key is a column or set of columns that uniquely identifies each row in a table. The foreign key is a column or set of columns in a table that refers to the primary key of another table.<\/p>\n When you create a foreign key constraint, you are essentially saying that the values in the foreign key column must exist in the primary key column of the parent table. This ensures that the data in the two tables is consistent.<\/p>\n For example, let’s say you have a table called Customers<\/code> and a table called Orders<\/code>. The Customers<\/code> table has a primary key called CustomerID<\/code>. The Orders<\/code> table has a foreign key called CustomerID<\/code> that refers to the CustomerID<\/code> column in the Customers<\/code> table.<\/p>\n