CLOUD COMPUTING
DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Outer join
|
|
|
Natural join
|
|
|
Self Join
|
|
|
Equi join
|
Detailed explanation-1: -A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined. Common columns are columns that have the same name in both tables. A NATURAL JOIN can be an INNER join, a LEFT OUTER join, or a RIGHT OUTER join. The default is INNER join.
Detailed explanation-2: -The natural join is equal to : Cartesian Product.
Detailed explanation-3: -The NATURAL [LEFT] JOIN of two tables is defined to be semantically equivalent to an INNER JOIN or a LEFT JOIN with a USING clause that names all columns that exist in both tables. RIGHT JOIN works analogously to LEFT JOIN .
Detailed explanation-4: -Equi join has the column name of both the tables in the resulting table whereas natural join only has one of the column names in the resulting table. The common column name of participating tables in the natural join should be the same but the common colmn name me to be different in case if Equi joins.