SQL Server MCQs with answers Page - 7

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. Which of the following is not a mathematical function ?

  • (A) CEIL
  • (B) PI
  • (C) POWER
  • (D) ATN2
💬 Discuss
✅ Correct Answer: (A) CEIL

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

Q. A column of type __________ may contain rows of different data types.

  • (A) ntext
  • (B) date
  • (C) smallmoney
  • (D) sql_variant
💬 Discuss
✅ Correct Answer: (D) sql_variant

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

Q. LocalDB was introduced in which of the following versions of SQL Server ?

  • (A) 2012
  • (B) 2008
  • (C) 2014
  • (D) 2008 R2
💬 Discuss
✅ Correct Answer: (A) 2012

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

Q. Which of the following is one of the basic approaches for joining tables?

  • (A) Subqueries
  • (B) Natural join
  • (C) Union Join
  • (D) All of the Mentioned
💬 Discuss
✅ Correct Answer: (D) All of the Mentioned

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

Q. Template Explorer is used to manage ____________

  • (A) T-SQL scripts
  • (B) Query design
  • (C) Registered Servers
  • (D) Properties
💬 Discuss
✅ Correct Answer: (A) T-SQL scripts

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

Q. Ctrl+K+K shortcut refers to ___________

  • (A) Enable all bookmarks
  • (B) Move to the next bookmark
  • (C) Refresh IntelliSense
  • (D) Add or remove a bookmark
💬 Discuss
✅ Correct Answer: (D) Add or remove a bookmark

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

Q. Point out the wrong statement :

  • (A) Limit-EventLog is used to limit the size of the event log
  • (B) The first PowerShell cmdlet every administrator should learn is Get-Command
  • (C) Get-Event is used to find events in the PowerShell event queue
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (B) The first PowerShell cmdlet every administrator should learn is Get-Command

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

Q. Dynamic Management View is a type of

  • (A) System Defined Views
  • (B) Complex View
  • (C) User Defined View
  • (D) Simple View
💬 Discuss
✅ Correct Answer: (A) System Defined Views

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

Q. What is a field?

  • (A) A group of records
  • (B) A list of information
  • (C) A single item of information
  • (D) A collection of information
💬 Discuss
✅ Correct Answer: (C) A single item of information

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

Q. Which SQL function is used to count the number of rows in a SQL query?

  • (A) COUNT(*)
  • (B) SUM()
  • (C) NUMBER()
  • (D) COUNT()
💬 Discuss
✅ Correct Answer: (A) COUNT(*)

Published by Ram Sharma ⭐ 193.88K Points at 21-Jun-2022 10:53 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