Join Operations MCQ

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

• Which view that contains more than one table in the top-level FROM clause of the SELECT statement:
  ক

  Join view

  খ

  Datable join view

  গ

  Updatable join view

  ঘ

  All of the mentioned
• Which operation are allowed in a join view:
  ক

  UPDATE

  খ

  INSERT

  গ

  DELETE

  ঘ

  All of the mentioned
• Which join refers to join records from the write 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
• Which product is returned in a join query have no join condition:
  ক

  Equijoins

  খ

  Cartesian

  গ

  Both Equijoins and Cartesian

  ঘ

  None of the mentioned
• Which oracle is the join condition is specified using the WHERE clause:
  ক

  Oracle 9i

  খ

  Oracle 8i

  গ

  Pre-oracle 9i

  ঘ

  Pre-oracle 8i
• A condition is referred to as __________
  ক

  Join in SQL

  খ

  Join condition

  গ

  Join in SQL & Condition

  ঘ

  None of the mentioned
• A_____ is a query that retrieves rows from more than one table or view:
  ক

  Start

  খ

  End

  গ

  Join

  ঘ

  All of the mentioned