Practice Quiz

CompTIA Security+ Exam Prep

Category - Engineering

Start a Study Session Sign up for Question of the Day
You know that databases, applications, and integrity services are necessary for systems to work. What integrity service deals with foreign keys and primary keys?
  1. Rollback Integrity
  2. Semantic Integrity
  3. Entity Integrity
  4. Referential Integrity
Explanation
Answer: D - Referential integrity deals with foreign keys and primary keys. A database has referential integrity if all foreign keys reference existing primary keys. There should be a mechanism in places that ensures no foreign key contains a reference to a primary key of a non-existing record or a null value. Referential integrity is joined with semantic integrity and entity integrity.
Previous Next
Was this helpful? Upvote!
Login to contribute your own answer or details
Start a Study Session Sign up for Question of the Day

Top questions

Related questions

Most popular on PracticeQuiz