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;
E states that ONLY unmatched rows are found, and matched rows are not in the output. False
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
lucemqy
8 months, 3 weeks agozouve
1 year, 1 month agoKizTine
9 months, 3 weeks agoTofOra
6 months agoEltelwany
1 year, 4 months agoTofOra
6 months agoMoreC
1 year, 4 months agoPoke90
1 year, 4 months ago