Deck 8: MySQL Special Topics

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

To improve database performance, most DBMSs use replication.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

Hardware constraints do not impose physical constraints on database performance.

Question 16

The filename in a LOAD DATA INFILE is case sensitive.

Question 17

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

Question 18

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

Question 19

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

Question 20

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.

Question 21

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

Question 22

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

A)Data optimization
B)Database performance
C)Database tuning
D)Data analysis

Question 23

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

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

Question 24

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

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

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

Question 31

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

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

Question 32

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

Question 33

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

Question 34

The ____ command fixes damaged or corrupted tables.

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

Question 35

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

Question 36

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

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

Question 37

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

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

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

Question 44

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

Question 45

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

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

Question 46

The ____________________ function examines and analyzes query results.

Question 47

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

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

Question 48

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)OBJECT
B)LEGAL
C)EXPLICIT
D)ENUM

Question 49

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

A)dataset
B)schema
C)tableset
D)datatable

Question 50

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

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

Question 51

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

A)Bookmarks
B)Information
C)Save
D)Params

Question 52

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

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

Question 53

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

A)Replication
B)Concurrency
C)Distribution
D)Redundancy

Question 54

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

A)HTML
B)CSV
C)RTF
D)XML

Question 55

A(n)____________________ file contains unformatted data.

Question 56

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

Question 57

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

Question 58

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

A)Health
B)Server Information
C)Service Control
D)Server Logs

Question 59

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

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

Question 60

The ____________________ command recovers unused space caused by fragmented files.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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