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

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

  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

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

  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

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

  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

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

  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