SQL Server MCQs with answers Page - 24

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 these refers to the computer operations’ duplication and routine backups for combating any unforeseen problems?

  • (A) Deadlock
  • (B) Recovery
  • (C) Concurrency
  • (D) Backup
💬 Discuss
✅ Correct Answer: (B) Recovery

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:02 am in SQL Server

Q. What are all the identifiers in an XQuery known as?

  • (A) QFor
  • (B) Qidt
  • (C) QName
  • (D) Name
💬 Discuss
✅ Correct Answer: (C) QName

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:02 am in SQL Server

Q. Which of these databases must be regularly backed up?

  • (A) Master
  • (B) TEMPDB
  • (C) Pub
  • (D) Adventure Works
💬 Discuss
✅ Correct Answer: (A) Master

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:02 am in SQL Server

Q. Which of these statements can we check for Errors?

  • (A) INSERT
  • (B) DELETE
  • (C) DROP
  • (D) CREATE
💬 Discuss
✅ Correct Answer: (A) INSERT

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:03 am in SQL Server

Q. The Server in SQL can be applied AFTER trigger to

  • (A) Function
  • (B) Views and Table
  • (C) Table
  • (D) Views
💬 Discuss
✅ Correct Answer: (B) Views and Table

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:03 am in SQL Server

Q. Which of these with SQL Server refers to an enumeration for ADO.net?

  • (A) SqlBulkCopyOptions
  • (B) SqlNotification
  • (C) SqlInfo
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (A) SqlBulkCopyOptions

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:03 am in SQL Server

Q. Which of these refers to a tool used for the migration of the databases from MS Access versions 97 through the 2010 one to the MS SQL Server 2005?

  • (A) SSMS
  • (B) SSAM
  • (C) SSAS
  • (D) SSMA
💬 Discuss
✅ Correct Answer: (D) SSMA

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:10 am in SQL Server

Q. Which of these commands would defragment the clustered as well as the secondary indexes of any given specified table?

  • (A) DBCC CHECKDB
  • (B) DBCC SHOWCONTIG
  • (C) DBCC INDEXDEFRAG
  • (D) DBCC CATALOG
💬 Discuss
✅ Correct Answer: (C) DBCC INDEXDEFRAG

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:10 am in SQL Server

Q. The database happens to be read-only in which of these modes?

  • (A) Restore mode
  • (B) Stand by
  • (C) Read-only
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (B) Stand by

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:10 am in SQL Server

Q. Which of the waits would occur when any worker is trying to request access to some resources that are NOT available since the resources are being used by other workers or are not available yet?

  • (A) External
  • (B) Lock
  • (C) Queue
  • (D) Resource
💬 Discuss
✅ Correct Answer: (D) Resource

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:11 am 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