Join Expressions MCQ

Test your knowledge with important Join Expressions MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Join Expressions MCQs at Bissoy

• If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?
  ক

  They are given null values

  খ

  They are given a random value

  গ

  The user is asked to enter data

  ঘ

  The query is declared invalid by the compiler
• Which off the following is not a valid type of join?
  ক

  left outer join

  খ

  outer join

  গ

  join

  ঘ

  full join
• State true or false: on and where behave differently for outer join
  ক

  True

  খ

  False
• What is the function of inner join?
  ক

  It preserves tuples only in the relation named before the operation

  খ

  It preserves tuples only in the relation named after the operation

  গ

  It preserved tuples in the relations named on both the sides of the operation

  ঘ

  It does not preserve any tuples on either side of the relation
• What is the function of a right outer join?
  ক

  It preserves tuples only in the relation named before the operation

  খ

  It preserves tuples only in the relation named after the operation

  গ

  It preserved tuples in the relations named on both the sides of the operation

  ঘ

  It does not preserve any tuples on either side of the relation
• What is the function of a full outer join?
  ক

  It preserves tuples only in the relation named before the operation

  খ

  It preserves tuples only in the relation named after the operation

  গ

  It preserved tuples in the relations named on both the sides of the operation

  ঘ

  It does not preserve any tuples on either side of the relation
• What is the function of a left outer join?
  ক

  It preserves tuples only in the relation named before the operation

  খ

  It preserves tuples only in the relation named after the operation

  গ

  It preserved tuples in the relations named on both the sides of the operation

  ঘ

  It does not preserve any tuples on either side of the relation
• The join operations that do not retain mismatched tuples are called as _________ operations
  ক

  outer join

  খ

  natural join

  গ

  full outer join

  ঘ

  inner join
• What is the difference between a join and an outer join operation?
  ক

  There is no difference

  খ

  Join preserves a few tuples that are otherwise lost in the outer join

  গ

  Outer join preserves a few tuples that are otherwise lost in the join

  ঘ

  An outer join can be used only on outer queries whereas a join operation can be used in Subqueries
• The on condition appears at the _______ of the join expression
  ক

  Beginning

  খ

  End

  গ

  Between

  ঘ

  The on condition is not related to join expression
• In SQL the statement select * from R, S is equivalent to
  ক

  Select * from R natural join S

  খ

  Select * from R cross join S

  গ

  Select * from R union join S

  ঘ

  Select * from R inner join S
• The operation which is not considered a basic operation of relational algebra is
  ক

  Join

  খ

  Selection

  গ

  Union

  ঘ

  Cross product
• 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:
  ক

  Left outer join

  খ

  Right outer join

  গ

  Full outer join

  ঘ

  Half outer join
• How many join types in join condition:
  ক

  2

  খ

  3

  গ

  4

  ঘ

  5
• Which are the join types in join condition:
  ক

  Cross join

  খ

  Natural join

  গ

  Join with USING clause

  ঘ

  All of the mentioned
• Which of the join operations do not preserve non matched tuples?
  ক

  Left outer join

  খ

  Right outer join

  গ

  Inner join

  ঘ

  Natural join
• The____condition allows a general predicate over the relations being joined.
  ক

  On

  খ

  Using

  গ

  Set

  ঘ

  Where