Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
A
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
View Answer
C
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
View Answer
B
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
View Answer
C
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
View Answer
D
Q176: In the Building-Apartment scenario, which entity would have attributes like Covered Area and Status?
- A: Floor
- B: Customer
- C: Apartment
- D: Building
View Answer
C
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
View Answer
C
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
View Answer
A
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
View Answer
B
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
View Answer
B