Question 1

The MySQL SQL/PSM statement used to test for a condition and then direct which 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

Question 2

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

Accepted Answer

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

Question 3

MySQL is configured using the MySQL Server Instance Configuration Wizard.

Accepted Answer

A) True 
 B)False

Question 4

What is the MySQL Table Editor?

Accepted Answer

The answer of What is the MySQL Table Editor?...

Question 5

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 6

MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The MySQL keyword to actually start using a cursor is ________.

Accepted Answer

A) DECLARE CURSOR {CursorName} 
B) OPEN {CursorName} 
C) FETCH 
D) CLOSE {CursorName}

Question 9

MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.

Accepted Answer

A) True 
 B)False

Question 10

MySQL databases are backed up using the MySQL Backup System.

Accepted Answer

A) True 
 B)False

Question 11

Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

The spreadsheet data must first be highlighted (selected)in order to be imported using the MySQL for Excel Add-In.

Accepted Answer

A) True 
 B)False

Question 15

MySQL uses the "Safe Updates"-Forbid UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause-checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 16

Database objects are displayed in the Object Explorer window in the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 17

MySQL users are created on the Users and Privileges page in the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 18

In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Accepted Answer

A) True 
 B)False

Question 19

The default transaction isolation level in MySQL is REPEATABLE READ.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 12: Managing Databases With Mysql 5.6

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

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

MySQL is configured using the MySQL Server Instance Configuration Wizard.

What is the MySQL Table Editor?

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

MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

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

The MySQL keyword to actually start using a cursor is ________.

MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.

MySQL databases are backed up using the MySQL Backup System.

Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

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

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

The spreadsheet data must first be highlighted (selected)in order to be imported using the MySQL for Excel Add-In.

MySQL uses the "Safe Updates"-Forbid UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause-checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Database objects are displayed in the Object Explorer window in the MySQL Workbench.

MySQL users are created on the Users and Privileges page in the MySQL Workbench.

In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

The default transaction isolation level in MySQL is REPEATABLE READ.

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