DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
M
|
|
|
N
|
|
|
The smaller of M or N
|
|
|
A number in the range 0 to M*N
|
Detailed explanation-1: -The EQUI JOIN creates a new result table when it combines the values of columns of two tables (like the table a and the table b) on the basis of the join-predicate. In case the join predicate gets satisfied, the values of the columns for every matched pair of the A and B rows get combined into a resultant row.
Detailed explanation-2: -The RIGHT JOIN command returns all rows from the right table, and the matching records from the left table. The result is NULL from the left side, when there is no match.
Detailed explanation-3: -The column names do not need to be the same. The resultant table contains repeated columns. It is possible to perform an equi join on more than two tables.
Detailed explanation-4: -Equi join in SQL is a type of Inner Join in which two or more tables are joined by equating the common column values of the tables. The table participating in Equi join should have at least one common column on which equality operation can be performed.