Bachelor Of Computer Science

Database Management System MCQs

CS: Database Management System MCQs - Subtopic

Relational Operations MCQ with Answers

Relational Operations Multiple Choice Questions (MCQ) to solve relational operations quiz answers PDF worksheet, database management system test for online courses. Practice relational algebra and calculus Multiple Choice Questions and Answers (MCQs), "Relational Operations" quiz questions and answers to learn online certificate courses. Learn select and project, binary relational operation: join and division, division operation, tuple relational calculus test prep for 2 year computer science degree.

"The operation which is used to take union of tuples from the relations that are not union compatible is classified as" Multiple Choice Questions (MCQ) on relational operations with choices full union operation, join union operation, outer union operation, and inner union operation to learn online certificate courses. Solve relational operations quiz questions for merit scholarship test and certificate programs for computer and information science.

MCQs on Relational Operations

1.

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

FULL UNION operation
JOIN UNION operation
OUTER UNION operation
INNER UNION operation

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

LEFT OUTER JOIN
FULL OUTER JOIN
HALF OUTER JOIN
DOWNWARD JOIN

3.

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

generalized projection
recursive closure operations
outer JOIN operations
all of above

4.

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

LEFT OUTER JOIN
FULL OUTER JOIN
HALF OUTER JOIN
DOWNWARD JOIN

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

UPWARD JOIN
DOWNWARD JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN