Home - Database - Er Model And Business Rules

Er Model And Business Rules Online Exam Quiz

Important questions about Er Model And Business Rules. Er Model And Business Rules MCQ questions with answers. Er Model And Business Rules exam questions and answers for students and interviews.

1. Inheritance is which of the following?

Options

A : When a supertype entity inherits values of the subtype attribute

B : When a subtype entity inherits values of the supertype attribute

C : When a supertype entity inherits values of another supertype attribute

D : When a subtype entity inherits values of another subtype attribute

2. When an entity instance must be a member of only one subtype, it is which of the following?

Options

A : Disjoint with total specialization

B : Disjoint with partial specialization

C : Overlap with total specialization

D : Overlap with partial specialization

3. A rectangle represents which of the following in an EER?

Options

A : Attribute

B : Entity

C : Optional One

D : Relationship

4. Specialization is which of the following processes?

Options

A : Defining one or more subtypes of the supertype and forming supertype/subtype relationships.

B : Defining one or more supertypes of the subtype and forming supertype/subtype relationships.

C : Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.

D : Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.

5. Which of the following statements concerning business rules is true?

Options

A : It should be complex.

B : It should not be convertible to computer code.

C : It may include restrictions.

D : All of the above.

6. Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

Options

A : True

B : False

C :

D :

7. There is cardinality on an EER between the supertype and subtype.

Options

A : True

B : False

C :

D :

8. A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

Options

A : True

B : False

C :

D :

9. Total specialization is represented by double lines between the supertype and subtype on an EER.

Options

A : True

B : False

C :

D :

10. If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

Options

A : True

B : False

C :

D :

1. A subtype entity name should be which of the following?

Options

A : A singular noun

B : Specific to the organization

C : Concise

D : All of the above

2. A supertype/subtype hierarchy has which of the following features?

Options

A : Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.

B : Attributes are assigned at the highest logical level.

C : Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.

D : Attributes are assigned at the lowest logical level.

3. Which of the following is not one of the three ways to classify an action assertion?

Options

A : Condition

B : Integrity Control

C : Authorization

D : Enabler

4. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

Options

A : Disjoint with total specialization

B : Disjoint with partial specialization

C : Overlap with total specialization

D : Overlap with partial specialization

5. An action assertion must include which of the following?

Options

A : Anchor object

B : Action

C : Corresponding object

D : All of the above.

6. An oval represents which of the following in an EER?

Options

A : Attribute

B : Entity

C : Optional One

D : Relationship

7. Which one of the following symbols is not used in an ERD?

Options

A : Rectangle

B : Oval

C : Diamond

D : Circle

8. A supertype/subtype hierarchy is which of the following?

Options

A : Each subtype has only one attribute.

B : Each supertype has only one attribute.

C : Each subtype has only one supertype.

D : Each supertype has only one subtype.

9. A subtype discriminator is which of the following?

Options

A : An attribute of the supertype whose values determine the subtype

B : An attribute of the subtype whose values determine the supertype

C : An attribute of the supertype whose values determine the supertype

D : An attribute of the subtype whose values determine the subtype

10. Use of a supertype/subtype relationship is necessary when which of the following exists?

Options

A : An instance of a subtype participates in a relationship that is unique to that subtype.

B : An instance of a subtype participates in a relationship that is the same as the other subtypes.

C : Attributes apply to all of the instances of an entity type.

D : No attributes apply to any of the instances of an entity type.

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.020085096359253