Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q201: What is the main purpose of denormalization?
- A: To add redundancy for improved performance
- B: To reduce redundancy
- C: To simplify the database schema
- D: To enforce data integrity
View Answer
A
Q202: Denormalization is typically used when:
- A: The database structure is more important than performance
- B: Performance is less critical than data integrity
- C: The database is small and simple
- D: The database performance is a concern and needs improvement
View Answer
B
Q203: Which of the following describes the need for denormalization?
- A: Reducing the number of tables to simplify design
- B: Reducing running time of queries that involve multiple joins
- C: Increasing data redundancy to ensure data integrity
- D: Normalizing the database to remove anomalies
View Answer
B
Q204: Normalization focuses on:
- A: Increasing the number of joins to improve performance
- B: Reducing data redundancy and inconsistency
- C: Improving query execution speed
- D: Storing data in fewer tables
View Answer
B
Q205: When is it appropriate to denormalize a database?
- A: When data integrity is a higher priority than performance
- B: When running time of queries is a critical factor
- C: When the database schema needs to be simplified
- D: When ensuring logical relationships is important
View Answer
B
Q206: A common denormalization technique involves storing:
- A: Only primary keys
- B: Only foreign keys
- C: Calculated values to improve query performance
- D: Redundant data to reduce joins
View Answer
C
Q207: In denormalization, which scenario might involve storing an end date?
- A: When records are updated frequently
- B: When historical data needs to be queried efficiently
- C: When multiple child tables need to be merged
- D: When grandparent-grandchild relationships are queried frequently
View Answer
B
Q208: Which of the following is an example of storing details in the master table?
- A: Keeping order details in a separate table from orders
- B: Merging order details into the order table to reduce joins
- C: Storing customer feedback separately from order data
- D: Using a separate table for product reviews
View Answer
B
Q209: What is a short circuit key used for in denormalization?
- A: To link parent and child tables
- B: To ensure relationships between different levels of master tables
- C: To store frequently updated records
- D: To manage large amounts of data in a single table
View Answer
B
Q210: A current indicator column in a denormalized table is used to:
- A: Store historical data
- B: Indicate whether a record is the most current
- C: Keep track of changes in data structure
- D: Calculate frequently used values
View Answer
B