Question 1

To back up a database using MySQL Administrator, use the ____________________ section.

Accepted Answer

The answer of To back up a database using MySQL...

Question 2

In the MySQL Query Browser, the ____________________ provides another way to create and edit scripts.

Accepted Answer

The answer of In the MySQL Query Browser, the ____________________...

Question 3

The Catalogs section of MySQL Administrator includes a Maintenance dialog box that allows you to optimize tables, check tables, and repair tables.

Accepted Answer

A) True 
 B)False

Question 4

Use the ____ command to import a text file into MySQL.

Accepted Answer

A) IMPORT FILE 
B) IMPORT DATA FILE 
C) LOAD DATA INFILE 
D) LOAD TEXT FILE 
A) IMPORT FILE 
B) IMPORT DATA FILE 
C) LOAD DATA INFILE 
D) LOAD TEXT FILE

Question 5

A(n)____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.

Accepted Answer

A) algorithm 
B) tuner 
C) optimizer 
D) trigger 
A) algorithm 
B) tuner 
C) optimizer 
D) trigger

Question 6

The addition of indexes to a database can speed up retrieval yet at the same time slow down the rate at which data is updated.

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ Browser provides parameters that can help you build queries.

Accepted Answer

The answer of The ____________________ Browser provides parameters that can...

Question 8

When you import data into a MySQL database, you either can append data to an existing table or import data into a new table.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ Browser is a quick reference to the built-in functions available in MySQL.

Accepted Answer

The answer of The ____________________ Browser is a quick reference...

Question 10

The values in the Msg_type and Msg_txt columns are the same for both the ANALYZE TABLE and OPTIMIZE TABLE commands.

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ Browser provides a quick reference to MySQL query syntax.

Accepted Answer

The answer of The ____________________ Browser provides a quick reference...

Question 12

It is very unusual for data stored in a database to originate from other sources.

Accepted Answer

A) True 
 B)False

Question 13

The EXPLAIN command generates one row of output for each table involved in a query.

Accepted Answer

A) True 
 B)False

Question 14

The PROCEDURE ANALYSE()function is placed at the beginning of a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 15

The ____ command analyzes the data in a table and creates statistics that the MySQL optimizer uses.

Accepted Answer

A) CHECK TABLE 
B) ANALYZE TABLE 
C) SHOW TABLE 
D) FIND TABLE 
A) CHECK TABLE 
B) ANALYZE TABLE 
C) SHOW TABLE 
D) FIND TABLE

Question 16

A(n)____________________ file contains unformatted data.

Accepted Answer

The answer of A(n)____________________ file contains unformatted data....

Question 17

The ____________________ is a separate MySQL program that you can use to create and execute queries using a graphical user interface.

Accepted Answer

The answer of The ____________________ is a separate MySQL program...

Question 18

The ____________________ section of MySQL Administrator allows you to view catalogs, databases, and tables.

Accepted Answer

The answer of The ____________________ section of MySQL Administrator allows...

Question 19

Database administrators perform many of the tasks associated with query optimization.

Accepted Answer

A) True 
 B)False

Question 20

You can use the Database Browser to drop tables and databases.

Accepted Answer

A) True 
 B)False

To back up a database using MySQL Administrator, use the ____________________ section.

In the MySQL Query Browser, the ____________________ provides another way to create and edit scripts.

The Catalogs section of MySQL Administrator includes a Maintenance dialog box that allows you to optimize tables, check tables, and repair tables.

Use the ____ command to import a text file into MySQL.

A(n)____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.

The addition of indexes to a database can speed up retrieval yet at the same time slow down the rate at which data is updated.

The ____________________ Browser provides parameters that can help you build queries.

When you import data into a MySQL database, you either can append data to an existing table or import data into a new table.

The ____________________ Browser is a quick reference to the built-in functions available in MySQL.

The values in the Msg_type and Msg_txt columns are the same for both the ANALYZE TABLE and OPTIMIZE TABLE commands.

The ____________________ Browser provides a quick reference to MySQL query syntax.

It is very unusual for data stored in a database to originate from other sources.

The EXPLAIN command generates one row of output for each table involved in a query.

The PROCEDURE ANALYSE()function is placed at the beginning of a SELECT statement.

The ____ command analyzes the data in a table and creates statistics that the MySQL optimizer uses.

A(n)____________________ file contains unformatted data.

The ____________________ is a separate MySQL program that you can use to create and execute queries using a graphical user interface.

The ____________________ section of MySQL Administrator allows you to view catalogs, databases, and tables.

Database administrators perform many of the tasks associated with query optimization.

You can use the Database Browser to drop tables and databases.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

Filters

Exam 8: MySQL Special Topics

To back up a database using MySQL Administrator, use the ____________________ section.

In the MySQL Query Browser, the ____________________ provides another way to create and edit scripts.

The Catalogs section of MySQL Administrator includes a Maintenance dialog box that allows you to optimize tables, check tables, and repair tables.

Use the ____ command to import a text file into MySQL.

A(n)____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.

The addition of indexes to a database can speed up retrieval yet at the same time slow down the rate at which data is updated.

The ____________________ Browser provides parameters that can help you build queries.

When you import data into a MySQL database, you either can append data to an existing table or import data into a new table.

The ____________________ Browser is a quick reference to the built-in functions available in MySQL.

The values in the Msg_type and Msg_txt columns are the same for both the ANALYZE TABLE and OPTIMIZE TABLE commands.

The ____________________ Browser provides a quick reference to MySQL query syntax.

It is very unusual for data stored in a database to originate from other sources.

The EXPLAIN command generates one row of output for each table involved in a query.

The PROCEDURE ANALYSE()function is placed at the beginning of a SELECT statement.

The ____ command analyzes the data in a table and creates statistics that the MySQL optimizer uses.

A(n)____________________ file contains unformatted data.

The ____________________ is a separate MySQL program that you can use to create and execute queries using a graphical user interface.

The ____________________ section of MySQL Administrator allows you to view catalogs, databases, and tables.

Database administrators perform many of the tasks associated with query optimization.

You can use the Database Browser to drop tables and databases.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

Filters