Question 1

MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

Accepted Answer

A) True 
 B)False

Question 2

Explain the MySQL cursor statements.

Accepted Answer

The MySQL cursor statements include DECL

Question 3

MySQL indexes can be created by using:

Accepted Answer

A) the MySQL Table Editor. 
B) the MySQL Index Editor. 
C) an SQL statement. 
D) A and C 
E) B and C 
A) the MySQL Table Editor. 
B) the MySQL Index Editor. 
C) an SQL statement. 
D) A and C 
E) B and C

Question 4

It is recommend that MySQL be used with InnoDB storage engine.

Accepted Answer

A) True 
 B)False

Question 5

MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

Accepted Answer

A) True 
 B)False

Question 6

For use with this book,it is recommend that MySQL be configured as a developer machine.

Accepted Answer

A) True 
 B)False

Question 7

MySQL backups that contain the entire database are run using the Export to Self-Contained File option.

Accepted Answer

A) True 
 B)False

Question 8

MySQL users are granted MySQL privileges for specific schemas only.

Accepted Answer

A) True 
 B)False

Question 9

To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT:

Accepted Answer

A) Disable AUTO_INCREMENT. 
B) Temporarily remove AUTO_INCREMENT. 
C) Use the AUTO_INCREMENT_INSERT command. 
D) A or C 
E) B or C 
A) Disable AUTO_INCREMENT. 
B) Temporarily remove AUTO_INCREMENT. 
C) Use the AUTO_INCREMENT_INSERT command. 
D) A or C 
E) B or C

Question 10

The MySQL statement used to define a set of MySQL procedure statements is:

Accepted Answer

A) DECLARE. 
B) BEGIN. 
C) IF...THEN...ELSE...END IF. 
D) REPEAT. 
E) END. 
A) DECLARE. 
B) BEGIN. 
C) IF...THEN...ELSE...END IF. 
D) REPEAT. 
E) END.

Question 11

The MySQL command line utility is:

Accepted Answer

A) MySQL*Plus. 
B) the MySQL Command-Line Client. 
C) MySQL-Shell. 
D) MySQL-CMD. 
E) None of the above is correct. 
A) MySQL*Plus. 
B) the MySQL Command-Line Client. 
C) MySQL-Shell. 
D) MySQL-CMD. 
E) None of the above is correct.

Question 12

The MySQL Command Line Client is the MySQL command line utility.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following MySQL configuration settings are recommend for use with this book?

Accepted Answer

A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) A and B 
E) A,B and C 
A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) A and B 
E) A,B and C

Question 14

To start working with MySQL Community Edition use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.

Accepted Answer

A) True 
 B)False

Question 15

MySQL users are created on the Users and Privileges page in the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 16

MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.

Accepted Answer

A) True 
 B)False

Question 17

What term does MySQL use as a synonym for backup?

Accepted Answer

A) Backup 
B) Export 
C) Data export 
D) Data export dump 
E) None of the above. 
A) Backup 
B) Export 
C) Data export 
D) Data export dump 
E) None of the above.

Question 18

MySQL Workbench is the MySQL GUI application development utility.

Accepted Answer

A) True 
 B)False

Question 19

MySQL users should always be given the GRANT OPTION for each schema.

Accepted Answer

A) True 
 B)False

Question 20

In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With MySQL 55

MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

Explain the MySQL cursor statements.

MySQL indexes can be created by using:

It is recommend that MySQL be used with InnoDB storage engine.

MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

For use with this book,it is recommend that MySQL be configured as a developer machine.

MySQL backups that contain the entire database are run using the Export to Self-Contained File option.

MySQL users are granted MySQL privileges for specific schemas only.

To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT:

The MySQL statement used to define a set of MySQL procedure statements is:

The MySQL command line utility is:

The MySQL Command Line Client is the MySQL command line utility.

Which of the following MySQL configuration settings are recommend for use with this book?

To start working with MySQL Community Edition use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.

MySQL users are created on the Users and Privileges page in the MySQL Workbench.

MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.

What term does MySQL use as a synonym for backup?

MySQL Workbench is the MySQL GUI application development utility.

MySQL users should always be given the GRANT OPTION for each schema.

In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters