Question 1

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 2

MySQL Workbench is the MySQL GUI database administration utility.

Accepted Answer

A) True 
 B)False

Question 3

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 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. 
E) None of the above. 
A) CREATE PROCEDURE. 
B) ALTER PROCEDURE. 
C) DROP PROCEDURE. 
D) CLOSE PROCEDURE. 
E) None of the above.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The MySQL block structure defines variables with the BEGIN keyword.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

MySQL is configured using the MySQL Server Instance Configuration Wizard.

Accepted Answer

A) True 
 B)False

Question 12

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. 
E) in the command tab. 
A) in the Navigation Pane. 
B) in the Object Browser. 
C) in the tabbed database window. 
D) in the tabbed document window. 
E) in the command tab.

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

MySQL users are granted MySQL privileges for specific schemas only.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Question 18

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 19

Which trigger type(s)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

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.

Exam 10: C: Managing Databases With MySQL

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

MySQL Workbench is the MySQL GUI database administration utility.

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

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

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

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

The MySQL block structure defines variables with the BEGIN keyword.

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

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

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

MySQL is configured using the MySQL Server Instance Configuration Wizard.

DBMS objects are displayed:

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

MySQL users are granted MySQL privileges for specific schemas only.

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

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

SQL query results are displayed:

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

Which trigger type(s)does MySQL not support?

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

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 Eclipse PDT

Business Intelligence Systems

Filters