Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q161: What is an example of a ternary relationship?
- A: Student-Course
- B: Employee-Project
- C: Student-Class-Faculty
- D: Department-Employee
View Answer
C
Q162: What does the "crow's foot notation" indicate in ER diagrams?
- A: One-to-many cardinality
- B: Many-to-one cardinality
- C: Many-to-many cardinality
- D: One-to-one cardinality
View Answer
A
Q163: ________ relationship involves an entity linked with itself.
- A: unary
- B: binary
- C: ternary
- D: n-ary
View Answer
A
Q164: The "_____ notation" uses single and double arrows to show cardinality.
- A: arrow-head
- B: crow's foot
- C: alphabetical
- D: dot-based
View Answer
A
Q165: In a "one-to-many" relationship, the "many" indicates that ________.
- A: each entity is associated with many entities
- B: each entity is associated with only one entity
- C: all entities are related equally
- D: some entities are optional
View Answer
A
Q166: The "_______ dependency" means an entity's existence relies on another entity.
- A: existence
- B: referential
- C: identifier
- D: foreign key
View Answer
A
Q167: In ER diagrams, "1" represents a ________ cardinality.
- A: one
- B: many
- C: optional
- D: maximum
View Answer
A
Q168: What is inheritance in object-oriented programming?
- A: The transfer of characteristics from one class to another
- B: Writing code in different programming languages
- C: Storing data in a database
- D: Executing code in a specific order
View Answer
A
Q169: In the context of database systems, what does inheritance mean?
- A: The transfer of properties from one entity to derived entities
- B: Storing multiple types of data in a database
- C: Managing access control in a database
- D: Performing operations on database tables
View Answer
B
Q170: What is a supertype in a database system?
- A: A major entity that is divided into subtypes
- B: A specific subtype with additional properties
- C: A minor entity that inherits properties from another entity
- D: A type of data that does not have any attributes
View Answer
A