SQL Joins MCQ

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

• In a query, JOIN condition can be used for only one time.
  ক

  True

  খ

  False
• How many conditions are required to join N number of tables?
  ক

  N conditions

  খ

  N+1 conditions

  গ

  N-2 conditions

  ঘ

  N-1 conditions
• Which type of join returns all the records when there is a match in either left or right table?
  ক

  Join

  খ

  Full join

  গ

  Self join

  ঘ

  Cartesian join
• Which type of join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join?
  ক

  Right join

  খ

  Left join

  গ

  Full join

  ঘ

  Inner join
• Which type of join returns all the records from the left table, and the matched records from the right table?
  ক

  Right join

  খ

  Inner join

  গ

  Left join

  ঘ

  Self join
• Which of the following type of join returns a list of rows for which there is a match in both of the specified tables?
  ক

  Outer join

  খ

  Full join

  গ

  Self join

  ঘ

  Inner join
• Which clause is used to fetch data from two or more tables, based on conditions between tables?
  ক

  Combine

  খ

  Join

  গ

  Merge

  ঘ

  Add