1. Which of the following is the process of selecting the data storage and data access characteristics of the database?
Correct Answer is : Physical database design
2. The relationship between DEPARTMENT and EMPLOYEE is a
Correct Answer is : One-to-many relationship
3. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
Correct Answer is : Inconsistent state
4. When an entity instance must be a member of only one sub-type, it is which of the following?
Correct Answer is : Disjoint with total specialization
5. A supertype/subtype hierarchy is which of the following?
Correct Answer is : Each subtype has only one supertype
6. Which of the following statements concerning business rules is true?
Correct Answer is : It may include restrictions
7. Use of a supertype/subtype relationship is necessary when which of the following exists?
Correct Answer is : An instance of a subtype participates in a relationship that is unique to that subtype
8. Which of the following is not one of the three ways to classify an action assertion?
Correct Answer is : Enabler