If matching tuples are not found, kind of OUTER JOIN operation which k – McqOptions

MCQOPTIONS

1.	If matching tuples are not found, kind of OUTER JOIN operation which keeps all tuples of first and second relation is classified as
A.	LEFT OUTER JOIN
B.	FULL OUTER JOIN
C.	HALF OUTER JOIN
D.	DOWNWARD JOIN
Answer» C. HALF OUTER JOIN

Discussion

No Comment Found

Related MCQs

In unary relational operations, SELECT operation is partition of relation usually classified as
If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is
Because of calculus expression, relational calculus is considered as
DIVISION operation can be applied to two relations A and B such as R(A) R(B) where as
In EQUIJOIN condition, operation which is used to avoid superfluous attribute is classified as
Boolean expression used in SELECT operation consists of clauses such as
Types of binary operations includes
In unary relational operations, PROJECT operation is partition of relation usually classified as
JOIN operation in which two attributes joined have same name in both relations is classified as
Consider two tuples A and B, operation whose result includes tuples that are included in both relations is classified as