ISM 4212 Exam 2 FOR COMPLETE QUESTIONS AND VERIFIED SOLUTIONS LATEST UPDATE THIS YEAR

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