SQL Server MCQs with answers Page - 16

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. SQL server supports

  • (A) Permission system
  • (B) DDL triggers, aggregates & synonyms support
  • (C) XML Indexes
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (D) All of the above

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

Q. Extended GUI feature supported by SQL server 2005 includes.

  • (A) Floating window & MDI
  • (B) Database explorer
  • (C) Powerful visual options
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (D) All of the above

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

Q. BLOB viewer /editor & master-detail view & card view all comes under.

  • (A) DML
  • (B) DDL
  • (C) Data manipulation tools
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (C) Data manipulation tools

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

Q. What is the standard form of RDBMS.

  • (A) Relational database management system
  • (B) Report database management system
  • (C) Relational data management system
  • (D) None of these
💬 Discuss
✅ Correct Answer: (A) Relational database management system

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

Q. What is used of SQL?

  • (A) Businesses for small to medium size
  • (B) Larger enterprise database
  • (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 07:40 pm in SQL Server

Q. Which of the following is not a mathematical function?

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

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

Q. @@NESTLEVEL function falls under which of the following category?

  • (A) Configuration functions
  • (B) Cursor functions
  • (C) Mathematical functions
  • (D) Date and Time Data Functions
💬 Discuss
✅ Correct Answer: (A) Configuration functions

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

Q. __________ are used for supporting encryption, decryption, digital signing and their validation.

  • (A) Cryptographic functions
  • (B) Cursor functions
  • (C) Configuration functions
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (A) Cryptographic functions

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

Q. DecryptByKeyAutoCert is ________________ type function.

  • (A) Symmetric Encryption and decryption
  • (B) Encryption Hashing
  • (C) Asymmetric Encryption and decryption
  • (D) Symmetric decryption with Automatic key handling
💬 Discuss
✅ Correct Answer: (D) Symmetric decryption with Automatic key handling

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

Q. Text and Image Functions are ___________

  • (A) nondeterministic
  • (B) deterministic
  • (C) table valued
  • (D) all of the mentioned
💬 Discuss
✅ Correct Answer: (A) nondeterministic

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