Question 1

The MySQL block structure defines variables with the keyword:

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 2

MySQL supports AFTER triggers.

Accepted Answer

A) True 
 B)False

Question 3

Explain the MySQL control-of-flow statements.

Accepted Answer

The MySQL control-of-flow statements are

Question 4

MySQL Community Edition uses operating system authentication.

Accepted Answer

A) True 
 B)False

Question 5

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 6

The MySQL statement used to define a set of MySQL procedure statements 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 7

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 8

The MySQL command line utility is:

Accepted Answer

A) MySQL*Plus. 
B) the MySQL Command-Line Client. 
C) MySQL-Shell. 
D) MySQL-CMD. 
E) None of the above is correct. 
A) MySQL*Plus. 
B) the MySQL Command-Line Client. 
C) MySQL-Shell. 
D) MySQL-CMD. 
E) None of the above is correct.

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

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 11

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 12

The MySQL Installer for Windows requires the ________ operating system.

Accepted Answer

A) Suse Linux 
B) Red Hat Linux 
C) FreeBSD 
D) Microsoft Windows 
E) Any of the above 
A) Suse Linux 
B) Red Hat Linux 
C) FreeBSD 
D) Microsoft Windows 
E) Any of the above

Question 13

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 14

Which transaction isolation level scope(s)is (are)available in MySQL?

Accepted Answer

A) GLOBAL 
B) SESSION 
C) TRANSACTION 
D) A and B 
E) A,B,and C 
A) GLOBAL 
B) SESSION 
C) TRANSACTION 
D) A and B 
E) A,B,and C

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 in Connected Server button in the MySQL Workbench. 
E) click the Execute Current SQL Statement in Connected Server 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 in Connected Server button in the MySQL Workbench. 
E) click the Execute Current SQL Statement in Connected Server button in the MySQL Workbench.

Question 18

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 19

MySQL backups that contain the entire database are run using the Export to Self-Contained File option.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 10: C: Managing Databases With MySQL

The MySQL block structure defines variables with the keyword:

MySQL supports AFTER triggers.

Explain the MySQL control-of-flow statements.

MySQL Community Edition uses operating system authentication.

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

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

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

The MySQL command line utility is:

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

Logging into the MySQL DBMS is done using:

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

The MySQL Installer for Windows requires the ________ operating system.

The MySQL keyword to close and exit a cursor is:

Which transaction isolation level scope(s)is (are)available in MySQL?

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

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

To run a single SQL command in MySQL Community Edition:

The MySQL keyword to actually start using a cursor is:

MySQL backups that contain the entire database are run using the Export to Self-Contained File option.

The main MySQL GUI utility 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