Algebra Operations in DBMS MCQ (Multiple Choice Questions) PDF Download

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

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

The second extended relational-algebra operation is the

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

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

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

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

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