Question 1

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. C

Question 2

SQL query results are displayed:

Accepted Answer

A) in a tabbed Resultset window. 
B) in a tabbed Results window. 
C) in a tabbed Document window. 
D) in a tabbed Messages window. 
E) in a tabbed results window named the same as the window with the SQL code. 
A) in a tabbed Resultset window. 
B) in a tabbed Results window. 
C) in a tabbed Document window. 
D) in a tabbed Messages window. 
E) in a tabbed results window named the same as the window with the SQL code. A

Question 3

The MySQL Workbench is included in the MySQL Server Community Edition installation.

Accepted Answer

A) True 
 B)False  False

Question 4

The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The main MySQL GUI utility is:

Accepted Answer

A) MySQL Management Studio. 
B) MySQL Developer. 
C) My SQL Workbench. 
D) A and B 
E) A,B and C 
A) MySQL Management Studio. 
B) MySQL Developer. 
C) My SQL Workbench. 
D) A and B 
E) A,B and C

Question 7

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

Question 8

What is MySQL?

Accepted Answer

MySQL is an open source database that ru

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

What MySQL utility is used for DBMS administration?

Accepted Answer

The MySQL Workbench is now the

Question 12

The MySQL Installer for Windows requires the prior installation of:

Accepted Answer

A) the .NET Framework version 2.0. 
B) the .NET Framework version 3.0. 
C) the .NET Framework version 3.5 SP1. 
D) the .NET Framework version 4.0. 
E) None of the above - the .NET Framework is not required. 
A) the .NET Framework version 2.0. 
B) the .NET Framework version 3.0. 
C) the .NET Framework version 3.5 SP1. 
D) the .NET Framework version 4.0. 
E) None of the above - the .NET Framework is not required.

Question 13

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Accepted Answer

A) True 
 B)False

Question 14

Logging into the MySQL DBMS is done using:

Accepted Answer

A) the Connect to Server command. 
B) the Connect to Server dialog box. 
C) the Connect to MySQL Server Instance command. 
D) the Connect to MySQL Server Instance dialog box. 
E) None of the above is correct. 
A) the Connect to Server command. 
B) the Connect to Server dialog box. 
C) the Connect to MySQL Server Instance command. 
D) the Connect to MySQL Server Instance dialog box. 
E) None of the above is correct.

Question 15

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 16

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

Accepted Answer

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

Question 17

The MySQL keyword to actually start using 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

The default transaction isolation level in MySQL is REPEATABLE READ.

Accepted Answer

A) True 
 B)False

Question 19

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 20

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With MySQL 55

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:

SQL query results are displayed:

The MySQL Workbench is included in the MySQL Server Community Edition installation.

The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.

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

The main MySQL GUI utility is:

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

What is MySQL?

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

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

What MySQL utility is used for DBMS administration?

The MySQL Installer for Windows requires the prior installation of:

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Logging into the MySQL DBMS is done using:

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.

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

The MySQL keyword to actually start using a cursor is:

The default transaction isolation level in MySQL is REPEATABLE READ.

The MySQL keyword to create a cursor is:

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

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