Question 1

What is the MySQL Table Editor?

Accepted Answer

The MySQL Table Editor is a GUI administration tool used to create and manage MySQL tables.It can be opened in the MySQL Workbench,but is not accessible as a separate utility because it must operate on the default schema.It allows the user to graphically build table and database structures such as indexes.

Question 2

To create a MySQL index using SQL,the correct SQL statement is:

Accepted Answer

A) ALTER TABLE {TableName} ADD INDEX {IndexName}. 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}. 
C) CREATE INDEX {IndexName} ON TABLE {TableName}. 
D) A or C 
E) B or C 
A) ALTER TABLE {TableName} ADD INDEX {IndexName}. 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}. 
C) CREATE INDEX {IndexName} ON TABLE {TableName}. 
D) A or C 
E) B or C A

Question 3

The MySQL delimiter that must be used with MySQL procedures as used in this text is:

Accepted Answer

A) /) 
B) \) 
C) //. 
D) \. 
E) None of the above. 
A) /) 
B) \) 
C) //. 
D) \. 
E) None of the above. C

Question 4

Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

Accepted Answer

A) True 
 B)False

Question 5

The MySQL keyword used to retrieve a row of data while the cursor is operating is:

Accepted Answer

A) DECLARE CURSOR {CursorName}. 
B) OPEN {CursorName}. 
C) FETCH. 
D) CLOSE {CursorName}. 
E) None of the above. 
A) DECLARE CURSOR {CursorName}. 
B) OPEN {CursorName}. 
C) FETCH. 
D) CLOSE {CursorName}. 
E) None of the above.

Question 6

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

Accepted Answer

A) True 
 B)False

Question 7

MySQL databases are backed up using the MySQL Backup System.

Accepted Answer

A) True 
 B)False

Question 8

MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED,READ COMMITTED,REPEATABLE READ,and SERIALIZABLE.

Accepted Answer

A) True 
 B)False

Question 9

For use with this book,it is recommended that MySQL be configured as a Decision Support (DSS)/OLAP machine.

Accepted Answer

A) True 
 B)False

Question 10

Which trigger type(s)does MySQL support?

Accepted Answer

A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) A and B 
E) A,B,and C 
A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) A and B 
E) A,B,and C

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The MySQL IF statement is used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test.

Accepted Answer

A) True 
 B)False

Question 14

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 15

The MySQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test 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 16

Explain the MySQL Block Structure.

Accepted Answer

The MySQL block structure is:
DELIMITER

Question 17

The MySQL keyword to create a cursor is:

Accepted Answer

A) DECLARE CURSOR {CursorName}. 
B) OPEN {CursorName}. 
C) FETCH. 
D) CLOSE {CursorName}. 
E) None of the above. 
A) DECLARE CURSOR {CursorName}. 
B) OPEN {CursorName}. 
C) FETCH. 
D) CLOSE {CursorName}. 
E) None of the above.

Question 18

Explain the MySQL cursor statements.

Accepted Answer

The MySQL cursor statements include DECL

Question 19

MySQL Workbench is the MySQL GUI application development utility.

Accepted Answer

A) True 
 B)False

Question 20

Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Exam 10: C: Managing Databases With MySQL

What is the MySQL Table Editor?

To create a MySQL index using SQL,the correct SQL statement is:

The MySQL delimiter that must be used with MySQL procedures as used in this text is:

Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

The MySQL keyword used to retrieve a row of data while the cursor is operating is:

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

MySQL databases are backed up using the MySQL Backup System.

MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED,READ COMMITTED,REPEATABLE READ,and SERIALIZABLE.

For use with this book,it is recommended that MySQL be configured as a Decision Support (DSS)/OLAP machine.

Which trigger type(s)does MySQL support?

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

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

The MySQL IF statement is used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test.

MySQL indexes can be created by using:

The MySQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is:

Explain the MySQL Block Structure.

The MySQL keyword to create a cursor is:

Explain the MySQL cursor statements.

MySQL Workbench is the MySQL GUI application development utility.

Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters