SQL Server MCQ

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

• Which of the following is a disadvantage of replication?
  ক

  Improved performance

  খ

  To move data closer to the user

  গ

  Easy maintenance

  ঘ

  None of the mentioned
• 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
• 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