Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q151: According to the Exhaustive property, a valid subtype must have:
- A: No attributes
- B: One or more specific attributes
- C: All attributes shared with super type
- D: Mutually exclusive attributes
View Answer
B
Q152: The rule stating that subtypes do not share relationships or attributes with each other is called:
- A: Isolation
- B: Mutually Exclusive
- C: Exhaustive
- D: Super-Sub Dependency
View Answer
B
Q153: If sno=1 is associated with Full-time employee, can it also be associated with Part-time employee?
- A: Yes
- B: No
- C: Sometimes
- D: Only if mutually exclusive is off
View Answer
B
Q154: In a HR system, which type of employee is eligible for loan facilities?
- A: Part-time
- B: Full-time
- C: Contract-based
- D: All employees
View Answer
B
Q155: Fill in the blank: Super types cannot access the _____ of subtypes.
- A: attributes
- B: relationships
- C: properties
- D: attributes and relationships
View Answer
D
Q156: According to EERD, what happens when Salary attribute is removed from the Full-time subtype?
- A: It becomes invalid
- B: It remains valid
- C: It shares with the Part-time subtype
- D: It gets inherited from the super type
View Answer
A
Q157: The EERD model extends which diagram?
- A: Unified Modeling Diagram
- B: Class Diagram
- C: Entity Relationship Diagram
- D: Database Flow Diagram
View Answer
C
Q158: Fill in the blank: A subtype that has no specific attributes is considered ________.
- A: redundant
- B: invalid
- C: valid
- D: dynamic
View Answer
B
Q159: What is another name for a Super Type?
- A: Subclass
- B: Entity Relationship
- C: Super Class
- D: Super Database
View Answer
C
Q160: Which of the following statements is TRUE regarding EERD?
- A: Super types can access all subtypes' relationships.
- B: Subtypes inherit attributes from super types.
- C: Subtypes know about each other’s relationships.
- D: Super types depend on subtypes for attributes.
View Answer
B