2.5f

What are the ranges for signed and unsigned TINYINT data types?

Signed range: -128 to 127; Unsigned range: 0 to 255.

What distinguishes a signed number from an unsigned number?

Signed numbers may be negative, while unsigned numbers cannot be negative.

How many bytes does a SMALLINT use, and what are its signed and unsigned ranges?

SMALLINT uses 2 bytes; Signed range: -32,768 to 32,767; Unsigned range: 0 to 65,535.

What is the storage size of an INTEGER or INT data type?

INTEGER or INT uses 4 bytes.

What is the signed range for BIGINT?

Signed range: -2,147,483,648 to 2,147,483,647.

What format does date and time follow?

Format: YYYY-MM-DD hh:mm:ss with a range from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

Define DECIMAL(M,D).

Exact decimal number where M = number of significant digits and D = number of digits after the decimal point.

What is the storage size for DOUBLE?

DOUBLE uses 8 bytes.

Describe the character data type CHAR(N).

CHAR(N) is a fixed-length string of length N, where 0 ≤ N ≤ 255.

What storage size does VARCHAR(N) use?

VARCHAR(N) is variable-length string with a maximum of N characters, using length of characters + 1 bytes.

What data type is used to represent approximate decimal numbers?

FLOAT is used to represent approximate decimal numbers.

What are the signed ranges for MEDIUMINT?

Signed range for MEDIUMINT is -8,388,608 to 8,388,607.

What data type uses 3 bytes and has a format 'hh:mm:ss'?

TIME data type.

What type of data does JSON and XML represent?

Both JSON and XML are used to contain textual data in a structured format.

What is the approximate range for FLOAT data type?

Approximate range for FLOAT is -3.4E+38 to 3.4E+38.