Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q321: Fill in the blank: The goal of normalization is to create a set of relational tables that are free of _______ and can be consistently and correctly modified.
- A: Redundant data
- B: Primary keys
- C: Composite keys
- D: Foreign keys
View Answer
A
Q322: What is the primary goal of normalization in database design?
- A: Increase redundancy
- B: Improve efficiency and consistency
- C: Add more attributes
- D: Simplify physical design
View Answer
B
Q323: Which normal form is typically sufficient for most situations according to the lecture?
- A: 1NF
- B: 2NF
- C: 3NF
- D: 6NF
View Answer
C
Q324: What is the process used to transform logical database design into technical specifications?
- A: Physical DB design
- B: Logical DB design
- C: Data normalization
- D: Data redundancy
View Answer
A
Q325: In normalization, what does a partial dependency violate?
- A: First Normal Form (1NF)
- B: Second Normal Form (2NF)
- C: Third Normal Form (3NF)
- D: Fourth Normal Form (4NF)
View Answer
B
Q326: What is the primary focus of physical database design compared to logical database design?
- A: Storage efficiency
- B: Database consistency
- C: Execution efficiency
- D: Normalization accuracy
View Answer
C
Q327: In the given example, which attribute is used as the primary key for the WORK table?
- A: empId, projName
- B: empId
- C: projName
- D: empDept
View Answer
A
Q328: Which table was not found to have a transitive dependency in the normalization example?
- A: PROJECT
- B: WORK
- C: EMPLOYEE
- D: DEPT
View Answer
B
Q329: What should be considered when making decisions about physical database design?
- A: Only data types
- B: Tool-specific decisions
- C: Data usage and requirements
- D: Normalized relations only
View Answer
C
Q330: Normalization helps to maintain the __________ of the database.
- A: efficiency
- B: redundancy
- C: consistency
- D: complexity
View Answer
C