Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 7
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
Correct Answer:
B
Chapter: 7
Q102:
What is the process of identifying entity types and their properties called?
A. Normalization
B. Transformation
C. Abstraction
D. Optimization
Correct Answer:
C
Chapter: 7
Q103:
What type of data models are commercial DBMS based on?
A. Record-based
B. Object-oriented
C. Graph-based
D. Semantic
Correct Answer:
A
Chapter: 7
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
Correct Answer:
C
Chapter: 7
Q105:
Which of the following is NOT a property of an EMPLOYEE entity type?
A. Name
B. Registration number
C. Weight
D. Qualification
Correct Answer:
C
Chapter: 7
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
Correct Answer:
B
Chapter: 7
Q107:
How are weak entity types represented in E-R diagrams?
A. Single rectangle
B. Double rectangle
C. Single circle
D. Double circle
Correct Answer:
B
Chapter: 7
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
Correct Answer:
A
Chapter: 7
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
Correct Answer:
C
Chapter: 7
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
Correct Answer:
A
Chapter: 7
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
Correct Answer:
B
Chapter: 7
Q112:
Which of the following is NOT a type of attribute mentioned?
A. Simple
B. Composite
C. Multi-valued
D. Complex
Correct Answer:
D
Chapter: 7
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
Correct Answer:
A
Chapter: 7
Q114:
An attribute value like ‘Reema’ is considered legal for which attribute type?
A. Salary
B. Date of Birth
C. Employee Name
D. Address
Correct Answer:
C
Chapter: 7
Q115:
Which symbol represents an attribute in an E-R diagram?
A. A rectangle
B. A diamond
C. An oval
D. A triangle
Correct Answer:
C
Chapter: 7
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
Correct Answer:
B
Chapter: 7
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
Correct Answer:
B
Chapter: 7
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
Correct Answer:
B
Chapter: 7
Q119:
The example of a composite attribute given in the content is:
A. Employee Name
B. Address
C. Hobby
D. Age
Correct Answer:
B
Chapter: 7
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
Correct Answer:
A