gs gs116 Laying the Foundation - Data Types in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Laying the Foundation. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following is a large object data type?
varchar(max)
varbinary(max)
nvarchar(max)
image
Question 3: Exact Numeric data type is ___________
bigint
int
smallmoney
all of the mentioned
Question 4: ntext data type falls under which category?
Exact numerics
Character strings
Unicode character strings
None of the mentioned
Question 5: A column of type __________ may contain rows of different data types.
ntext
date
smallmoney
sql_variant
Question 6: 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
Question 7: _________ is a spatial data type.
geometry
sql_variant
cursor
all of the mentioned
Question 8: Which of the following data type is not present in SQL Server?
bit
boolean
hierarchyid
geography
Question 9: ______________ is monetary data type in SQL Server.
Smallmoney
sql_variant
Cursor
None of the Mentioned
Question 10: Which of the data type has a storage size of 8 bytes?
timestamp
uniqueidentifier
real
smallmoney
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
