Chapter 8 Study Questions

Question 1

A column’s ____ ____ specifies the kind of information the column is intended to store; and it determines the operations that can be performed on the column.

Answer 1

data type

Question 2

_________ ____ _____ are intended for storing a string of one or more characters, which can include letters, numbers, symbols, or special characters.

Answer 2

Character data types

Question 3

The _______ ____ _____ are intended for storing numbers that can be used for mathematical calculations.

Answer 3

numeric data types

Question 4

________ are numbers that do not have a decimal point.

Answer 4

Integers

Question 5

____ _______ are numbers that have a decimal point.

Answer 5

Real numbers

Question 6

____ ___ ____ ____ _____ are intended for storing dates, times or both dates and times.

Answer 6

Date and time data types

Question 7

_____ ______ ____ _____ (___) are useful for storing images, sound, video, and large amounts of character data.

Answer 7

Large Object data types (LOB)

Question 8

MySQL provides _______ ____ _____ that are useful for storing geometric and geographical values such as GPS data.

Answer 8

spatial data types

Question 9

Use the CHAR type to store _____-______ ______. Data of this type always occupy the same number of bytes.

Answer 9

fixed-length strings

Question 10

Use the _______ type to store variable-length strings. Data of this type occupies only the number of bytes needed to store the string in an extra byte to store the length of the string.

Answer 10

VARCHAR

Question 11

If the ________ attribute for an integer is set, it prevents negative values from being stored in a column. And the range of acceptable positive values is doubled.

Answer 11

UNSIGNED

Question 12

If the ________ attribute for an integer is set, the UNSIGNED attribute is automatically set, and the integer is displayed with zeros padded from the left up to the maximum display size.

Answer 12

ZEROFILL

Question 13

It is common programming practice to use ___ as an abbreviation for INTEGER.

Answer 13

INT

Question 14

The ____ ___ _______ types are synonyms for TINYINT(1). You can use these types to store 0 or FALSE for false values, and 1 or TRUE for true values.

Answer 14

BOOL and BOOLEAN

Question 15

____ _______ can include digits to the right of the decimal point.

Answer 15

Real numbers

Question 16

The __________ of a real number indicates the total number of digits that can be stored, and the _____ indicates the number of digits that can be stored to the right of the decimal point.

Answer 16

precision, scale

Question 17

The DECIMAL type is considered an _____ ________ ____ because its precision is exact.

Answer 17

exact numeric type

Question 18

The DOUBLE and FLOAT types store ________-_____ _______ which have a limited number of significant digits. These types are considered ___________ _______ ____ _____ because they do not represent a value exactly.

Answer 18

floating-point numbers, approximate numeric data types

Question 19

If the ________ attribute for a real number is set, the number is displayed with zeros padded from the left, and the UNSIGNED attribute is automatically set.

Answer 19

ZEROFILL

Question 20

The ____ type can be used to store a date without a time.

Answer 20

DATE

Question 21

Use the ________ type, rather than TIMESTAMP, to store both a date and a time (and also avoid the year 2038 problem)

Answer 21

DATETIME

Question 22

To store a year without any other temporal data, use the ____ type.

Answer 22

YEAR

Question 23

The ____ type, considered a character type, can store exactly one value; where as the ___ type can take on zero, one, or up to 64 different values. Values for these types are defined when the table is created.

Answer 23

ENUM, SET

Question 24

The _________ types store strings of binary data (255 to 4GB in length)

Answer 24

BLOB

Question 25

____ types store strings of characters up to 65KB in length and are sometimes referred to as “character large object types”.

Answer 25

TEXT

Question 26

When SQL automatically converts one data type to another, it is known as _________ __________. For example, when adding or subtracting an integer to a DATE value.

Answer 26

implicit conversion

Question 27

To control how a conversion is performed, code an _________ ___________ using the CAST and CONVERT functions

Answer 27

explicit conversion