ER Model and Business Rules - General Questions Online Exam Quiz

ER Model and Business Rules - General Questions GK Quiz. Question and Answers related to ER Model and Business Rules - General Questions. MCQ (Multiple Choice Questions with answers about ER Model and Business Rules - General Questions

An action assertion must include which of the following?

Options

A : Anchor object

B : Action

C : Corresponding object

D : All of the above.

View Answer

An oval represents which of the following in an EER?

Options

A : Attribute

B : Entity

C : Optional One

D : Relationship

View Answer

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

View Answer

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

View Answer

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.

View Answer

A rectangle represents which of the following in an EER?

Options

A : Attribute

B : Entity

C : Optional One

D : Relationship

View Answer

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

Options

A : Rectangle

B : Oval

C : Diamond

D : Circle

View Answer

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.

View Answer

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.

View Answer

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.

View Answer

Advanced SQL - General Questions more Online Exam Quiz

Physical Database Design - General Questions

SQL for Database Construction - General Questions

The Client-Server Database - General Questions

The Database Development Process - General Questions

The Database Environment - General Questions

The Internet Database Environment - General Questions

The Relational Model and Normalization - General Questions

Data Models into Database Designs - General Questions

XML and ADO.NET - General Questions

Boolean Algebra and Logic Simplification - General Questions