SQL Server MCQs with answers Page - 15

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. Three-tier architecture include.

  • (A) Server client & middle tier
  • (B) Server middle tier
  • (C) Client middle tier
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (A) Server client & middle tier

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

Q. SQL server 2005 supports fields line

  • (A) Varchar
  • (B) Navarchar
  • (C) Varbinary fields
  • (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:31 pm in SQL Server

Q. Exact Numeric data type is ___________

  • (A) bigint
  • (B) int
  • (C) smallmoney
  • (D) all of the mentioned
💬 Discuss
✅ Correct Answer: (D) all of the mentioned

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

Q. ntext data type falls under which category?

  • (A) Exact numerics
  • (B) Character strings
  • (C) Unicode character strings
  • (D) None of the mentioned
💬 Discuss
✅ Correct Answer: (C) Unicode character strings

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

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

  • (A) Add TIMESTAMP column to the table
  • (B) Add a DATETIME column to the table and assign getdate() as the default value
  • (C) Add a DATETIME column to the table and write a trigger that sets its value
  • (D) Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions
💬 Discuss
✅ Correct Answer: (A) Add TIMESTAMP column to the table

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

Q. ________ is a spatial data type.

  • (A) geometry
  • (B) sql_variant
  • (C) cursor
  • (D) all of the mentioned
💬 Discuss
✅ Correct Answer: (B) sql_variant

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

Q. _____________ is monetary data type in SQL Server.

  • (A) Smallmoney
  • (B) sql_variant
  • (C) Cursor
  • (D) None of the Mentioned
💬 Discuss
✅ Correct Answer: (A) Smallmoney

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

Q. Which of the data type has a storage size of 8 bytes?

  • (A) timestamp
  • (B) uniqueidentifier
  • (C) real
  • (D) smallmoney
💬 Discuss
✅ Correct Answer: (A) timestamp

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

Q. ______________ function returns current date and time.

  • (A) SET DATEFIRST
  • (B) SYSDATETIME
  • (C) Cert_ID
  • (D) GETDATE
💬 Discuss
✅ Correct Answer: (D) GETDATE

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

Q. Which of the following function checks whether the expression is a valid date or not?

  • (A) ISDATE
  • (B) ISDAY
  • (C) ISVALID
  • (D) ISYEAR
💬 Discuss
✅ Correct Answer: (A) ISDATE

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