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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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)

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum