The join in which all the rows from the right table appear in the outp – McqOptions

MCQOPTIONS

1.	The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________.
A.	RIGHT JOIN
B.	CARTESIAN JOIN
C.	CROSS JOIN
D.	INNER JOIN
E.	None of these
Answer» B. CARTESIAN JOIN

Discussion

No Comment Found

Related MCQs

The one that is not optional is _____________.SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
The header that should be included first is ________________.
The clause that is used to display information that matches a given pattern is _____________.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________.
The operator that compares sounds is _____________.
The facility that allows nesting one select statement into another is ______________.
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________.
The one that is not optional is _____________.
Which statement can produce the same output as SHOW COLUMNS ?
The statement that alters an existing event to have the given definition is _____________.