Home / CSE MCQs / DBMS MCQs :: Relational Algebra - DBMS

CSE MCQs :: DBMS MCQs

  1. Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.
  2. A.
    Relational
    B.
    Structural
    C.
    Procedural
    D.
    Fundamental

  3. Which of the following is a fundamental operation in relational algebra ?
  4. A.
    Set intersection
    B.
    Natural join
    C.
    Assignment
    D.
    None of the mentioned

  5. Which of the following is used to denote the selection operation in relational algebra ?
  6. A.
    Pi (Greek)
    B.
    Sigma (Greek)
    C.
    Lambda (Greek)
    D.
    Omega (Greek)

  7. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
  8. A.
    Predicates, relation
    B.
    Relation, Predicates
    C.
    Operation, Predicates
    D.
    Relation, Operation

  9. The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.
  10. A.
    Union
    B.
    Set-difference
    C.
    Difference
    D.
    Intersection

  11. Which is a unary operation:
  12. A.
    Selection operation
    B.
    Primitive operation
    C.
    Projection operation
    D.
    Generalized selection

  13. Which is a join condition contains an equality operator:
  14. A.
    Equijoins
    B.
    Cartesian
    C.
    Natural
    D.
    Left

  15. In precedence of set operators the expression is evaluated from
  16. A.
    Left to left
    B.
    Left to right
    C.
    Right to left
    D.
    From user specification

  17. Which of the following is not outer join ?
  18. A.
    Left outer join
    B.
    Right outer join
    C.
    Full outer join
    D.
    All of the mentioned