Relational Algebra and Calculus - Quiz

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

The join operation where only matching tuples are kept in the result is called__________.

  • A Outer join
  • B Left outer join
  • C Inner join
  • D Right outer join

If relation R has m tuples and relation S has n tuples, then the result of join on relations R and S will have up to_________tuples.

  • A m * n
  • B m / n
  • C m + n
  • D m - n

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

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 the symbol for an existential quantifier?

Which of the following is true for a right outer join?

  • A It 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.
  • B It 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.
  • C It selects all the tuples satisfying the join condition along with the tuples for which no tuples from the other relation satisfy the join condition.
  • D None of these

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