SQL Server MCQs with answers Page - 19

Here, you will find a collection of MCQ questions on SQL Server. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

  • (A) SELECT * FROM weather WHERE humidity IN (63 to 79)
  • (B) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
  • (C) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
  • (D) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

A

Admin • 833.24K Points
Coach

Q. The command to remove rows from a table ‘CUSTOMER’ is __________________

  • (A) DROP FROM CUSTOMER
  • (B) UPDATE FROM CUSTOMER
  • (C) REMOVE FROM CUSTOMER
  • (D) DELETE FROM CUSTOMER WHERE

A

Admin • 833.24K Points
Coach

Q. The following SQL is which type of join:

Code: 
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
  • (A) Cartesian join
  • (B) Outer join
  • (C) Natural join
  • (D) Equi-join

A

Admin • 833.24K Points
Coach

Q. Which is not a type of join in T-SQL?

  • (A) Cartesian join
  • (B) Outer join
  • (C) Natural join
  • (D) Equi-join

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a limitation of view?

  • (A) Adding Column is Expensive by Joining Table Outside View
  • (B) Cross Database Queries Not Allowed in Indexed View
  • (C) Index Created on View Used Often
  • (D) ORDER BY Does Not Work

A

Admin • 833.24K Points
Coach

Q. Dynamic Management View is a type of ___________

  • (A) Complex View
  • (B) Simple View
  • (C) User Defined View
  • (D) System Defined Views

A

Admin • 833.24K Points
Coach

Q. The main memory requirements for SQL Server 2008 includes ___________

  • (A) Maximum:512 MB
  • (B) Maximum:252 MB
  • (C) Minimum:1 GB
  • (D) Minimum:512 MB

A

Admin • 833.24K Points
Coach

Q. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?

  • (A) 811 Mb
  • (B) 711 Mb
  • (C) 611 Mb
  • (D) 511 Mb

A

Admin • 833.24K Points
Coach

Q. Point out the correct statement.

  • (A) SQL Server books online is part of Microsoft SQL Server 2012
  • (B) SQL Server books online is not a part of Microsoft SQL Server 2008
  • (C) Resource database is part of System database
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which components of SQL Server 2014 require 1182 Mb?

  • (A) SSRS
  • (B) Client components
  • (C) SSAS
  • (D) SSIS

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.