MOS Access Expert Practice Questions - Microsoft Office Specialist Access Expert (Office 2019) (Exam MO-500) Exam

Access More Questions

In a relational database such as Microsoft Access, what is the purpose of enforcing referential integrity on a relationship between two tables?

It prevents creating records in a related table that reference a primary key value that does not exist in the primary table It automatically compacts the database file each time it is closed It encrypts the data stored in the foreign key field It forces every field in both tables to be set as required

Correct Answer:

It prevents creating records in a related table that reference a primary key value that does not exist in the primary table

Access more questions from this quiz

Continue to MOS Access Expert Practice Questions - Microsoft Office Specialist Access Expert (Office 2019) (Exam MO-500) Exam for more practice questions and the full quiz experience.

Access More Questions