Data types

Question 1

SQL Datatypes (only names)

Answer 1

• Binary datatype
• Numeric datatype
• Exact numeric datatype
• String datatype
• Date Datatype

Question 2

Further classification of string datatype

Answer 2

UNI string datatype

Question 3

Binary Data Type (only names)

Answer 3

• Binary
• Varbinary
• Image

Question 4

Maximum length of Binary - binary datatype

Answer 4

8000 bytes

Question 5

Important point about binary-binary data type

Answer 5

Fixed length binary data

Question 6

Maximum length of varbinary

Answer 6

8000 bytes

Question 7

Important point about varbinary data type

Answer 7

Variable length binary data

Question 8

maximum length Image datatype

Answer 8

2,147,483,647 bytes

Question 9

Important point about image data type

Answer 9

Variable length binary data

Question 10

Another name of image data type

Answer 10

BLOB: Binary Large Objects

Question 11

Type of Numeric Data Type

Answer 11

Approximate numeric datatype
Exact numeric datatype

Question 12

Type of approximate numeric data type

Answer 12

Float
Real

Question 13

Range of Float approximate numeric data type

Answer 13

From -1.79E+308 to 1.79E+308

Question 14

Description of Float approximate numeric data type (3)

Answer 14

Used for floating point value
Double precision
32 bit space

Question 15

Range of real approximate numeric data type

Answer 15

From -3.40e+38 to 3.40e+38

Question 16

Description of Real approximate numeric data type (3)

Answer 16

Single precession floating point value
Used to represent too large number or too small number
16 bit space

Question 17

Type of Exact Numeric data type

also tell which is integer and which is fraction

also size

Answer 17

• bigint - integer (8 bytes)
• int - integer (4 bytes)
• smallint - inetegr (2 bytes)
• tinyint - integer (1 byte)
• bit - integer (1 bit)
• decimal - fractional and accurate
• numeric - fractional and accurate
• money - fractional and accurate
• smallmoney - fraction and accurate

Question 18

Difference between Decimal and floating data type

Answer 18

Decimal used to store exact and accurate number.
Floating point number can be rounded.

Question 19

Description BIGINT

Answer 19

to store large integers
represent in 2’s complement form
Extremely large whole number
used for Primary key if integer data type
More storage space required

Question 20

Description Decimal

Answer 20

Numeric data with fixed precision and scale
Allowed to specify both precision and scale
Used for exact numeric values
another name - Numeric

Question 21

Advantages of Decimal

Answer 21

Fixed precision
No rounding error
Data consistency

Question 22

Description Money

Answer 22

Used for monetary values such as currency

Question 23

type of Character string datatype

Answer 23

char
varchar
text

Question 24

maximum length of char data type

Answer 24

maximum 8000 characters

Question 25

Description char

Answer 25

fixed length non-unicode characters (ASCII) one byte per character

Question 26

Description varchar

Answer 26

variable length non-unicode characters

Question 27

Description text

Answer 27

for too large text variable length non-unicode characters

Question 28

maximum length of varchar data type

Answer 28

maximum 8000 characters

Question 29

maximum length text data type

Answer 29

maximum 2,147,483,647 characters

Question 30

Difference between varchar and text

Answer 30