Relational Algebra and Calculus - Quiz

  • AUnion
  • BJoin
  • CCartesian product
  • DAll of these
  • AIt includes all the tuples from both the relations satisfying the join condition along with all the tuples in the right relation that do not have a corresponding tuple in the left relation.
  • BIt includes all the tuples from both the relations satisfying the join condition along with all the tuples in the left relation that do not have a corresponding tuple in the right relation.
  • CIt selects all the tuples satisfying the join condition along with the tuples for which no tuples from the other relation satisfy the join condition.
  • DNone of these
  • AThe relation R for which tuple variable T is defined.
  • BA condition P(T) on the basis of which a set of tuples is to be retrieved.
  • CAn attribute list specifying the required attributes to be retrieved for the tuples satisfying the given condition.
  • DAll of these
  • ASelect A
  • BSelect B
  • CSelect C
  • DSelect D All of these
  • AJoin, cartesian product (multiplication), division
  • BProject, restriction, union
  • CUnion, intersection, minus
  • DUpdate, insert, delete
  • ANone of these
  • BBoth (a) and (b)
  • CAssociative
  • DCommutative