Q30 Which three statements are true about inner and outer joins? (Choose three.)
- (A). A full outer join returns matched and unmatched rows
- (B). An inner join returns matched rows
- (C). Outer joins can only be used between two tables per query
- (D). A full outer join must use Oracle syntax
- (E). Outer joins can be used when there are multiple join conditions on two tables
- (F). A left or right outer join returns only unmatched rows
Answer: A,B,E