NEW
Font size
Worksheetsdbms-22
Total questions: 8
Worksheet time: 4mins
The ............ JOIN keyword selects all rows from both the tables as long as the condition satisfies.
outer
inner
left
image represent which type of join?
left
outer join
inner
LEFT JOIN is also known as LEFT ..........JOIN
OUTER
INNER
NULL
................... join returns all the rows of the table on the left side of the join and matching rows for the table on the right side of join.
RIGHT
LEFT
OUTER
IMAGE REPRESENT WHICH TYPE OF JOIN
RIGHT
LEFT
INNER
RIGHT JOIN is also known as RIGHT ............. JOIN.
INNER
OUTER
The rows for which there is no matching row on left side, the result-set will contain null.
STATEMENT IS TRUE FOR WHICH JOIN?
LEFT JOIN
RIGHT JOIN
INNER JOIN
A ................ clause is used to combine rows from two or more tables, based on a related column between them
CONSTRAINTS
JOIN
DELETE
WHERE
