ER Model and Business Rules Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q11
A subtype discriminator is which of the following?
  • 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
Answer: Option A
Q12
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?
  • A Disjoint with total specialization
  • B Disjoint with partial specialization
  • C Overlap with total specialization
  • D Overlap with partial specialization
Answer: Option C
Q13
A subtype entity name should be which of the following?
  • A A singular noun
  • B Specific to the organization
  • C Concise
  • D All of the above
Answer: Option D
Q14
Use of a supertype/subtype relationship is necessary when which of the following exists?
  • 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.
Answer: Option A
Q15
Which of the following is not one of the three ways to classify an action assertion?
  • A Condition
  • B Integrity Control
  • C Authorization
  • D Enabler
Answer: Option D

📚 More from Database

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