Question 1

Which transaction isolation level options are available in MySQL?

Accepted Answer

A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE READ 
D) A and B 
E) A,B and C 
A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE READ 
D) A and B 
E) A,B and C

Question 2

MySQL uses the MySQL CALL statement to run a stored procedure.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

To run a single SQL command in MySQL Community Edition:

Accepted Answer

A) click the Execute button in the MySQL Workbench. 
B) click the Execute SQL in Connected Server button in the MySQL Workbench. 
C) click the Execute SQL Script in Connected Server button in the MySQL Workbench. 
D) click the Execute SQL Statement in Connected Server button in the MySQL Workbench. 
E) click the Execute Current SQL Statement in Connected Server button in the MySQL Workbench. 
A) click the Execute button in the MySQL Workbench. 
B) click the Execute SQL in Connected Server button in the MySQL Workbench. 
C) click the Execute SQL Script in Connected Server button in the MySQL Workbench. 
D) click the Execute SQL Statement in Connected Server button in the MySQL Workbench. 
E) click the Execute Current SQL Statement in Connected Server button in the MySQL Workbench.

Question 5

Which transaction isolation level scopes are available in MySQL?

Accepted Answer

A) GLOBAL 
B) SESSION 
C) TRANSACTION 
D) A and B 
E) A,B and C 
A) GLOBAL 
B) SESSION 
C) TRANSACTION 
D) A and B 
E) A,B and C

Question 6

Which of the following set of MySQL authorizations can be specifically assigned to a user account?

Accepted Answer

A) Administrative roles 
B) Schema privileges 
C) Root user equivalence 
D) A and B 
E) A,B and C 
A) Administrative roles 
B) Schema privileges 
C) Root user equivalence 
D) A and B 
E) A,B and C

Question 7

What is the MySQL Command-Line Client?

Accepted Answer

The MySQL Command-Line Client is a chara

Question 8

The MySQL statement to delete a stored procedure already in the database is:

Accepted Answer

A) CREATE PROCEDURE. 
B) ALTER PROCEDURE. 
C) DROP PROCEDURE. 
D) CLOSE PROCEDURE. 
E) None of the above. 
A) CREATE PROCEDURE. 
B) ALTER PROCEDURE. 
C) DROP PROCEDURE. 
D) CLOSE PROCEDURE. 
E) None of the above.

Question 9

MySQL supports BEFORE triggers.

Accepted Answer

A) True 
 B)False

Question 10

Describe how to create and run an SQL query in MySQL Server Community Edition.

Accepted Answer

[This is actually covered in Chapter 2,b

Question 11

The MySQL statement to store a stored procedure in the database is:

Accepted Answer

A) CREATE PROCEDURE. 
B) ALTER PROCEDURE. 
C) DROP PROCEDURE. 
D) CLOSE PROCEDURE. 
E) None of the above. 
A) CREATE PROCEDURE. 
B) ALTER PROCEDURE. 
C) DROP PROCEDURE. 
D) CLOSE PROCEDURE. 
E) None of the above.

Question 12

MySQL uses the Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 13

A default MySQL database is specified using:

Accepted Answer

A) the Set Schema command. 
B) the Set Database command. 
C) the Make Default Schema command. 
D) the Set as Default Schema command. 
E) the Set Schema dialog box. 
A) the Set Schema command. 
B) the Set Database command. 
C) the Make Default Schema command. 
D) the Set as Default Schema command. 
E) the Set Schema dialog box.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

MySQL supports INSTEAD OF triggers.

Accepted Answer

A) True 
 B)False

Question 17

The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.

Accepted Answer

A) True 
 B)False

Question 18

Explain the MySQL control-of-flow statements.

Accepted Answer

The MySQL control-of-flow statements are

Question 19

MySQL is configured using the MySQL Server Instance Configuration Wizard.

Accepted Answer

A) True 
 B)False

Question 20

The MySQL END statement is used to complete the basic SQL block structure.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With MySQL 55

Which transaction isolation level options are available in MySQL?

MySQL uses the MySQL CALL statement to run a stored procedure.

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

To run a single SQL command in MySQL Community Edition:

Which transaction isolation level scopes are available in MySQL?

Which of the following set of MySQL authorizations can be specifically assigned to a user account?

What is the MySQL Command-Line Client?

The MySQL statement to delete a stored procedure already in the database is:

MySQL supports BEFORE triggers.

Describe how to create and run an SQL query in MySQL Server Community Edition.

The MySQL statement to store a stored procedure in the database is:

MySQL uses the Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

A default MySQL database is specified using:

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 supports INSTEAD OF triggers.

The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.

Explain the MySQL control-of-flow statements.

MySQL is configured using the MySQL Server Instance Configuration Wizard.

The MySQL END statement is used to complete the basic SQL block structure.

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