Relational Algebra and Calculus - Quiz

Which of the following is the component of a tuple relational calculus expression?

  • A The relation R for which tuple variable T is defined.
  • B A condition P(T) on the basis of which a set of tuples is to be retrieved.
  • C An attribute list specifying the required attributes to be retrieved for the tuples satisfying the given condition.
  • D All of these

The result of R(A1, A2, …, Am)XS(B1, B2, …, Bn) is a relation with__________ attributes.
  • A m + n
  • B m - n
  • C m * n
  • D n - m

Which of the following is not a valid aggregate function?

  • A COUNT
  • B COMPUTE
  • C AVG
  • D MAX

Which of the following relational algebra operations require two tables as input with exactly the same attributes?

  • A Join, cartesian product (multiplication), division
  • B Project, restriction, union
  • C Union, intersection, minus
  • D Update, insert, delete

Which of the following is the operation developed specifically for the relational databases?

  • A Union
  • B Cartesian product
  • C Division
  • D Difference

Intersection operation is_____________.

  • A None of these
  • B Both (a) and (b)
  • C Associative
  • D Commutative

Which of the following operation requires two tables as input and the two tables must have one common column?

  • A Join
  • B Division
  • C Cartesian product (multiplication)
  • D Projection

Which of the following is the binary operation?

  • A Union
  • B Join
  • C Cartesian product
  • D All of these

The truth value of a formula can be derived as __________.
  • A .
  • B .
  • C .
  • D .

Which of the following aggregate functions is used for counting tuples or values in a relation?

  • A Avg
  • B Count
  • C Max
  • D Min