SQL Server MCQs with answers Page - 6

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 • 831.35K Points
Coach

Q. Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?

  • (A) .pdf
  • (B) .ldf
  • (C) .ndf
  • (D) .mdf

A

Admin • 831.35K Points
Coach

Q. Which extents are made up of only single object?

  • (A) single
  • (B) double
  • (C) uniform
  • (D) mixed

A

Admin • 831.35K Points
Coach

Q. Each log record is identified by Log Sequence Number (LSN).

  • (A) TRUE
  • (B) FALSE
  • (C) Can be true or false
  • (D) Can not say

A

Admin • 831.35K Points
Coach

Q. Which of the following prepare the execution plan as output by taking query, statistics and Algebrizer tree as input?

  • (A) Query Optimizer
  • (B) Query Executor
  • (C) Execution Plan
  • (D) Query Parser

A

Admin • 831.35K Points
Coach

Q. The recommended extension for log file is ?

  • (A) .rdf
  • (B) .udf
  • (C) .ldf
  • (D) .idf

A

Admin • 831.35K Points
Coach

Q. Which of the following is not a aggregate function ?

  • (A) Avg
  • (B) Sum
  • (C) With
  • (D) Min

A

Admin • 831.35K Points
Coach

Q. Which of the following SQL clauses is used to DELETE tuples from a database table ?

  • (A) CLEAR
  • (B) DROP
  • (C) REMOVE
  • (D) DELELTE

A

Admin • 831.35K Points
Coach

Q. With SQL, how can you return the number of not null records in the "Persons table ?

  • (A) SELECT COUNT(*) FROM Persons
  • (B) SELECT COLUMNS(*) FROM Persons
  • (C) SELECT COLUMNS() FROM Persons
  • (D) SELECT COUNT() FROM Persons

A

Admin • 831.35K Points
Coach

Q. SQL query to find the temperature in increasing order of all cities.

  • (A) SELECT city FROM weather ORDER BY temperature
  • (B) SELECT city, temperature FROM weather
  • (C) SELECT city, temperature FROM weather ORDER BY temperature
  • (D) SELECT city, temperature FROM weather ORDER BY city

A

Admin • 831.35K Points
Coach

Q. Which of the following is not a mathematical function ?

  • (A) CEIL
  • (B) PI
  • (C) POWER
  • (D) ATN2

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.