Chapter 19 Study Questions

Question 1

A(n) ___________ includes the structure and content of database.

Answer 1

full backup

Question 2

A(n) __________________ only contains changes that have been made to the structure and content of a database since the last full backup.

Answer 2

incremental backup

Question 3

A(N) ______________________ allows one to restore the data up to any point in time.

Answer 3

point-in-time recovery

Question 4

It is recommended that the database named ____ be included in backups, since this database stores information about the users and privileges for all databases on the server.

Answer 4

root

Question 5

Use the _________ program to backup one or more databases on the server.

Answer 5

mysqldump

Question 6

Use the _____ program to restore one or more databases by running the SQL script file that contains the database backup.

Answer 6

mysql

Question 7

Use the ___________ program to execute all statements in the binary log that occurred after the last full backup.

Answer 7

mysqlbinlog

Question 8

The process of backing up a database may also be referred to as _________ a database.

Answer 8

exporting

Question 9

When a database is restored from a backup, the process may be referred to as _________ a database.

Answer 9

importing

Question 10

To export data from a table to an external file, use a SELECT statement with a(n) ____________ clause.

Answer 10

into outfile

Question 11

When using a SELECT statement to export data from a table to an external file the ______ clause is used to specify delimiters for the columns.

Answer 11

fields

Question 12

The _________ statement may be used to import data from an input file into a table.

Answer 12

load data