Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
A database contains a record with an empty primary key. Which database concept has been violated?
Normalization
Semantics
Entity integrity
Referential integrity
The correct answer is entity integrity. Database software performs three main types of integrity services: semantic, referential, and entity. A semantic integrity mechanism makes sure structural and semantic rules are enforced. These rules pertain to data types, logical values, uniqueness constraints, and operations that could adversely affect the structure of the database. A database has referential integrity if all foreign keys reference existing primary keys. There should be a mechanism in place that ensures no foreign key contains a reference to a primary key of a non-existing record, or a null value. Entity integrity guarantees that the tuples are uniquely identified by primary key values. EDIT: Please provide a reference as this seems to be outside the scope for CISSP testing. EDIT:is this CEH related or CISSP, I’ve never read such concepts in CEH EDIT: I must have been confused, I thought I purchased a CISSP study course...
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.