Question 1

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 Local instance MySQL56 command 
D) the Local instance MySQL56 dialog box 
A) the Connect to Server command 
B) the Connect to Server dialog box 
C) the Local instance MySQL56 command 
D) the Local instance MySQL56 dialog box

Question 2

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 3

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) Both A and B are correct 
A) Administrative roles 
B) Schema privileges 
C) Root user equivalence 
D) Both A and B are correct

Question 4

The MySQL keyword to close and exit a cursor is ________.

Accepted Answer

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

Question 5

Briefly explain the process for configuring MySQL for importing Excel 2013 spreadsheet data into a SQL Server table,then discuss the import process using the MySQL for Excel Add-In.

Accepted Answer

Using the MySQL installer,select "MySQL

Question 6

Explain the MySQL control-of-flow statements.

Accepted Answer

The MySQL control-of-flow statements are

Question 7

A new MySQL database is created using ________.

Accepted Answer

A) the New Database dialog tab 
B) the Create Database command 
C) the new_schema dialog tab 
D) the Create Schema command 
A) the New Database dialog tab 
B) the Create Database command 
C) the new_schema dialog tab 
D) the Create Schema command

Question 8

MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

Accepted Answer

A) True 
 B)False

Question 9

What is the MySQL Workbench?

Accepted Answer

The MySQL Workbench is the GUI tool that

Question 10

MySQL Community Edition uses only operating system authentication.

Accepted Answer

A) True 
 B)False

Question 11

MySQL backups are run on the Administration - Data Export tab of the Data Export page.

Accepted Answer

A) True 
 B)False

Question 12

For use with this book,it is recommended that MySQL be configured as a developer machine.

Accepted Answer

A) True 
 B)False

Question 13

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 
A) CREATE PROCEDURE 
B) ALTER PROCEDURE 
C) DROP PROCEDURE 
D) CLOSE PROCEDURE

Question 14

MySQL indexes can be created by using ________.

Accepted Answer

A) the MySQL Table Editor 
B) the MySQL Index Editor 
C) an SQL statement 
D) Both A and C are correct 
A) the MySQL Table Editor 
B) the MySQL Index Editor 
C) an SQL statement 
D) Both A and C are correct

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The main MySQL GUI utility is ________.

Accepted Answer

A) MySQL Management Studio 
B) MySQL Developer 
C) My SQL Workbench 
D) Both A and B are correct 
A) MySQL Management Studio 
B) MySQL Developer 
C) My SQL Workbench 
D) Both A and B are correct

Question 17

MySQL users may be granted MySQL server administrative roles.

Accepted Answer

A) True 
 B)False

Question 18

MySQL users should always be given the GRANT OPTION for each schema.

Accepted Answer

A) True 
 B)False

Question 19

The MySQL statement to delete a stored procedure already in the database is ________.

Accepted Answer

A) CREATE PROCEDURE 
B) ALTER PROCEDURE 
C) DROP PROCEDURE 
D) CLOSE PROCEDURE 
A) CREATE PROCEDURE 
B) ALTER PROCEDURE 
C) DROP PROCEDURE 
D) CLOSE PROCEDURE

Question 20

MySQL Workbench is the MySQL GUI database administration utility.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With Mysql 5.6

Logging into the MySQL DBMS is done using ________.

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

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

The MySQL keyword to close and exit a cursor is ________.

Briefly explain the process for configuring MySQL for importing Excel 2013 spreadsheet data into a SQL Server table,then discuss the import process using the MySQL for Excel Add-In.

Explain the MySQL control-of-flow statements.

A new MySQL database is created using ________.

MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

What is the MySQL Workbench?

MySQL Community Edition uses only operating system authentication.

MySQL backups are run on the Administration - Data Export tab of the Data Export page.

For use with this book,it is recommended that MySQL be configured as a developer machine.

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

MySQL indexes can be created by using ________.

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

The main MySQL GUI utility is ________.

MySQL users may be granted MySQL server administrative roles.

MySQL users should always be given the GRANT OPTION for each schema.

The MySQL statement to delete a stored procedure already in the database is ________.

MySQL Workbench is the MySQL GUI database administration utility.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters