[Solved] Referential integrity means

McqMate

Q.	Referential integrity means
A.	Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
B.	Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table
C.	Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
D.	All of above
Answer» A. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

1k

0

Do you find this helpful?

1

View all MCQs in

Microsoft Access (MS Access)

Discussion

No comments yet

Related MCQs

Referential integrity means
What is the use of Referential Integrity in MS Access?
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
Referential integrity cannot be set for _______________ relationships.
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command