Which three statements are true about inner and outer joins? (Choose three.)
Which three statements are true about inner and outer joins? (Choose three.)
A full outer join returns matched and unmatched rows from both tables, making option A correct. Outer joins can indeed be used when there are multiple join conditions on two tables, aligning with option B. An inner join filters out unmatched rows and only returns matched rows, which confirms option F.
Full Outer join returns rows from both tables regardless of match. Inner join only return matched rows
From chagpt A. Option A is true. A full outer join returns both matched rows and unmatched rows from the joined tables. Matched rows are those that satisfy the join condition, while unmatched rows are those that do not have a matching row in the other table. B. Option B is true. Outer joins can be used when there are multiple join conditions on two tables. This allows for more complex join conditions and provides flexibility in joining tables based on multiple criteria. F. Option F is true. An inner join returns only the matched rows from the joined tables. It filters out the unmatched rows, resulting in a result set that contains only the rows that satisfy the join condition.
I can't understand why answer B is right. For example, the query below (with OUTER JOIN) works but don't use multiple join condiitions : SELECT A.col FROM tableA LEFT OUTER JOIN tableB ON tableA.col = tableB.col WHERE tableB.col IS NULL;
The question says "can" and not "must"
What exactly is the Oracle syntax here?
When you put the join condition in the WHERE instead of the JOIN
QUESTION UNMATCHED COLUMN ARE THEY NOT PRODUCED BY LEFT AND RIGHT OUTER JOINS
E states that ONLY unmatched rows are found, and matched rows are not in the output. False