If in JOIN operation, conditions of JOIN operation are not satisfied t – McqOptions

MCQOPTIONS

1.	If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is
A.	Zero tuples and empty relation
B.	One tuple from one relation
C.	Zero tuples from two relation
D.	Two tuples from empty relations
Answer» B. One tuple from one relation

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