CSCI 340 Test Questions and Answers Verified 100%
Correct
datatype - ✔✔A column's _________ specifies the kind of information the column is intended
store; and it determines the operations that can be performed on the column.
character datatype - ✔✔__________ are intended for storing a string of one or more
characters, which can include letters, numbers, symbols, or special characters.
numerical datatype - ✔✔The __________ are intended for storing numbers that can be used for
l mathematical calculations.
integers - ✔✔__________ are numbers that do not have a decimal point.
real numbers - ✔✔__________ are numbers that have a decimal point.
date and time datatypes - ✔✔__________ are intended for storing dates, times, or both dates
and times.
large object datatypes - ✔✔__________ are useful for storing images, sound, video, and large
amounts of character data.
spatial datatypes - ✔✔MySQL provides _________ that are useful for storing geometric and
geographical values such as GPS data.
fixed length strings - ✔✔Use the CHAR type to store _________. Data of this type always occupy
the same number of bytes.
Correct
datatype - ✔✔A column's _________ specifies the kind of information the column is intended
store; and it determines the operations that can be performed on the column.
character datatype - ✔✔__________ are intended for storing a string of one or more
characters, which can include letters, numbers, symbols, or special characters.
numerical datatype - ✔✔The __________ are intended for storing numbers that can be used for
l mathematical calculations.
integers - ✔✔__________ are numbers that do not have a decimal point.
real numbers - ✔✔__________ are numbers that have a decimal point.
date and time datatypes - ✔✔__________ are intended for storing dates, times, or both dates
and times.
large object datatypes - ✔✔__________ are useful for storing images, sound, video, and large
amounts of character data.
spatial datatypes - ✔✔MySQL provides _________ that are useful for storing geometric and
geographical values such as GPS data.
fixed length strings - ✔✔Use the CHAR type to store _________. Data of this type always occupy
the same number of bytes.