Loading...

SQL Server

Which of the followig is large object data type ?
  1. varchar(max)
  2. varbinary(max)
  3. nvarchar(max)
  4. image
Data types in SQL Server are organized into how many categories ?
  1. 6
  2. 8
  3. 9
  4. 10
Exact Numeric data type is ___________
  1. bigint
  2. int
  3. smallmoney
  4. all of the mentioned
ntext datatype falls under which category ?
  1. Exact numerics
  2. Character strings
  3. Unicode character strings
  4. None of the mentioned
A column of type __________ may contain rows of different data types.
  1. ntext
  2. date
  3. smallmoney
  4. sql_variant
You want to track date and time of the last write access per row ?
  1. Add TIMESTAMP column to the table
  2. Add a DATETIME column to the table and assign getdate() as the default value
  3. Add a DATETIME column to the table and write a trigger that sets its value
  4. Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions
________ is a spatial data type.
  1. geometry
  2. sql_variant
  3. cursor
  4. all of the mentioned
Which of the the following data type is not present in SQL Server ?
  1. bit
  2. boolean
  3. hierarchyid
  4. geography
______________ is monetary data type in SQL Server.
  1. Smallmoney
  2. sql_variant
  3. Cursor
  4. None of the Mentioned
Which of the datatype has storage size of 8 bytes ?
  1. timestamp
  2. uniqueidentifier
  3. real
  4. smallmoney