Relational Operations Multiple Choice Questions with Answers – PDF Download

MCQ 1: The operation which is used to take union of tuples from the relations that are not union compatible is classified as:

1. FULL UNION operation
2. JOIN UNION operation
3. OUTER UNION operation
4. INNER UNION operation

MCQ 2: If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of first and second relation is classified as:

1. LEFT OUTER JOIN
2. FULL OUTER JOIN
3. HALF OUTER JOIN
4. DOWNWARD JOIN

MCQ 3: The operations which are used to enhance the power of expression of relational algebra includes:

1. generalized projection
2. recursive closure operations
3. outer JOIN operations
4. all of above

MCQ 4: If the common attributes of two relations are classified as join attributes then the OUTER UNION must be equal to:

1. LEFT OUTER JOIN
2. FULL OUTER JOIN
3. HALF OUTER JOIN
4. DOWNWARD JOIN

MCQ 5: If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of second relation out of the two relations is classified as:

1. UPWARD JOIN
2. DOWNWARD JOIN
3. LEFT OUTER JOIN
4. RIGHT OUTER JOIN