ISM 4212 Exam 2 ALL QUESTIONS AND CORRECT ANSWERS LATEST UPDATE THIS YEAR

Page 1 of 27



ISM 4212 Exam 2 ALL QUESTIONS AND
CORRECT ANSWERS LATEST UPDATE THIS
YEAR
QUESTION: An attribute in a relation of a database that serves as the primary key of another

relation in the same database is called a:




A. foreign key




B. foreign attribute




C. link key




D. link attribute - ANSWER-foreign key




QUESTION: A functional dependency in which one or more non-key attributes are functionally

dependent on part, but not all, of the primary key is called a ________ dependency.




A. partial functional



1

, Page 2 of 27




B. transitive key dependency




C. cross key




D. merged relation - ANSWER-partial functional




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




2

, Page 3 of 27


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




B. referential integrity constraint




C. foreign/primary key match rule




D. key match constraint - ANSWER-referential integrity constraint




Q; A constraint between two attributes is called a(n):




A. functional relation constraint




B. functional dependency




C. attribute dependency


3