Numeric Data Types

Question 1

BIT(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 1

A bit-value type.
specified insize.
value from 1 to 64.
default value forsizeis 1.

Question 2

TINYINT(size)

Answer 2

very small integer
signed range -128 to 127
unsigned range 0 to 255
parameter is max display width 255

Question 3

BOOL

Answer 3

0 is considered as false

nonzero is considered as true

Question 4

BOOLEAN

Answer 4

Equal to BOOL

Question 5

SMALLINT(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 5

small integer
signed range -32768 to 32767
unsigned range 0 - 65535
parameter is max display width 255

Question 6

MEDIUMINT(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 6

Medium integer
signed range -8388608 to 8388607
unsigned range 0 to 16777215
parameter is max display width 255

Question 7

INT(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 7

medium integer
Signed range -2147483648 to 2147483647
unsigned range 0 to 4294967295
parameter is max display width 255

Question 8

INTEGER(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 8

equal to INT
medium integer
Signed range   -2147483648 to 2147483647
unsigned range 0 to 4294967295
parameter is max display width 255

Question 9

BIGINT(size)
Type?
bits per value?
Size Parameter?
Default?

Answer 9

Large integer
signed range from -9223372036854775808 to 9223372036854775807
unsigned range 0 to 18446744073709551615
parameter is max display width 255

Question 10

FLOAT(size,d)
Type?
bits per value?
Size Parameter?
Default?

Answer 10

Floating point number
total digits specified in size
number of digits after the decimal is specified in the d parameter
being decommissions from SQL

Question 11

DOUBLES(size,d)
Type?
bits per value?
Size Parameter?
Default?

Answer 11

normal size floating point
total digits specified in size
number of digits after decimal place in the D parameter

Question 12

DECIMAL(size,d)
Type?
bits per value?
Size Parameter?
Default?

Answer 12

exact fixed point number
total digits specified in size
number of digits after decimal specified in D parameter
Max size is 65
Max number for D is 30
Default value for size is 10 default value for D is 0

Question 13

DEC(size,d)
Type?
bits per value?
Size Parameter?
Default?

Answer 13

equal to decimal
exact fixed point number
total digits specified in size
number of digits after decimal specified in D parameter
Max size is 65
Max number for D is 30
Default value for size is 10 default value for D is 0

Question 14

FLOAT(p)

Answer 14

floating point number
SQL uses the P value to determin wether to use FLOAT or DOUBLE for the resulting data type
If p is from 0 to 24 FLOAT is used
If p is from 25 to 53 DOUBLE is used