Relational Operations Multiple Choice Questions with Answers – PDF Download

MCQ 1: The operation that performs a set union of two similarly structured tables, is known as:

1. Union operation
2. Join operation
3. Cartesian Product operation
4. Intersection operation

MCQ 2: The relational algebra operation that return rows of the input relation that satisfy the predicate, is known as:

1. Projection
2. Selection
3. Natural join
4. Union operation

MCQ 3: Algebraic operation that outputs specified attributes from all rows of the input relation, is said to be:

1. Natural join
2. Union operation
3. Projection
4. Selection

MCQ 4: The relational operations have the nice and desired property that their result is always:

1. Pair of relations
2. Single relations
3. Sequence of relations
4. No relations

MCQ 5: Specifically, the result of a relational query is a:

1. Relational
2. Sequence
3. Operation
4. Domain