Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
What would an IT auditor review in order to evaluate that a database has referential integrity?
Composite keys
Field definition
Foreign key structure
Master table definition
Referential integrity in a relational database refers to consistency between coupled tables. Referential integrity is usually enforced by the combination of a primary key or candidate key (alternate key) and a foreign key. For referential integrity to hold, any field in a table that is declared a foreign key should contain only values from a parent table's primary key or a candidate key. Field definition, master table definition and composite keys are elements of the database, but are not directly related to referential integrity.
Train with Skillset and pass your certification exam. Faster. Guaranteed.
Study thousands of practice questions that organized by skills and ranked by difficulty.
Create a tailored training plan based on the knowledge you already possess.
Know when you’re ready for the high-stakes exam. Have the confidence that you will pass on your first attempt.