| Snaprecruit.com

| Snaprecruit.com

Interview question based on skill :

Take as many assements as you can to improve your validate your skill rating

Total Questions: 8

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