Joins MCQ

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

• Which is not a type of join in T-SQL?
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  Cartesian join
• The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  Cartesian join
• How many tables may be included with a join?
  ক

  One

  খ

  Two

  গ

  Three

  ঘ

  All of the Mentioned
• Which of the following is a correlated subquery?
  ক

  Uses the result of an inner query to determine the processing of an outer query

  খ

  Uses the result of an outer query to determine the processing of an inner query

  গ

  Uses the result of an inner query to determine the processing of an inner query

  ঘ

  Uses the result of an outer query to determine the processing of an outer query
• Which of the following statements is true concerning subqueries?
  ক

  Involves the use of an inner and outer query

  খ

  Cannot return the same result as a query that is not a subquery

  গ

  Does not start with the word SELECT

  ঘ

  All of the mentioned
• A UNION query is which of the following?
  ক

  Combines the output from no more than two queries and must include the same number of columns

  খ

  Combines the output from no more than two queries and does not include the same number of columns

  গ

  Combines the output from multiple queries and must include the same number of columns

  ঘ

  Combines the output from multiple queries and does not include the same number of columns
• The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  Cartesian join
• Which of the following is one of the basic approaches for joining tables?
  ক

  Subqueries

  খ

  Union Join

  গ

  Natural join

  ঘ

  All of the Mentioned
• What type of join is needed when you wish to return rows that do have matching values?
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  All of the Mentioned
• What type of join is needed when you wish to include rows that do not have matching values?
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  All of the Mentioned