Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q301: Which inference rule allows us to deduce new functional dependencies from existing ones?
- A: Reflexivity
- B: Augmentation
- C: Transitivity
- D: Additivity
View Answer
C
Q302: What does the Augmentation rule state?
- A: If A → B, then AC → BC
- B: If A → B, then B → A
- C: If A → B and B → C, then A → C
- D: If A → B, then A → A
View Answer
A
Q303: If A → B and B → C, what does Transitivity allow us to infer?
- A: A → C
- B: A → B
- C: B → C
- D: A → B, C
View Answer
A
Q304: Which rule states that if A → B and A → C, then A → BC?
- A: Additivity
- B: Projectivity
- C: Pseudo Transitivity
- D: Transitivity
View Answer
A
Q305: What is the requirement for a relation to be in First Normal Form (1NF)?
- A: All attributes must be single-valued
- B: No repeating groups or multivalued attributes
- C: Every attribute must have a unique name
- D: All attributes must be numeric
View Answer
B
Q306: Which normal form requires all nonkey attributes to be fully functionally dependent on the key?
- A: First Normal Form
- B: Second Normal Form
- C: Third Normal Form
- D: Boyce-Codd Normal Form
View Answer
B
Q307: In the provided example, which attribute is a key for the student relation?
- A: stId
- B: stName
- C: prName
- D: credits
View Answer
A
Q308: If stId → stName, stAdr, prName, credits, then what can be inferred about stId?
- A: It is a super key
- B: It is a foreign key
- C: It is a non-key attribute
- D: It is a candidate key
View Answer
A
Q309: What does the term "Projectivity" refer to in inference rules?
- A: Breaking down a functional dependency into simpler dependencies
- B: Combining multiple dependencies into one
- C: Adding more attributes to a dependency
- D: Removing attributes from a dependency
View Answer
A
Q310: In the given relation, what is required to convert it to First Normal Form (1NF)?
- A: Remove repeating groups
- B: Remove all NULL values
- C: Ensure all values are unique
- D: Ensure all attributes are numeric
View Answer
A