Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q281: In equi-join, the output relation will have:
- A: Only non-matching rows from both tables
- B: Only matching rows from both tables
- C: Matching rows with common attributes appearing once
- D: Matching rows with common attributes appearing twice
View Answer
C
Q282: What does a natural join do with common attributes between two relations?
- A: Repeats them twice
- B: Removes them completely
- C: Includes them only once
- D: Includes them as NULL
View Answer
D
Q283: What type of join will always include all rows from the right relation?
- A: Left Outer Join
- B: Right Outer Join
- C: Full Outer Join
- D: Cross Join
View Answer
B
Q284: In a left outer join, tuples of the left relation with no match in the right relation will have:
- A: Null values in the right relation attributes
- B: Matching values in the right relation attributes
- C: Empty rows in the output
- D: Non-matching attributes from the left relation
View Answer
A
Q285: In tuple-oriented relational calculus, what is primarily used to find relation tuples?
- A: Predicate variables
- B: Domain variables
- C: Tuple variables
- D: Attribute variables
View Answer
C
Q286: Normalization is a process performed on:
- A: Database tables only
- B: Conceptual database design only
- C: Logical database design only
- D: Each table of the database
View Answer
D
Q287: What does relational calculus focus on?
- A: How to retrieve data
- B: What data should be retrieved
- C: How to create tables
- D: How to perform joins
View Answer
B
Q288: What is the main objective of normalization?
- A: To place the database in the highest form of normalization
- B: To remove all redundancy from the database
- C: To combine all tables into one
- D: To create backup copies of the database
View Answer
A
Q289: In the normalization process, if a table fulfills the requirements of the second form, it is said to be in:
- A: First Normal Form
- B: Second Normal Form
- C: Third Normal Form
- D: Fourth Normal Form
View Answer
B
Q290: Which type of join is similar to equi-join but removes duplicate common attributes?
- A: Natural Join
- B: Theta Join
- C: Semi Join
- D: Left Outer Join
View Answer
A