ER Model and Business Rules Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
An action assertion must include which of the following?
  • A Anchor object
  • B Action
  • C Corresponding object
  • D All of the above.
Answer: Option D
Q2
An oval represents which of the following in an EER?
  • A Attribute
  • B Entity
  • C Optional One
  • D Relationship
Answer: Option A
Q3
Inheritance is which of the following?
  • 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
Answer: Option B
Q4
 When an entity instance must be a member of only one subtype, it is which of the following?
  • A Disjoint with total specialization
  • B Disjoint with partial specialization
  • C Overlap with total specialization
  • D Overlap with partial specialization
Answer: Option A
Q5
A supertype/subtype hierarchy is which of the following?
  • 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.
Answer: Option C
Q6
A rectangle represents which of the following in an EER?
  • A A rectangle represents which of the following in an EER?
  • B A rectangle represents which of the following in an EER?
  • C Entity
  • D Optional One
Answer: Option B
Q7
Which one of the following symbols is not used in an ERD?
  • A Rectangle
  • B Oval
  • C Diamond
  • D Circle
Answer: Option D
Q8
Specialization is which of the following processes?
  • 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.
Answer: Option A
Q9
 Which of the following statements concerning business rules is true?
  • A It should be complex.
  • B It should not be convertible to computer code.
  • C It may include restrictions.
  • D All of the above.
Answer: Option C
Q10
A supertype/subtype hierarchy has which of the following features?
  • A Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
  • B Attributes are assigned at the highest logical leve
  • 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.
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test