Home / CSE MCQs / DBMS MCQs :: Joins - DBMS

CSE MCQs :: DBMS MCQs

  1. The____condition allows a general predicate over the relations being joined.
  2. A.
    On
    B.
    Using
    C.
    Set
    D.
    Where

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the join operations do not preserve non matched tuples.
  4. A.
    Left outer join
    B.
    Right outer join
    C.
    Inner join

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. What type of join is needed when you wish to include rows that do not have matching values?
  6. A.
    Equi-join
    B.
    Natural join
    C.
    Outer join
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. How many tables may be included with a join?
  8. A.
    One
    B.
    Two
    C.
    Three
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which are the join types in join condition:
  10. A.
    Cross join
    B.
    Natural join
    C.
    Join with USING clause
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. How many join types in join condition:
  12. A.
    2
    B.
    3
    C.
    4
    D.
    5

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which join refers to join records from the right table that have no matching key in the left table are include in the result set:
  14. A.
    Left outer join
    B.
    Right outer join
    C.
    Full outer join
    D.
    Half outer join

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The operation which is not considered a basic operation of relational algebra is
  16. A.
    Join
    B.
    Selection
    C.
    Union
    D.
    Cross product

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. In SQL the statement select * from R, S is equivalent to
  18. A.
    Select * from R natural join S
    B.
    Select * from R cross join S
    C.
    Select * from R union join S
    D.
    Select * from R inner join S

    View Answer

    Workspace

    Discuss Discuss in Forum