Binary Relational Operation JOIN and DIVISION Multiple Choice Questions (MCQ) PDF Download

MCQ 1: If in the JOIN operation, the conditions of JOIN operation are not satisfied then the results of the operation is

1. zero tuples and empty relation
2. one tuple from one relation
3. zero tuples from two relation
4. two tuples from empty relations

MCQ 2: In the EQUIJOIN condition, the operation which is used to avoid superfluous attribute is classified as

1. ALPHA JOIN
2. NATURAL JOIN
3. UNNATURAL JOIN
4. THETA JOIN

MCQ 3: The operation which allows to process relationships from multiple relations rather than single relation is classified as

1. division operation
2. relation operation
3. square operation
4. join operation

MCQ 4: The JOIN operation which uses any of the comparison operators is classified as

1. THETA JOIN
2. CHI-JOIN
3. PI-JOIN
4. SIGMA-JOIN

MCQ 5: The kind of operation by which one tuple can be created with the help of combining tuples from two relations is classified as

1. square operation
2. join operation
3. division operation
4. relation operation