SQL Server MCQs with answers Page - 16

Here, you will find a collection of MCQ questions on SQL Server. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

  • (A) ATN2
  • (B) POWER
  • (C) PI
  • (D) CEIL

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

Q. Text and Image Functions are ___________

  • (A) nondeterministic
  • (B) deterministic
  • (C) table valued
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

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

  • (A) CAST and CONVERT
  • (B) PARSE
  • (C) TRY_CAST
  • (D) TRY_CASE

A

Admin • 833.24K Points
Coach

Q. ______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.

  • (A) RANK
  • (B) NTILE
  • (C) DENSE_RANK
  • (D) ROW_NUMBER

A

Admin • 833.24K Points
Coach

Q. Built in Functions in SQL Server is categorized into how many categories?

  • (A) 4
  • (B) 5
  • (C) 6
  • (D) 7

A

Admin • 833.24K Points
Coach

Q. Which of the following SQL clauses is used to DELETE tuples from a database table?

  • (A) DELETE
  • (B) REMOVE
  • (C) DROP
  • (D) CLEAR

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.