Loading, please wait...

Become An Author

Microsoft SQL Server MCQ Quiz (Multiple Choice Questions And Answers)

Search here for MCQs

Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:

List of Programming Full Forms 

16. Which of the following data type is not present in SQL Server?

  • bit
  • boolean
  • hierarchyid
  • geography
View Answer

17. You want to track date and time of the last write access per row?

  • Add TIMESTAMP column to the table
  • Add a DATETIME column to the table and assign getdate() as the default value
  • Add a DATETIME column to the table and write a trigger that sets its value
  • Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions
View Answer

18. ______________ is monetary data type in SQL Server.

  • Smallmoney
  • Cursor
  • sql_variant
  • None of the Mentioned
View Answer

19. A column of type __________ may contain rows of different data types.

  • Smallmoney
  • Cursor
  • sql_variant
  • None of the Mentioned
View Answer

20.  Data types in SQL Server are organized into how many categories?

  • 6
  • 8
  • 9
  • 10
View Answer

JOIN TUTORIALS LINK

Our Newsletter Will Let You Know When Any New
Articles, Tutorials and Video Are Released.

CONTRIBUTE

Follow us

Copyright © 2024. All Rights Reserved.