Page 1 of 27
ISM 4212 Exam 2 FOR 2026-2027 COMPLETE
QUESTIONS AND VERIFIED SOLUTIONS LATEST
UPDATE THIS YEAR
QUESTION: The ________ states that no primary key attribute may be null.
A. referential integrity rule
B. range domain rule
C. entity integrity rule
D. partial specialization rule - ANSWER-entity integrity rule
QUESTION: A rule that states that each foreign key value must match a primary key value in the
other relation is called the:
A. entity key group rule
,Page 2 of 27
B. referential integrity constraint
C. foreign/primary key match rule
D. key match constraint - ANSWER-referential integrity constraint
QUESTION: A relation that contains no multi-valued attributes and has nonkey attributes solely
dependent on the primary key but contains transitive dependencies is in which normal form?
A. First
B. Second
C. Third
D. Fourth - ANSWER-Second
, Page 3 of 27
QUESTION: A candidate key must satisfy all of the following conditions **EXCEPT** :
A. the key must be non-redundant
B. the key must uniquely identify each row
C. each non-key attribute is functionally dependent on it
D. the key must indicate the row's location/position in the table - ANSWER-the key must
indicate the row's location/position in the table
QUESTION: An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A. duplicate key
B. primary key
C. record
ISM 4212 Exam 2 FOR 2026-2027 COMPLETE
QUESTIONS AND VERIFIED SOLUTIONS LATEST
UPDATE THIS YEAR
QUESTION: The ________ states that no primary key attribute may be null.
A. referential integrity rule
B. range domain rule
C. entity integrity rule
D. partial specialization rule - ANSWER-entity integrity rule
QUESTION: A rule that states that each foreign key value must match a primary key value in the
other relation is called the:
A. entity key group rule
,Page 2 of 27
B. referential integrity constraint
C. foreign/primary key match rule
D. key match constraint - ANSWER-referential integrity constraint
QUESTION: A relation that contains no multi-valued attributes and has nonkey attributes solely
dependent on the primary key but contains transitive dependencies is in which normal form?
A. First
B. Second
C. Third
D. Fourth - ANSWER-Second
, Page 3 of 27
QUESTION: A candidate key must satisfy all of the following conditions **EXCEPT** :
A. the key must be non-redundant
B. the key must uniquely identify each row
C. each non-key attribute is functionally dependent on it
D. the key must indicate the row's location/position in the table - ANSWER-the key must
indicate the row's location/position in the table
QUESTION: An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A. duplicate key
B. primary key
C. record
