Multiple Choice Questions on SQL Data Types
1. Out of the below data types which can be used for Date & time type?
a) Date
b) Datetimeoffset
c) Time
d) All
2. What is the ISO synonym for ntext data type?
a) New text
b) Next text
c) National Text
d) None of the above
3. Which data type is used to store binary data up to the limit of 2,147,483,647?
a) Image
b) Text
c) Ntext
d) None of the above
4. Which data type can be used to represent position in a hierarchy?
a. Hierarchy
b. Hierarchyid
c. Nhierarchyid
d. None of the above
5. What is the storage size of smallmoney data type?
a) 3 bytes
b) 2 bytes
c) 4 bytes
d) 8 bytes
6. What is the range of TinyInt data type in SQL Server?
a) 0-10
b) 0-255
c) -2^15 to 2^15-1
d) None of the above
7. Which data type in SQL server can be used to store time in the table?
a) Timeonly
b) OnlyTime
c) Time
d) DateTime
8. What is the ISO synonym for real data type in SQL server?
a) Float(24)
b) Float(8)
c) Float(16)
d) None of the above
9. What is the default size of n in a column which is defined as VARCHAR(n)?
a) NULL
b) 0
c) 1
d) None of the above
10. Which data type is used for assigning GUID value?
a) UNIQUE
b) UNIQUEIDENTYFIER
c) GUID
d) None of the above
Answers