Question 1

____________________ is the process of converting the data in a MySQL database to a file format for use in another program.

Accepted Answer

The answer of ____________________ is the process of converting the...

Question 2

To import a text file into MySQL, the file must be located in the default folder for the database.

Accepted Answer

A) True 
 B)False

Question 3

Identify three ways to ensure that table designs are as efficient as possible.

Accepted Answer

To ensure that table designs a

Question 4

In the MySQL Query Browser, the ____ Browser lets you browse all the previously created queries during your session.

Accepted Answer

A) Bookmarks 
B) Object 
C) Information 
D) History 
A) Bookmarks 
B) Object 
C) Information 
D) History

Question 5

When you use the Query Browser to create a query, you must enter a semi-colon at the end of the command.

Accepted Answer

A) True 
 B)False

Question 6

To import a text file into MySQL, the text file must be ____ and the data should not be enclosed in quotation marks.

Accepted Answer

A) tab-delimited 
B) comma-delimited 
C) slash-delimited 
D) hyphen-delimited 
A) tab-delimited 
B) comma-delimited 
C) slash-delimited 
D) hyphen-delimited

Question 7

When you use the MySQL Query Browser, you do not need to run a query to export a table.

Accepted Answer

A) True 
 B)False

Question 8

In the MySQL Query Browser, the ____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.

Accepted Answer

A) Information 
B) Object 
C) Help 
D) Page 
A) Information 
B) Object 
C) Help 
D) Page

Question 9

The filename in a LOAD DATA INFILE is case sensitive.

Accepted Answer

A) True 
 B)False

Question 10

A text file might contain line breaks, commas, or tabs to distinguish one piece of data from another.

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ command examines a query statement before it is executed.

Accepted Answer

The answer of The ____________________ command examines a query statement...

Question 12

The Information Browser provides access to all information not directly related to actual data in the database.

Accepted Answer

A) True 
 B)False

Question 13

The ____ command fixes damaged or corrupted tables.

Accepted Answer

A) FIX TABLE 
B) ALTER TABLE 
C) REPAIR TABLE 
D) RESTORE TABLE 
A) FIX TABLE 
B) ALTER TABLE 
C) REPAIR TABLE 
D) RESTORE TABLE

Question 14

Use the ____ command to export a MySQL table to a text file.

Accepted Answer

A) EXPORT TABLE 
B) SELECT INTO OUTFILE 
C) OUTPUT TEXT FILE 
D) CREATE OUTFILE 
A) EXPORT TABLE 
B) SELECT INTO OUTFILE 
C) OUTPUT TEXT FILE 
D) CREATE OUTFILE

Question 15

Before you can import data into a new table, you must use the ____ command to create the new table.

Accepted Answer

A) NEW TABLE 
B) ADD TABLE 
C) ALTER TABLE 
D) CREATE TABLE 
A) NEW TABLE 
B) ADD TABLE 
C) ALTER TABLE 
D) CREATE TABLE

____________________ is the process of converting the data in a MySQL database to a file format for use in another program.

To import a text file into MySQL, the file must be located in the default folder for the database.

Identify three ways to ensure that table designs are as efficient as possible.

In the MySQL Query Browser, the ____ Browser lets you browse all the previously created queries during your session.

When you use the Query Browser to create a query, you must enter a semi-colon at the end of the command.

To import a text file into MySQL, the text file must be ____ and the data should not be enclosed in quotation marks.

When you use the MySQL Query Browser, you do not need to run a query to export a table.

In the MySQL Query Browser, the ____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.

The filename in a LOAD DATA INFILE is case sensitive.

A text file might contain line breaks, commas, or tabs to distinguish one piece of data from another.

The ____________________ command examines a query statement before it is executed.

The Information Browser provides access to all information not directly related to actual data in the database.

The ____ command fixes damaged or corrupted tables.

Use the ____ command to export a MySQL table to a text file.

Before you can import data into a new table, you must use the ____ command to create the new table.

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

____________________ is the process of converting the data in a MySQL database to a file format for use in another program.

To import a text file into MySQL, the file must be located in the default folder for the database.

Identify three ways to ensure that table designs are as efficient as possible.

In the MySQL Query Browser, the ____ Browser lets you browse all the previously created queries during your session.

When you use the Query Browser to create a query, you must enter a semi-colon at the end of the command.

To import a text file into MySQL, the text file must be ____ and the data should not be enclosed in quotation marks.

When you use the MySQL Query Browser, you do not need to run a query to export a table.

In the MySQL Query Browser, the ____ Browser has three tabbed pages entitled Schemata, Bookmarks, and History.

The filename in a LOAD DATA INFILE is case sensitive.

A text file might contain line breaks, commas, or tabs to distinguish one piece of data from another.

The ____________________ command examines a query statement before it is executed.

The Information Browser provides access to all information not directly related to actual data in the database.

The ____ command fixes damaged or corrupted tables.

Use the ____ command to export a MySQL table to a text file.

Before you can import data into a new table, you must use the ____ command to create the new table.

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