Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q111: How are attribute names typically formatted in this course?
- A: All uppercase letters
- B: Abbreviated entity type followed by purpose with capitalized first letter
- C: Full words without abbreviations
- D: No specific format
View Answer
B
Q112: Which of the following is NOT a type of attribute mentioned?
- A: Simple
- B: Composite
- C: Multi-valued
- D: Complex
View Answer
D
Q113: What does the domain of an attribute specify?
- A: The set of possible values for the attribute
- B: The type of data the attribute can hold
- C: The constraints on the attribute's value
- D: The operations that can be performed on the attribute
View Answer
A
Q114: An attribute value like ‘Reema’ is considered legal for which attribute type?
- A: Salary
- B: Date of Birth
- C: Employee Name
- D: Address
View Answer
C
Q115: Which symbol represents an attribute in an E-R diagram?
- A: A rectangle
- B: A diamond
- C: An oval
- D: A triangle
View Answer
C
Q116: A composite attribute is defined as one that:
- A: Contains a single value
- B: Comprises other attributes
- C: Has multiple values
- D: Is always derived
View Answer
B
Q117: The domain of an attribute helps maintain database integrity by:
- A: Allowing any value to be assigned
- B: Restricting values to a specific set or range
- C: Providing additional attribute names
- D: Defining the operations on attribute values
View Answer
B
Q118: A derived attribute:
- A: Is always stored in the database
- B: Can be computed from other attributes
- C: Is always multi-valued
- D: Is only used for display purposes
View Answer
B
Q119: The example of a composite attribute given in the content is:
- A: Employee Name
- B: Address
- C: Hobby
- D: Age
View Answer
B
Q120: In the E-R diagram, a multi-valued attribute is represented by:
- A: A double oval
- B: A single oval
- C: A diamond
- D: A rectangle
View Answer
A