SQL Server MCQs with answers Page - 13

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. __________menu allows user to set up some keyboard shortcuts.

  • (A) Edit
  • (B) File
  • (C) Tools
  • (D) None of these
💬 Discuss
✅ Correct Answer: (C) Tools

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:08 pm in SQL Server

Q. Which menu is used to restore windows to their original locations?

  • (A) Edit
  • (B) File
  • (C) Tools
  • (D) Windows
💬 Discuss
✅ Correct Answer: (D) Windows

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:08 pm in SQL Server

Q. Which of the following is used to build sql statements without writing code?

  • (A) Registered Servers
  • (B) Query Designer
  • (C) Template Explorer
  • (D) Context Explorer
💬 Discuss
✅ Correct Answer: (B) Query Designer

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:09 pm in SQL Server

Q. ______________ is schematic drawing used for representing relationships in database.

  • (A) Trigger
  • (B) Database Diagrams
  • (C) Table designer
  • (D) Query Editor
💬 Discuss
✅ Correct Answer: (B) Database Diagrams

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:09 pm in SQL Server

Q. The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

  • (A) model
  • (B) msdb
  • (C) master
  • (D) temp
💬 Discuss
✅ Correct Answer: (B) msdb

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

Q. Which of the following is a large object data type?

  • (A) varchar(max)
  • (B) varbinary(max)
  • (C) nvarchar(max)
  • (D) image
💬 Discuss
✅ Correct Answer: (D) image

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

Q. Data types in SQL Server are organized into how many categories?

  • (A) 6
  • (B) 7
  • (C) 9
  • (D) 11
💬 Discuss
✅ Correct Answer: (A) 6

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:11 pm in SQL Server

Q. An outstanding functionality of SQL is it’s the support for

  • (A) Gathering data
  • (B) Automatic navigation to the target data.
  • (C) Sorting data
  • (D) None of these
💬 Discuss
✅ Correct Answer: (B) Automatic navigation to the target data.

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:11 pm in SQL Server

Q. SQL does not need to know

  • (A) Data is right
  • (B) How data stored
  • (C) Data is wrong
  • (D) none of these
💬 Discuss
✅ Correct Answer: (B) How data stored

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:12 pm in SQL Server

Q. SQL server 2005 introduces notification support for

  • (A) SQL server queries
  • (B) DBMS
  • (C) C Language
  • (D) None of these
💬 Discuss
✅ Correct Answer: (A) SQL server queries

Published by Ram Sharma ⭐ 193.88K Points at 22-Jun-2022 06:12 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