SQL Server MCQs with answers Page - 17

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 the following is not a conversion function?

  • (A) CAST and CONVERT
  • (B) PARSE
  • (C) TRY_CAST
  • (D) TRY_CASE
💬 Discuss
✅ Correct Answer: (D) TRY_CASE

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

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
💬 Discuss
✅ Correct Answer: (C) DENSE_RANK

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

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

  • (A) 4
  • (B) 5
  • (C) 6
  • (D) 7
💬 Discuss
✅ Correct Answer: (A) 4

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

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

  • (A) DELETE
  • (B) REMOVE
  • (C) DROP
  • (D) CLEAR
💬 Discuss
✅ Correct Answer: (A) DELETE

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

Q. With SQL, how can you return the number of not null records in the “Persons” table?

  • (A) SELECT COUNT(*) FROM Persons
  • (B) SELECT COLUMNS(*) FROM Persons
  • (C) SELECT COLUMNS() FROM Persons
  • (D) SELECT COUNT() FROM Persons
💬 Discuss
✅ Correct Answer: (D) SELECT COUNT() FROM Persons

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

Q. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

  • (A) SELECT * FROM Persons ORDER BY FirstName DESC
  • (B) SELECT * FROM Persons SORT ‘FirstName’ DESC
  • (C) SELECT * FROM Persons ORDER FirstName DESC
  • (D) SELECT * FROM Persons SORT BY ‘FirstName’ DESC
💬 Discuss
✅ Correct Answer: (A) SELECT * FROM Persons ORDER BY FirstName DESC

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

Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

  • (A) SELECT * FROM Persons WHERE FirstName=’%a%’
  • (B) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
  • (C) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
  • (D) SELECT * FROM Persons WHERE FirstName=’a’
💬 Discuss
✅ Correct Answer: (B) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

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

Q. What does DML stand for?

  • (A) Data Manipulation language
  • (B) Data Mode Lane
  • (C) Data Model Language
  • (D) Different Mode Level
💬 Discuss
✅ Correct Answer: (A) Data Manipulation language

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

Q. What is the purpose of the SQL AS clause?

  • (A) The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
  • (B) The AS clause defines a search condition
  • (C) The AS clause is used with the JOIN clause only
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (A) The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column

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

Q. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

  • (A) ASC
  • (B) DESC
  • (C) There is no default value
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (A) ASC

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