FOUNDATIONS COMPREHENSIVE EXAM
2026 FULL QUESTIONS AND CORRECT
ANSWERS ALREADY PASSED
●● Attribute.
Answer: An attribute is a property or characteristic of an entity.
●● Binary relationship.
Answer: A binary relationship is a relationship between two entity types.
●● Candidate Key.
Answer: Is any column or a combination of columns that can qualify as
unique key in database.
●● Cardinality.
Answer: Cardinality represents the maximum number of entities that can
be involved in a particular relationship.
●● Cartesian product.
Answer: Usually the result of a missing join condition or a method of
expanding the data of 1 table by the number of rows in the second table.
, ●● Cascade Delete.
Answer: Will delete all records that reference the primary key
●● column subquery.
Answer: Returns a single column of one or more values.
●● data encryption.
Answer: When data is encrypted, it is changed, bit by bit or character by
character, into a form that looks totally garbled. It can and must be
reconverted, or decrypted, back to its original form to be of use.
●● Data normalization.
Answer: Is a methodology for organizing attributes into tables so that
redundancy among the non-key attributes is eliminated.
●● Data volatility.
Answer: Describes how often stored data is updated.
●● Data Volume Assessment.
Answer: Understanding of how much data will be in a database or a
table within a database