Relational Algebra Multiple Choice Questions with Answers – PDF Download

MCQ 1: In a natural join if the two are equivalent in an expression, is said to be:

1. Definitive
2. Predictive
3. Associative
4. Assignment

MCQ 2: The predicate of a selection statement may include comparisons between:

1. Two attributes
2. Multiple attributes
3. Two relations
4. Multiple relations

MCQ 3: In the relational algebra, the select, project, and rename operations are known as:

1. Dimensional operations
2. Multidimensional operations
3. Unary operations
4. Binary operations

MCQ 4: The operation of projection is a:

1. Dimensional operations
2. Multidimensional operations
3. Unary operations
4. Binary operations

MCQ 5: The projection that allows extension of operations, i.e. arithmetic and string functions to be used in the projection list, is known as:

1. Embedded Projection
2. Extended Projection
3. Generalized Projection
4. Aggregation Projection