Senior Technical Support Engineer Interview Questions and Answers for Freshers

Joins are used to combine data from two or more tables based on a related column between them.

• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the right table

• Right join returns all rows from the right table and matching rows from the left table

• Full outer join returns all rows from both tables

• Cross join returns the Cartesian product of both tables