Question 1

The process of returning a database to its correct state after data has been damaged or destroyed is called ____________________.

Accepted Answer

The answer of The process of returning a database to...

Question 2

The ____________________ Browser lists all queries that make up a single transaction.

Accepted Answer

The answer of The ____________________ Browser lists all queries that...

Question 3

Hardware constraints do not impose physical constraints on database performance.

Accepted Answer

A) True 
 B)False

Question 4

In MySQL Administrator, you can perform table maintenance using the ____ section.

Accepted Answer

A) User Administration 
B) Health 
C) Catalogs 
D) Service Control 
A) User Administration 
B) Health 
C) Catalogs 
D) Service Control

Question 5

The REPAIR TABLE command recovers unused space caused by fragmented files.

Accepted Answer

A) True 
 B)False

Question 6

____________________ files are text files that are used for creating and formatting web pages.

Accepted Answer

The answer of ____________________ files are text files that are...

Question 7

In the MySQL Query Browser, the MySQL ____ Editor lets you view and change the columns in a table and their data types.

Accepted Answer

A) Column 
B) Table 
C) Script 
D) Data 
A) Column 
B) Table 
C) Script 
D) Data

Question 8

The ____________________ command checks a table for errors, such as identifying corrupt tables resulting from not being closed properly.

Accepted Answer

The answer of The ____________________ command checks a table for...

Question 9

The ____ data type is an object type with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at the time the table is created.

Accepted Answer

A) OBJECT 
B) LEGAL 
C) EXPLICIT 
D) ENUM 
A) OBJECT 
B) LEGAL 
C) EXPLICIT 
D) ENUM

Question 10

A(n)_________________________ file is a text file in which values are enclosed in quotation marks and separated by commas.

Accepted Answer

comma-sepa

Question 11

The ____________________ function examines and analyzes query results.

Accepted Answer

The answer of The ____________________ function examines and analyzes query...

Question 12

The ____________________ Browser displays all databases on the MySQL server to which you are connected.

Accepted Answer

The answer of The ____________________ Browser displays all databases on...

Question 13

In MySQL Administrator, you can use the ____ section to manage user privileges.

Accepted Answer

A) Server Connections 
B) Server Information 
C) Catalogs 
D) User Administration 
A) Server Connections 
B) Server Information 
C) Catalogs 
D) User Administration

Question 14

MySQL ____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.

Accepted Answer

A) Supervisor 
B) Performer 
C) Administrator 
D) Monitor 
A) Supervisor 
B) Performer 
C) Administrator 
D) Monitor

Question 15

The EXPLAIN command examines a query statement after the query is executed.

Accepted Answer

A) True 
 B)False

Question 16

____________________ is the process of converting data to a MySQL database.

Accepted Answer

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

Question 17

The only way to get help in the MySQL Query Browser is to use the Information Browser.

Accepted Answer

A) True 
 B)False

Question 18

The SQL commands that you enter in the Query Area are identical to those that are used in the MySQL Command Line Client window.

Accepted Answer

A) True 
 B)False

Question 19

To export all columns in a table use an asterisk after the word SELECT.

Accepted Answer

A) True 
 B)False

Question 20

The Startup Variables section of MySQL Administrator is used to manage user privileges.

Accepted Answer

A) True 
 B)False

The process of returning a database to its correct state after data has been damaged or destroyed is called ____________________.

The ____________________ Browser lists all queries that make up a single transaction.

Hardware constraints do not impose physical constraints on database performance.

In MySQL Administrator, you can perform table maintenance using the ____ section.

The REPAIR TABLE command recovers unused space caused by fragmented files.

____________________ files are text files that are used for creating and formatting web pages.

In the MySQL Query Browser, the MySQL ____ Editor lets you view and change the columns in a table and their data types.

The ____________________ command checks a table for errors, such as identifying corrupt tables resulting from not being closed properly.

The ____ data type is an object type with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at the time the table is created.

A(n)_________________________ file is a text file in which values are enclosed in quotation marks and separated by commas.

The ____________________ function examines and analyzes query results.

The ____________________ Browser displays all databases on the MySQL server to which you are connected.

In MySQL Administrator, you can use the ____ section to manage user privileges.

MySQL ____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.

The EXPLAIN command examines a query statement after the query is executed.

____________________ is the process of converting data to a MySQL database.

The only way to get help in the MySQL Query Browser is to use the Information Browser.

The SQL commands that you enter in the Query Area are identical to those that are used in the MySQL Command Line Client window.

To export all columns in a table use an asterisk after the word SELECT.

The Startup Variables section of MySQL Administrator is used to manage user privileges.

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

The process of returning a database to its correct state after data has been damaged or destroyed is called ____________________.

The ____________________ Browser lists all queries that make up a single transaction.

Hardware constraints do not impose physical constraints on database performance.

In MySQL Administrator, you can perform table maintenance using the ____ section.

The REPAIR TABLE command recovers unused space caused by fragmented files.

____________________ files are text files that are used for creating and formatting web pages.

In the MySQL Query Browser, the MySQL ____ Editor lets you view and change the columns in a table and their data types.

The ____________________ command checks a table for errors, such as identifying corrupt tables resulting from not being closed properly.

The ____ data type is an object type with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at the time the table is created.

A(n)_________________________ file is a text file in which values are enclosed in quotation marks and separated by commas.

The ____________________ function examines and analyzes query results.

The ____________________ Browser displays all databases on the MySQL server to which you are connected.

In MySQL Administrator, you can use the ____ section to manage user privileges.

MySQL ____ is a tool for performing administrative operations, such as monitoring the status and performance of MySQL.

The EXPLAIN command examines a query statement after the query is executed.

____________________ is the process of converting data to a MySQL database.

The only way to get help in the MySQL Query Browser is to use the Information Browser.

The SQL commands that you enter in the Query Area are identical to those that are used in the MySQL Command Line Client window.

To export all columns in a table use an asterisk after the word SELECT.

The Startup Variables section of MySQL Administrator is used to manage user privileges.

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