Studied by 0 people
Looks like no one added any tags here yet for you.
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.
