Computer Science Degree Courses

Database Management System Practice Tests

Database Management System Online Tests

Books:

Apps:

The Relational Operations Multiple Choice Questions (MCQ Quiz) with Answers PDF (Relational Operations MCQ PDF Download) e-Book to practice Database Management System Tests. Learn Relational Algebra and Calculus Multiple Choice Questions and Answers (MCQs), Relational Operations quiz answers PDF for online computer science programs. The Relational Operations MCQ App Download: Free learning app for select and project, binary relational operation: join and division, division operation, tuple relational calculus test prep for free online classes.

The MCQ: If matching tuples are not found, kind of OUTER JOIN operation which keeps all tuples of first and second relation is classified as; "Relational Operations" App Download (Free) with answers: LEFT OUTER JOIN; FULL OUTER JOIN; HALF OUTER JOIN; DOWNWARD JOIN; for online computer science programs. Practice Relational Operations Quiz Questions, download Google eBook (Free Sample) for best online schools for computer science.

## Relational Operations MCQs: Questions and Answers

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