SQL Server MCQs with answers Page - 6

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

Q. In SQL Server 2012 how many types of checkpoints there?

  • (A) 6
  • (B) 5
  • (C) 4
  • (D) 3
πŸ’¬ Discuss
βœ… Correct Answer: (C) 4

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:54 pm in SQL Server

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
πŸ’¬ Discuss
βœ… Correct Answer: (D) .mdf

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:54 pm in SQL Server

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

  • (A) single
  • (B) double
  • (C) uniform
  • (D) mixed
πŸ’¬ Discuss
βœ… Correct Answer: (C) uniform

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:55 pm in SQL Server

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
πŸ’¬ Discuss
βœ… Correct Answer: (A) TRUE

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:55 pm in SQL Server

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
πŸ’¬ Discuss
βœ… Correct Answer: (A) Query Optimizer

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:56 pm in SQL Server

Q. The recommended extension for log file is ?

  • (A) .rdf
  • (B) .udf
  • (C) .ldf
  • (D) .idf
πŸ’¬ Discuss
βœ… Correct Answer: (C) .ldf

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 05:57 pm in SQL Server

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

  • (A) Avg
  • (B) Sum
  • (C) With
  • (D) Min
πŸ’¬ Discuss
βœ… Correct Answer: (C) With

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 10:44 pm in SQL Server

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

  • (A) CLEAR
  • (B) DROP
  • (C) REMOVE
  • (D) DELELTE
πŸ’¬ Discuss
βœ… Correct Answer: (D) DELELTE

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 10:46 pm in SQL Server

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
πŸ’¬ Discuss
βœ… Correct Answer: (D) SELECT COUNT() FROM Persons

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 10:47 pm in SQL Server

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
πŸ’¬ Discuss
βœ… Correct Answer: (D) SELECT city, temperature FROM weather ORDER BY city

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 10:47 pm in SQL Server

Programming Categories

πŸ“± Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play