i think A, B, E is the correct answer
E. Outer joins can be used when there are multiple join conditions on two tables
can be like following query :
- select * from table a left join table1 b on a.col1 = b.col1 and a.col2=b.col2;
The three statements that are true about inner and outer joins are:
A. A full outer join returns matched and unmatched rows.
B. An inner join returns matched rows.
E. Outer joins can be used when there are multiple join conditions on two tables.
The other statements are false:
C. Outer joins can only be used between two tables per query. Outer joins can be used between any number of tables per query.
D. A full outer join must use Oracle syntax. Full outer joins can be implemented in any SQL database, not just Oracle.
F. A left or right outer join returns only unmatched rows. A left or right outer join returns all rows from the left or right table, respectively, even if there are no matching rows in the other table.
F. A left or right outer join returns only unmatched rows
To be TRUE it should be
"F. A left or right outer join returns only unmatched rows FOR THE JOINED TABLE"
because F : LEFT JOIN returns only unmatched rows from the left table. RIGHT JOIN returns only unmatched rows from the right table.
https://mode.com/sql-tutorial/sql-outer-joins/
F is wrong!! A left join returns all rows from the left table and rows from the right table where the join condition is met! Left or Right Joins DO NOT return only unmatched rows!
So if we have table1 (left table) and table2 (right table): The left join would return all records from table1 and only those records from table2 that intersect with table1.
I would go with answers: A,B,E
ama is correct. I read his reference.
There are a few types of outer joins:
LEFT JOIN returns only unmatched rows from the left table.
RIGHT JOIN returns only unmatched rows from the right table.
FULL OUTER JOIN returns unmatched rows from both tables.
F is wrong
it's not "ONLY"
- Right Outer Join returns all the rows from the table on the right and columns of the table on the left is null padded.
- Left Outer Join returns all the rows from the table on the left and columns of the table on the right is null padded.
https://www.geeksforgeeks.org/difference-between-left-right-and-full-outer-join/
F is wrong
it's not "ONLY"
- Right Outer Join returns all the rows from the table on the right and columns of the table on the left is null padded.
- Left Outer Join returns all the rows from the table on the left and columns of the table on the right is null padded.
https://www.geeksforgeeks.org/difference-between-left-right-and-full-outer-join/
F?
The left outer join returns a resultset table with the matched data from the two tables and then the remaining rows of the left table and null from the right table's columns.
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.
danito
Highly Voted 3 years, 7 months agoEkos
Highly Voted 3 years, 2 months agoLalala8
Most Recent 3 months, 2 weeks agoLeandroHPN
1 year, 6 months agoryuah
2 years agokrontar
2 years, 3 months agokrontar
2 years, 3 months agoSimoneF
3 years agoescoletsgo1
3 years, 4 months agoama
3 years, 5 months agoNiciMilo
3 years, 5 months agoama
3 years, 5 months agoadoptc94
3 years, 4 months agoYema
2 years, 10 months agosaad3577
1 year, 3 months agoyou1234
3 years, 6 months agosaad3577
1 year, 3 months agoama
3 years, 6 months ago