Exam 8: MySQL Special Topics

The commands in the Syntax Browser are organized into five categories: Data Manipulation, Data Definition, MySQL Utility, Transaction and Locking, and Data Privileges.

To display query output vertically, include the \V command in the query.

The ____________________ command recovers unused space caused by fragmented files.

____ is defined as the speed or rate with which the DBMS supplies information to the user.

In the MySQL Query Browser, the database currently in use is referred to as the active database.

With the MySQL Query Browser, you can export a resultset to Microsoft Excel file format.

The name of the text file that follows the words INTO OUTFILE must be enclosed in double quotation marks.

____ is the process of making multiple copies of the database.

What is the difference between the EXPLAIN command and the PROCEDURE ANALYSE()function?

In the Query Browser, you can resize columns to produce more readable output.

In MySQL Administrator, you can use the ____ section to monitor database performance.

In the MySQL Query Browser, the ____ Browser allows you to save queries that you use frequently.

In the MySQL Query Browser, query results appear in the ____________________ on tabbed pages.

To improve database performance, most DBMSs use replication.

You can use the Query Browser to edit tables and create and run scripts.

Explain why it is necessary to have procedures in place to back up and restore a database.

The MySQL Query Browser is a built-in MySQL program.

____ is a data interchange format that allows you to exchange data between dissimilar systems or applications.

When you import a text file that contains blank lines, MySQL inserts a blank row at the end of the table.

In the MySQL Query Browser, a database is referenced as a(n)____.