1D0-541 · Question #119
Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?
The correct answer is C. Natural join. See the full explanation below for the reasoning.
Question
Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic operation would yield the Activity Relation table in the exhibit?
Exhibit
Options
- AUnion
- BIntersection
- CNatural join
- DCartesian product
How the community answered
(28 responses)- A4% (1)
- B4% (1)
- C82% (23)
- D11% (3)
Community Discussion
4
Mei-Ling H.Jun 13, 2026The answer is C, Natural join, because this operation combines two tables by matching on their common column (the activity ID or code that appears in both Stu_Act and Act_Fee) and returns a single merged relation with no duplicate columns, which is exactly what the Activity Relation in the exhibit shows. Cartesian product (D) would give every possible row combination with no matching condition, Union and Intersection (A, B) require the tables to have the same structure, so those three are all eliminated by the exhibit layout alone.
Hiroshi T.Jun 18, 2026I kept second-guessing myself toward Union, but matching columns on the shared key is Natural join.
Ingrid P.Jun 19, 2026Natural join is right for matching on the shared key name, but make sure you have a card for the edge case where Natural join can silently drop columns if the shared column name appears in more tables than you intended, which is why many instructors contrast it directly with Theta join on the same exam objective.
Ingrid P.Jun 2, 2026Natural join is the right call here because it combines Stu_Act and Act_Fee on the shared attribute without duplicating that column, which is exactly what the Activity Relation output shows. I saw a question structured just like this on my actual 541 sitting and I got it instantly because I had drilled a card with the front "relational op that merges tables on common attribute, no duplicate column" and the back just said "natural join," so the interval had pushed that fact deep enough that it fired before I even finished reading the stem.