Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q101: What does an entity type represent?
- A: A single item
- B: A group of items with similar properties
- C: A relationship between items
- D: A function of items
View Answer
B
Q102: What is the process of identifying entity types and their properties called?
- A: Normalization
- B: Transformation
- C: Abstraction
- D: Optimization
View Answer
C
Q103: What type of data models are commercial DBMS based on?
- A: Record-based
- B: Object-oriented
- C: Graph-based
- D: Semantic
View Answer
A
Q104: What is an entity instance?
- A: A specific property
- B: A data model construct
- C: A specific object belonging to an entity type
- D: A collection of entity types
View Answer
C
Q105: Which of the following is NOT a property of an EMPLOYEE entity type?
- A: Name
- B: Registration number
- C: Weight
- D: Qualification
View Answer
C
Q106: A group of entity instances of a particular entity type is called:
- A: Entity list
- B: Entity set
- C: Entity group
- D: Entity block
View Answer
B
Q107: How are weak entity types represented in E-R diagrams?
- A: Single rectangle
- B: Double rectangle
- C: Single circle
- D: Double circle
View Answer
B
Q108: Which term is used to refer to a set of objects that exist in an environment and share similar properties?
- A: Entity type
- B: Entity set
- C: Attribute
- D: Relationship
View Answer
A
Q109: What is the symbol used to represent a strong entity type in an E-R diagram?
- A: Single circle
- B: Double circle
- C: Single rectangle
- D: Double rectangle
View Answer
C
Q110: What is an attribute in the context of an entity type?
- A: A defining property of an entity type
- B: A type of entity
- C: A collection of entity instances
- D: A constraint on an entity type
View Answer
A