SQL Server MCQs with answers Page - 9

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. _________ is free database software running free SQL Server technology.

  • (A) SQL Server Express
  • (B) SQL Server Workgroup
  • (C) SQL Server Enterprise
  • (D) SQL Server Web
💬 Discuss
✅ Correct Answer: (A) SQL Server Express

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

Q. __________is the first true GUI-based database server.

  • (A) SQL Server 7.0
  • (B) SQL Server 6.5
  • (C) SQL Server 2005
  • (D) SQL Server 2008
💬 Discuss
✅ Correct Answer: (A) SQL Server 7.0

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

Q. Management Studio is ________ used for development of SQL Server database.

  • (A) Front end tool
  • (B) Back end tool
  • (C) Database engine
  • (D) SQL Server
💬 Discuss
✅ Correct Answer: (A) Front end tool

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

Q. What is support by SQL server 2005?

  • (A) Client application
  • (B) Clients listen
  • (C) Clients written
  • (D) None of these
💬 Discuss
✅ Correct Answer: (A) Client application

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

Q. How many types of data are in SQL server are supported

  • (A) One type
  • (B) Two type
  • (C) Three type
  • (D) Six type
💬 Discuss
✅ Correct Answer: (B) Two type

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

Q. In different types of database, which work, is done?

  • (A) Storage
  • (B) Deletion
  • (C) Insertion
  • (D) None of these
💬 Discuss
✅ Correct Answer: (A) Storage

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

Q. Master database is

  • (A) Delete all the system-level information.
  • (B) lter all the system-level information.
  • (C) Records all the system-level information.
  • (D) All of the above.
💬 Discuss
✅ Correct Answer: (C) Records all the system-level information.

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

Q. MSDB database is

  • (A) Agents for scheduling alerts
  • (B) Agents for scheduling jobs.
  • (C) Both A and B
  • (D) None of these.
💬 Discuss
✅ Correct Answer: (C) Both A and B

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

Q. Model database is

  • (A) Mother for all database
  • (B) Unique for all database
  • (C) Template for all database
  • (D) None of these.
💬 Discuss
✅ Correct Answer: (C) Template for all database

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

Q. Resource database is

  • (A) Write the only database
  • (B) Read-only database
  • (C) Both A and B
  • (D) None of these.
💬 Discuss
✅ Correct Answer: (B) Read-only database

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