Algebra Operations in DBMS Multiple Choice Questions (MCQ) 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