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.
An oval represents which of the following in an EER?
Options
A : Attribute
B : Entity
C : Optional One
D : Relationship
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
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
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.
A rectangle represents which of the following in an EER?
Options
A : Attribute
B : Entity
C : Optional One
D : Relationship
Which one of the following symbols is not used in an ERD?
Options
A : Rectangle
B : Oval
C : Diamond
D : Circle
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.
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.
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.
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