[Solved] What is the use of Referential Integrity in MS Access?

McqMate

Q.	What is the use of Referential Integrity in MS Access?
A.	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
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
C.	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
D.	None of above
Answer» A. 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

1.2k

0

Do you find this helpful?

10

View all MCQs in

Microsoft Access (MS Access)

Discussion

No comments yet

Related MCQs

Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
Referential integrity means
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.
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
Referential integrity means
Which control does access use to link data access page components to Access data?
In Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)
In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
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?