Question 1

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 under the keyboard cursor" 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 under the keyboard cursor" button in the MySQL Workbench

Question 2

Explain the MySQL Block Structure.

Accepted Answer

The MySQL block structure is:
DELIMITER

Question 3

To run an SQL script,click the "Execute SQL Script (or selected portion)" button on the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 4

The MySQL statement to change a stored procedure already stored in the database is ________.

Accepted Answer

A) CREATE PROCEDURE 
B) ALTER PROCEDURE 
C) DROP PROCEDURE 
D) CLOSE PROCEDURE 
A) CREATE PROCEDURE 
B) ALTER PROCEDURE 
C) DROP PROCEDURE 
D) CLOSE PROCEDURE

Question 5

MySQL is an open source DBMS that only runs on Unix and Linux operating systems.

Accepted Answer

A) True 
 B)False

Question 6

When MySQL Server Administration is opened in the MySQL Workbench,the Startup/Shutdown page is initially displayed.

Accepted Answer

A) True 
 B)False

Question 7

MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row.

Accepted Answer

A) True 
 B)False

Question 8

It is recommended that MySQL be used with the InnoDB storage engine.

Accepted Answer

A) True 
 B)False

Question 9

To display an existing SQL script,click the "Open an SQL script file (in new query tab)" button.

Accepted Answer

A) True 
 B)False

Question 10

Which trigger type(s)does MySQL not support?

Accepted Answer

A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) Both A and B are correct 
A) BEFORE 
B) AFTER 
C) INSTEAD OF 
D) Both A and B are correct

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row.

Accepted Answer

A) True 
 B)False

Question 13

Explain the MySQL cursor statements.

Accepted Answer

The MySQL cursor statements include DECL

Question 14

The MySQL SQL/PSM code structure defines variables with the keyword ________.

Accepted Answer

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

Question 15

The MySQL block structure defines variables with the BEGIN keyword.

Accepted Answer

A) True 
 B)False

Question 16

What MySQL utility is used for DBMS administration?

Accepted Answer

The MySQL Workbench is now the

Question 17

Describe how to create a new database in MySQL Community Edition.

Accepted Answer

In MySQL Community Edition,new databases

Question 18

A MySQL data backup is accomplished by using the "Data Export" feature.

Accepted Answer

A) True 
 B)False

Question 19

A new MySQL database is created using the New Database dialog box.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) DECLARE 
B) BEGIN 
C) a right brace symbol } 
D) END 
A) DECLARE 
B) BEGIN 
C) a right brace symbol } 
D) END

Exam 12: Managing Databases With Mysql 5.6

To run a single SQL command in MySQL Community Edition ________.

Explain the MySQL Block Structure.

To run an SQL script,click the "Execute SQL Script (or selected portion)" button on the MySQL Workbench.

The MySQL statement to change a stored procedure already stored in the database is ________.

MySQL is an open source DBMS that only runs on Unix and Linux operating systems.

When MySQL Server Administration is opened in the MySQL Workbench,the Startup/Shutdown page is initially displayed.

MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row.

It is recommended that MySQL be used with the InnoDB storage engine.

To display an existing SQL script,click the "Open an SQL script file (in new query tab)" button.

Which trigger type(s)does MySQL not support?

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

MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row.

Explain the MySQL cursor statements.

The MySQL SQL/PSM code structure defines variables with the keyword ________.

The MySQL block structure defines variables with the BEGIN keyword.

What MySQL utility is used for DBMS administration?

Describe how to create a new database in MySQL Community Edition.

A MySQL data backup is accomplished by using the "Data Export" feature.

A new MySQL database is created using the New Database dialog box.

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

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