SQL Server MCQs with answers Page - 10

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. Temp.db or tansaction.db database is

  • (A) Workspace for holding the permanent object.
  • (B) Workspace for holding the temporary object.
  • (C) Both A and B
  • (D) None of these
💬 Discuss
✅ Correct Answer: (B) Workspace for holding the temporary object.

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

Q. When SQL server is connected with a particular database then this database is called.

  • (A) Client database
  • (B) Server database.
  • (C) Security database
  • (D) Current database.
💬 Discuss
✅ Correct Answer: (D) Current database.

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

Q. SQL server object property is called.

  • (A) Delta data
  • (B) Unique data
  • (C) Hexa data
  • (D) Meta data
💬 Discuss
✅ Correct Answer: (D) Meta data

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

Q. Which panel presents a list of objects under the selected node?

  • (A) Template Explorer
  • (B) Object Explorer
  • (C) Properties window
  • (D) Query Editor
💬 Discuss
✅ Correct Answer: (B) Object Explorer

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

Q. Which of the following shortcut is used for displaying error list?

  • (A) Ctrl + /
  • (B) Ctrl + |
  • (C) Ctrl + \
  • (D) Ctrl + !
💬 Discuss
✅ Correct Answer: (C) Ctrl + \

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

Q. ____________ is not available on standard toolbar.

  • (A) Error List
  • (B) Object Explorer
  • (C) Query Editor
  • (D) Properties windows
💬 Discuss
✅ Correct Answer: (A) Error List

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

Q. Which command is used to reset default configuration in SSMS?

  • (A) Clear
  • (B) Hide
  • (C) Reset all
  • (D) Reset
💬 Discuss
✅ Correct Answer: (D) Reset

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

Q. ________ is tool in SSMS used to manage multiple servers.

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

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

Q. Which of the following is a database object?

  • (A) Tables
  • (B) Triggers
  • (C) Functions
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

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

Q. hich of the following tool is used for designing schema of the database in SSMS?

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

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