What is difference between physical join and logical joins

Question

Accepted Answer

Physical join refers to the actual combination of data from two or more tables, while logical join refers to the method used to combine the data.

Physical join involves the actual merging of tables, while logical join involves the use of operators such as AND, OR, and NOT to combine data.
Physical join can be performed using different techniques such as nested loop join, hash join, and merge join, while logical join can be performed using different types such as inner join, outer join, and cross join.
Physical join can be more time-consuming and resource-intensive than logical join, as it involves accessing and manipulating large amounts of data.
Examples of physical join include hash join, merge join, and nested loop join, while examples of logical join include inner join, outer join, and cross join.

Top T-Systems ICT India Senior Consultant interview questions & answers