Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 10
Q161:
In EERD, every instance of the super type is also an instance of:
A. A different super type
B. None of the subtypes
C. Only one subtype
D. Multiple subtypes
Correct Answer:
C
Chapter: 11
Q162:
In an ERD, which model shows foreign keys and attributes?
A. Conceptual Data Model
B. Logical Data Model
C. Physical Data Model
D. Abstract Data Model
Correct Answer:
C
Chapter: 11
Q163:
What type of relationship requires a new third table with primary keys as foreign keys?
A. One-to-Many
B. Many-to-Many
C. One-to-One
D. Many-to-One
Correct Answer:
B
Chapter: 11
Q164:
In the Physical Data Model, which table would likely have a composite primary key?
A. Floor
B. Building
C. Customer
D. Apartment
Correct Answer:
A
Chapter: 11
Q165:
For a One-to-One relationship, where will the foreign key be placed?
A. In the parent table
B. In the child table
C. In a third table
D. In both tables
Correct Answer:
B
Chapter: 11
Q166:
In the Building-Apartment scenario, which entity has attributes including Building Name and Address?
A. Floor
B. Customer
C. Building
D. Apartment
Correct Answer:
C
Chapter: 11
Q167:
Fill in the blank: In the Physical Data Model, the foreign key for the Floor table is combined with ________ to form a composite primary key.
A. Building Name
B. Floor Number
C. Apartment ID
D. Customer ID
Correct Answer:
B
Chapter: 11
Q168:
In the Musical Bands scenario, what is the maximum number of songs that can be included in an Album?
A. 5
B. 8
C. 10
D. 12
Correct Answer:
D
Chapter: 11
Q169:
What is the primary key in the Writer_song table?
A. sname
B. wid
C. sname and wid
D. aname
Correct Answer:
C
Chapter: 11
Q170:
In the Airport Management System, which entity would you expect to have attributes like Flight ID and Date of Departure?
A. Ticket
B. Passenger
C. Flight
D. Plane
Correct Answer:
C
Chapter: 11
Q171:
Fill in the blank: In the Physical Data Model, the Manager table has a foreign key which is also a ________.
A. Unique Key
B. Composite Key
C. Primary Key
D. Secondary Key
Correct Answer:
A
Chapter: 11
Q172:
What attribute is common between the Flight and Ticket entities in the Physical Data Model?
A. Seat Number
B. Meal
C. Flight ID
D. Passenger ID
Correct Answer:
C
Chapter: 11
Q173:
In the Building-Apartment scenario, which entity is associated with the Receipt entity through Apartment Number?
A. Customer
B. Apartment
C. Floor
D. Building
Correct Answer:
B
Chapter: 11
Q174:
What is the relationship between the Plane and Flight entities in the Physical Data Model?
A. One-to-Many
B. Many-to-One
C. Many-to-Many
D. One-to-One
Correct Answer:
C
Chapter: 11
Q175:
Fill in the blank: In the Physical Data Model for the Airport Management System, the Plane_flight table resolves a ________ relationship.
A. One-to-One
B. One-to-Many
C. Many-to-One
D. Many-to-Many
Correct Answer:
D
Chapter: 11
Q176:
In the Building-Apartment scenario, which entity would have attributes like Covered Area and Status?
A. Floor
B. Customer
C. Apartment
D. Building
Correct Answer:
C
Chapter: 12
Q177:
What is an anomaly in database design?
A. A pattern in data
B. A type of index
C. An irregularity or deviation from the normal state
D. A database schema
Correct Answer:
C
Chapter: 12
Q178:
Which anomaly occurs when certain data cannot be entered without entering unwanted data?
A. Insert Anomaly
B. Delete Anomaly
C. Update Anomaly
D. Redundancy Anomaly
Correct Answer:
A
Chapter: 12
Q179:
Fill in the blank: Insert anomaly arises due to poor design decision of storing data in ________.
A. multiple tables
B. a single table
C. a view
D. a stored procedure
Correct Answer:
B
Chapter: 12
Q180:
What is a primary issue caused by delete anomaly?
A. Redundant data
B. Data loss due to deletion of other data
C. Data inconsistency
D. Data duplication
Correct Answer:
B