Question 1

MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL,LOCAL,SESSION and TRANSACTION.

Accepted Answer

A) True 
 B)False  False

Question 2

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 
A) DECLARE 
B) BEGIN 
C) IF...THEN...ELSE...END IF 
D) REPEAT B

Question 3

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

Accepted Answer

A) / 
B) \ 
C) // 
D) \ 
A) / 
B) \ 
C) // 
D) \ C

Question 4

The SQL query data results are displayed ________.

Accepted Answer

A) in the Navigator window 
B) in a tabbed Result Grid 
C) in a Messages window 
D) in a tabbed Action Output window 
A) in the Navigator window 
B) in a tabbed Result Grid 
C) in a Messages window 
D) in a tabbed Action Output window

Question 5

The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The active 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 
A) the Set Schema command 
B) the Set Database command 
C) the Make Default Schema command 
D) the Set as Default Schema command

Question 8

Which transaction isolation level scope(s)is (are)available in MySQL?

Accepted Answer

A) LOCAL 
B) SESSION 
C) TRANSACTION 
D) Both B and C are correct 
A) LOCAL 
B) SESSION 
C) TRANSACTION 
D) Both B and C are correct

Question 9

MySQL supports BEFORE triggers.

Accepted Answer

A) True 
 B)False

Question 10

MySQL uses the term data export dump as a synonym for backup.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Which schema privilege should not be specifically assigned to a user account?

Accepted Answer

A) SELECT 
B) CREATE 
C) GRANT 
D) Both A and B are correct 
A) SELECT 
B) CREATE 
C) GRANT 
D) Both A and B are correct

Question 13

The MySQL Table Editor is accessible from the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 14

MySQL supports INSTEAD OF triggers.

Accepted Answer

A) True 
 B)False

Question 15

Which transaction isolation level option(s)is (are)available in MySQL?

Accepted Answer

A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE WRITE 
D) Both A and B are correct 
A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE WRITE 
D) Both A and B are correct

Question 16

To execute an SQL query,click the "Execute the selected portion of the script or everything,if there is no selection" button.

Accepted Answer

A) True 
 B)False

Question 17

DBMS objects are displayed ________.

Accepted Answer

A) in the Navigation Pane 
B) in the Object Browser 
C) in the tabbed database window 
D) in the tabbed document window 
A) in the Navigation Pane 
B) in the Object Browser 
C) in the tabbed database window 
D) in the tabbed document window

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The MySQL Workbench is the main utility used to implement MySQL security.

Accepted Answer

A) True 
 B)False

Question 20

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) Both A and C are correct 
A) Disable AUTO_INCREMENT 
B) Temporarily remove AUTO_INCREMENT 
C) Use the AUTO_INCREMENT_INSERT command 
D) Both A and C are correct

Exam 12: Managing Databases With Mysql 5.6

MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL,LOCAL,SESSION and TRANSACTION.

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

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

The SQL query data results are displayed ________.

The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user.

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

The active MySQL database is specified using ________.

Which transaction isolation level scope(s)is (are)available in MySQL?

MySQL supports BEFORE triggers.

MySQL uses the term data export dump as a synonym for backup.

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

Which schema privilege should not be specifically assigned to a user account?

The MySQL Table Editor is accessible from the MySQL Workbench.

MySQL supports INSTEAD OF triggers.

Which transaction isolation level option(s)is (are)available in MySQL?

To execute an SQL query,click the "Execute the selected portion of the script or everything,if there is no selection" button.

DBMS objects are displayed ________.

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

The MySQL Workbench is the main utility used to implement MySQL security.

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

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters