Q: 10
Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?
Options
Discussion
Not sure I buy A and D only. B seems legit since with a self join you often use inner join syntax, just different aliases on the same table. So I'd say B and D-self joins can still be written using INNER JOIN, right? I might be missing something subtle here though. Did others get tripped up by Oracle's phrasing?
A and D make sense here. Self join (A) is the standard for comparing/relating rows within a single table, usually using aliases. D also checks out since you often join more tables to bridge indirect relations, especially with normalization or many-to-many setups. I think these are the intended answers but let me know if you see it differently.
A and D imo. Self joins (A) are classic for comparing rows in the same table, and sometimes you need an extra table in the join chain (D), like when there's a many-to-many relationship. B doesn't fit since inner joins are normally between different tables, even if you alias. Pretty sure these are the best picks but Oracle does word things funny sometimes.
Every Oracle exam mixes in a trick like this, it's B and D.
Pretty sure B is also valid since inner joins can link rows, even within the same table if you alias it. Picking B and D. Maybe I'm missing a subtle Oracle-specific rule here…
Probably A and D. Both fit with how joins work in SQL, but not totally sure if I missed something.
A D
Probably A and D. Quick check, these fit how ERDs map relationships and self joins. Not totally sure on D in every use case but matches most Oracle questions I've seen. Disagree?
A/D imo, pretty sure C is a trap since you can join unrelated tables as long as there's a logical condition. Open to other thoughts.
A/D-had something like this in a mock and those were the picks.
Be respectful. No spam.