COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
int
|
|
|
Varchar
|
|
|
Image
|
|
|
blob
|
Detailed explanation-1: -Explanation: SQL Server doesn’t have a Boolean data type, at least not by that name.
Detailed explanation-2: -The IMAGE data type in SQL Server has been used to store the image files. Recently, Microsoft began suggesting using VARBINARY(MAX) instead of IMAGE for storing a large amount of data in a single column since IMAGE will be retired in a future version of MS SQL Server.
Detailed explanation-3: -IMAGE is a variable-length data type that can store binary data. IMAGE can hold up to 2GB of data.
Detailed explanation-4: -SQL data types can be broadly divided into the following categories. Numeric data types such as: INT, TINYINT, BIGINT, FLOAT, REAL, etc. Date and Time data types such as: DATE, TIME, DATETIME, etc. Character and String data types such as: CHAR, VARCHAR, TEXT, etc.
Detailed explanation-5: -An image is a composite data type. An image file is typically a binary format file.