algebra operations in dbms

mcqspedia.com has 5 Question/Answers about Topic algebra operations in dbms

Operation that takes both left and right outer join operations, is known as

Operation that takes both left and right outer join operations, is known as
  • A. Whole outer join
  • B. Full outer join
  • C. Natural outer join
  • D. Combination outer join
  • Correct Answer: Option B

Aggregate function that returns number of elements in collection is known as

Aggregate function that returns number of elements in collection is known as
  • A. total
  • B. count
  • C. whole
  • D. combine
  • Correct Answer: Option B

Operations with ability to express queries that cannot be expressed by basic relational-algebra operations, is known as

Operations with ability to express queries that cannot be expressed by basic relational-algebra operations, is known as
  • A. Compound relational-algebra
  • B. Composite relational-algebra
  • C. Embedded relational-algebra
  • D. Extended relational-algebra
  • Correct Answer: Option D

Second extended relational-algebra operation is the

Second extended relational-algebra operation is the
  • A. Aggregate operation
  • B. Embedded operations
  • C. Generalized operation
  • D. Extended operation
  • Correct Answer: Option A

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

Aggregate functions can operate over multiple occurrences of a value, known to be
  • A. multisets
  • B. multidata
  • C. multivalue
  • D. multirelation
  • Correct Answer: Option A