Algebra Operations in DBMS Multiple Choice Questions with Answers – PDF Download

MCQ 1: Aggregate functions can operate over multiple occurrences of a value, known to be:

1. multisets
2. multidata
3. multivalue
4. multirelation

MCQ 2: The second extended relational-algebra operation is the:

1. Aggregate operation
2. Embedded operations
3. Generalized operation
4. Extended operation

MCQ 3: The operations with the ability to express queries that cannot be expressed by the basic relational-algebra operations, is known as:

1. Compound relational-algebra
2. Composite relational-algebra
3. Embedded relational-algebra
4. Extended relational-algebra

MCQ 4: The aggregate function that returns the number of the elements in the collection is known as:

1. total
2. count
3. whole
4. combine

MCQ 5: The operation that takes both the left and right outer join operations, is known as:

1. Whole outer join
2. Full outer join
3. Natural outer join
4. Combination outer join