Question 1

The MySQL Table Editor is accessible from the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

MySQL Community Edition requires that the .NET Framework version 2.0 be installed.

Accepted Answer

A) True 
 B)False

Question 5

To run an SQL script,click the Execute button on the Query Toolbar.

Accepted Answer

A) True 
 B)False

Question 6

The MySQL block structure defines variables with the BEGIN keyword.

Accepted Answer

A) True 
 B)False

Question 7

MySQL supports AFTER triggers.

Accepted Answer

A) True 
 B)False

Question 8

Schema is the MySQL synonym for database.

Accepted Answer

A) True 
 B)False

Question 9

The MySQL statement used to repeat a set of SQL statements as long as some condition is true 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 10

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

Accepted Answer

A) Result. 
B) Resultset. 
C) Script. 
D) Scriptset. 
E) command set. 
A) Result. 
B) Resultset. 
C) Script. 
D) Scriptset. 
E) command set.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

In MySQL Community Edition,new databases

Question 14

The MySQL GUI tool(s)used for database administration and management is(are):

Accepted Answer

A) MySQL Workbench. 
B) MySQL*Plus. 
C) MySQL Command Shell. 
D) A and B 
E) A,B and C 
A) MySQL Workbench. 
B) MySQL*Plus. 
C) MySQL Command Shell. 
D) A and B 
E) A,B and C

Question 15

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.

Question 16

Explain the MySQL Block Structure.

Accepted Answer

The MySQL block structure is:
DELIMITER

Question 17

MySQL users may be granted MySQL server administrative roles.

Accepted Answer

A) True 
 B)False

Question 18

The MySQL keyword to close and exit 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 19

Which trigger types does MySQL not 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 20

To execute an SQL query,click the Execute Current SQL Statement in Connected Server button.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With MySQL 55

The MySQL Table Editor is accessible from the MySQL Workbench.

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

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

MySQL Community Edition requires that the .NET Framework version 2.0 be installed.

To run an SQL script,click the Execute button on the Query Toolbar.

The MySQL block structure defines variables with the BEGIN keyword.

MySQL supports AFTER triggers.

Schema is the MySQL synonym for database.

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

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

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

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

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

The MySQL GUI tool(s)used for database administration and management is(are):

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

Explain the MySQL Block Structure.

MySQL users may be granted MySQL server administrative roles.

The MySQL keyword to close and exit a cursor is:

Which trigger types does MySQL not support?

To execute an SQL query,click the Execute Current SQL Statement in Connected Server button.

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