Multiple Choice Questions - SQL Data Types
1. The table data type can't be used in CREATE TABLE as a column type.
A) True
B) False
2. With ---------, the fractions of a second can be held with greater precision.
A) datetime
B) datetime2
C) smalldatetime
D) date
3. It is not possible to create your own user data type.
A) True
B) False
4. In case of SQL Server 2005, binary data type can hold:
A) Fixed-length binary data with a maximum of 3000 bytes.
B) Fixed-length binary data with a maximum of 6000 bytes.
C) Fixed-length binary data with a maximum of 1024 bytes.
D) Fixed-length binary data with a maximum of 8000 bytes.
5. If you define a column (char data type) of 15 characters long, 15 characters will be stored. If you enter less than the number of characters defined, the remaining length will be ……….
A) space filled to the left
B) truncated
C) space filled to the right
D) None of above
6. Tinyint is a whole number from 0 through 256.
A) True
B) False
7. The maximum size of a varchar column is 8000 characters. However if you define the column with no size - i.e. varchar() - the length will default to ……..
A) 0
B) 1
C) empty
D) None of above
8. The maximum number of characters in a text data type is .......
A) 256 MB
B) 255 MB
C) 1 GB
D) 2GB
9. When a column value is not known or missing, the column's value is null.
A) True
B) False
10. ……………. and ……………… functions enable you to convert between many SQL Server data types.
A) Cast
B) Rules
C) Trigers
D) Convert()
Answers
1. The table data type can't be used in CREATE TABLE as a column type.
A) True
B) False
2. With ---------, the fractions of a second can be held with greater precision.
A) datetime
B) datetime2
C) smalldatetime
D) date
3. It is not possible to create your own user data type.
A) True
B) False
4. In case of SQL Server 2005, binary data type can hold:
A) Fixed-length binary data with a maximum of 3000 bytes.
B) Fixed-length binary data with a maximum of 6000 bytes.
C) Fixed-length binary data with a maximum of 1024 bytes.
D) Fixed-length binary data with a maximum of 8000 bytes.
5. If you define a column (char data type) of 15 characters long, 15 characters will be stored. If you enter less than the number of characters defined, the remaining length will be ……….
A) space filled to the left
B) truncated
C) space filled to the right
D) None of above
6. Tinyint is a whole number from 0 through 256.
A) True
B) False
7. The maximum size of a varchar column is 8000 characters. However if you define the column with no size - i.e. varchar() - the length will default to ……..
A) 0
B) 1
C) empty
D) None of above
8. The maximum number of characters in a text data type is .......
A) 256 MB
B) 255 MB
C) 1 GB
D) 2GB
9. When a column value is not known or missing, the column's value is null.
A) True
B) False
10. ……………. and ……………… functions enable you to convert between many SQL Server data types.
A) Cast
B) Rules
C) Trigers
D) Convert()
Answers