Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q351: What is the main purpose of denormalization in database design?
- A: To increase redundancy
- B: To simplify the schema
- C: To enhance performance
- D: To enforce data integrity
View Answer
C
Q352: Which situation indicates a potential candidate for denormalization?
- A: High frequency of queries involving multiple tables
- B: Low volume of data transactions
- C: Minimal calculation on columns
- D: Rarely accessed tables
View Answer
A
Q353: What is the effect of merging two entity types with a one-to-one relationship?
- A: Increased redundancy and storage wastage
- B: Improved performance by reducing join operations
- C: More complex queries
- D: Increased data normalization
View Answer
B
Q354: In which situation would you consider partitioning a database table?
- A: When data access is infrequent
- B: When the table is small and simple
- C: To reduce workload and improve performance
- D: To merge two tables with the same schema
View Answer
C
Q355: What type of partitioning divides a table based on rows?
- A: Vertical Partitioning
- B: Horizontal Partitioning
- C: Range Partitioning
- D: List Partitioning
View Answer
B
Q356: What is the advantage of horizontal partitioning using range partitioning?
- A: Reduces unbalanced partitions
- B: Splits a table based on columns
- C: Maintains fixed-length records
- D: Specifies list values for partitions
View Answer
A
Q357: Which partitioning method uses an algorithm to distribute data evenly across partitions?
- A: Range Partitioning
- B: List Partitioning
- C: Hash Partitioning
- D: Vertical Partitioning
View Answer
C
Q358: How does list partitioning differ from range partitioning?
- A: List partitioning uses specific values for partitions, while range partitioning uses a range of values
- B: List partitioning applies an algorithm, while range partitioning specifies ranges
- C: List partitioning splits based on columns, while range partitioning splits rows
- D: List partitioning ensures even distribution, while range partitioning does not
View Answer
A
Q359: What should be analyzed before performing partitioning of a table?
- A: The frequency of data access
- B: The table’s schema and relationships
- C: The number of columns
- D: The data size alone
View Answer
B
Q360: Denormalization is applied to improve _______ of a database.
- A: data integrity
- B: performance
- C: normalization
- D: redundancy
View Answer
B