Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q291: In the right outer join, tuples from the right relation with no match in the left relation will have:
- A: Null values in the left relation attributes
- B: Matching values in the left relation attributes
- C: Empty rows in the output
- D: Non-matching attributes from the right relation
View Answer
A
Q292: Fill in the blank: In a theta join, the cross product is performed on __________ rows of one relation.
- A: all selected
- B: all available
- C: no matching
- D: some selected
View Answer
A
Q293: Which form of relational calculus involves specifying what data should be retrieved?
- A: Tuple Oriented
- B: Domain Oriented
- C: Procedural
- D: Declarative
View Answer
B
Q294: The result of a semi join will include attributes from:
- A: The second relation only
- B: The first relation only
- C: Both relations equally
- D: None of the relations
View Answer
B
Q295: In an outer join, tuples that do not match in both relations are left as:
- A: NULL values in both relations
- B: Empty rows in the output
- C: NULL values in one relation
- D: Non-matching attributes in both relations
View Answer
C
Q296: What is the Cartesian product used for in joins?
- A: To combine all rows from both relations
- B: To apply selection criteria before joining
- C: To ensure uniqueness of common attributes
- D: To filter rows based on a condition
View Answer
A
Q297: What is the concept on which normalization is based?
- A: Functional Dependency
- B: Entity Relationship
- C: Data Redundancy
- D: Data Integrity
View Answer
A
Q298: If A functionally determines B, what does this mean?
- A: B can be calculated from A
- B: A and B are always equal
- C: Each value of A has exactly one corresponding value of B
- D: A causes B
View Answer
C
Q299: What is a determinant in a functional dependency?
- A: The attribute on the right side of the arrow
- B: The attribute on the left side of the arrow
- C: The value that can be calculated from another
- D: A set of attributes not involved in functional dependency
View Answer
B
Q300: A super key is a set of attributes that:
- A: Can be used to uniquely identify an entity
- B: Identifies multiple rows in a table
- C: Is only used for indexing
- D: Does not affect the uniqueness of rows
View Answer
A