MODERN DATABASE MANAGEMENT
EXAMINATION TEST PAPER 2026
COMPREHENSIVE REVIEW SOLVED
QUESTIONS ANSWERS GRADED A+
◉ The relational data model consists of which components?
Answer: Data structure, Data manipulation, and Data integrity
◉ A two-dimensional table of data is called a:
Answer: Relation
◉ A component of the relational data model included to specify
business rules to maintain the integrity of data when they are
manipulated:
Answer: Data integrity
◉ An attribute (or attributes) that uniquely identifies each row in a
relation is called a:
Answer: Primary key
◉ An attribute in a relation of a database that serves as the primary
key of another relation in the same database is called a:
,Answer: Foreign key
◉ A domain definition consists of the following components
EXCEPT:
domain name
data type
integrity constraints
size
Answer: Integrity constraints
◉ A rule that states that each foreign key value must match a
primary key value in the other relation is called the:
A. referential integrity constraint.
B. key match rule.
C. entity key group rule.
D. foreign/primary match rule
Answer: Referential integrity constraint
◉ In the SQL language, the __________ statement is used to make table
definitions.
,Answer: Create table
◉ A relation that contains minimal redundancy and allows easy use
is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
◉ A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
◉ All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
, B. simplify the enforcement of referential integrity.
C. maximize storage space.
D. make it easier to maintain data.
Answer: Maximize storage space
◉ When all multivalued attributes have been removed from a
relation, it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
◉ A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains
transitive dependencies is in which normal form?
Answer: Second
◉ A constraint between two attributes is called a(n):
A) functional relation.
EXAMINATION TEST PAPER 2026
COMPREHENSIVE REVIEW SOLVED
QUESTIONS ANSWERS GRADED A+
◉ The relational data model consists of which components?
Answer: Data structure, Data manipulation, and Data integrity
◉ A two-dimensional table of data is called a:
Answer: Relation
◉ A component of the relational data model included to specify
business rules to maintain the integrity of data when they are
manipulated:
Answer: Data integrity
◉ An attribute (or attributes) that uniquely identifies each row in a
relation is called a:
Answer: Primary key
◉ An attribute in a relation of a database that serves as the primary
key of another relation in the same database is called a:
,Answer: Foreign key
◉ A domain definition consists of the following components
EXCEPT:
domain name
data type
integrity constraints
size
Answer: Integrity constraints
◉ A rule that states that each foreign key value must match a
primary key value in the other relation is called the:
A. referential integrity constraint.
B. key match rule.
C. entity key group rule.
D. foreign/primary match rule
Answer: Referential integrity constraint
◉ In the SQL language, the __________ statement is used to make table
definitions.
,Answer: Create table
◉ A relation that contains minimal redundancy and allows easy use
is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
◉ A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
◉ All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
, B. simplify the enforcement of referential integrity.
C. maximize storage space.
D. make it easier to maintain data.
Answer: Maximize storage space
◉ When all multivalued attributes have been removed from a
relation, it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
◉ A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains
transitive dependencies is in which normal form?
Answer: Second
◉ A constraint between two attributes is called a(n):
A) functional relation.
