Database Final Exam ACTUAL EXAM ALL QUESTIONS AND CORRECT ANSWERS LATEST UPDATE THIS YEAR

Page 1 of 60



Database Final Exam ACTUAL EXAM ALL

QUESTIONS AND CORRECT ANSWERS LATEST

UPDATE THIS YEAR


QUESTION: Which of the following is an example of analytical information?
Question options:




Information about the amount of money in a checking account




Information showing which airline routes in the United States have the most sales




Information about the cost of a product




Information showing the destination and origin of a particular airline route in the United States
- ANSWER-Information showing which airline routs in the United States have the most sales


QUESTION: A regular entity must have at least one of the following attributes:
Question options:




1

, Page 2 of 60



Unique attribute




Composite attribute




Multivalued attribute




Derived attribute - ANSWER-Unique attribute


QUESTION: The following attribute represents a collection of attributes:
Question options:




Unique attribute




Composite attribute




Multivalued attribute




Derived attribute - ANSWER-Composite attribute




2

, Page 3 of 60


QUESTION: The following attribute can contain more than one value for each entity instance:
Question options:




Unique attribute




Composite attribute




Multivalued attribute




Derived attribute - ANSWER-Multivalued attribute


QUESTION: Which of the following is a possible type of relationship (maximum cardinality-
wise)?
Question options:




One-to-one




Zero-to-zero




Zero-to-one




3

, Page 4 of 60




Zero-to-many - ANSWER-One-to-one


QUESTION: Relationship attributes may be necessary in a relationship of what type?
Question options:




One-to-one




One-to-many




Zero-to-many




Many-to-many - ANSWER-One-to-many


Q; Joe is an example of ____________.
Question options:




Data




Metadata



4