Discussion
What type of JOIN returns all records from both tables ?
Answer: D
The join that returns all records from both tables is the FULL OUTER JOIN.
A full outer join returns every matching pair of rows, plus every unmatched row from the left table and every unmatched row from the right table, with NULLs filling the columns that have no match.
An INNER JOIN keeps only the rows that match in both tables. A LEFT JOIN keeps all rows of the left table but only the matching rows of the right, and a RIGHT JOIN does the reverse.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development