Chapter 17 Study Questions

Question 1

The __________________________ has the responsibility to design and create a database, secure the database, plus backup and restore the database.

Answer 1

database administrator (DBA)

Question 2

_________________ involves setting up multiple MySQL (database) servers, usually running on different machines, where one server is the master and the other server(s) the slave(s). This is done to synchronize databases so a change to one is automatically propagated to the others.

Answer 2

database replication

Question 3

The type of database file that contains configuration options that the MySQL server uses to set it defaults when it starts is termed ____________________.

Answer 3

configuration file

Question 4

_________ is the type of database file used to define tables, indexes, and other database objects. These files also store any data used by database objects.

Answer 4

Data file

Question 5

A(n) ________ is the type of database file that contains information written by the database server about client connections, error messages, slow(executing) queries, binary file with changes to the database, and relay files for replication.

Answer 5

Log file

Question 6

A(n) _______ is a connection to the database.

Answer 6

process

Question 7

_______________ are viewed to find additional information about the status of the (MySQL) server.

Answer 7

status variable

Question 8

A(n) ______________ is one that stores a setting for the current configuration of the (MySQL) server

Answer 8

system variable