Question 1

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

Accepted Answer

In MySQL Community Edition,new databases

Question 2

What MySQL utility is used for DBMS administration?

Accepted Answer

The MySQL Workbench is now the single,in

Question 3

MySQL users may be granted MySQL server administrative roles.

Accepted Answer

A) True 
 B)False

Question 4

The active MySQL database is specified using:

Accepted Answer

A) the Set Schema command. 
B) the Set Database command. 
C) the Make Default Schema command. 
D) the Set as Default Schema command. 
E) the Set Schema dialog box. 
A) the Set Schema command. 
B) the Set Database command. 
C) the Make Default Schema command. 
D) the Set as Default Schema command. 
E) the Set Schema dialog box.

Question 5

What is the MySQL Command-Line Client?

Accepted Answer

The MySQL Command-Line Client is a chara

Question 6

What is the MySQL Workbench?

Accepted Answer

The MySQL Workbench is the GUI tool that

Question 7

Which of the following MySQL configuration settings are recommend for use with this book?

Accepted Answer

A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) A and B 
E) A,B,and C 
A) Developer machine 
B) Multifunction machine 
C) Decision Support (DSS)/OLAP 
D) A and B 
E) A,B,and C

Question 8

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

Accepted Answer

A) True 
 B)False

Question 9

MySQL supports BEFORE triggers.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

The MySQL Command Line Client is the MySQL command line utility.

Accepted Answer

A) True 
 B)False

Question 12

MySQL uses the MySQL OLD transition variable with triggers to access old data updated or deleted from a table row.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which schema privilege should not be specifically assigned to a user account?

Accepted Answer

A) SELECT 
B) CREATE 
C) GRANT 
D) A and B 
E) A,B,and C 
A) SELECT 
B) CREATE 
C) GRANT 
D) A and B 
E) A,B,and C

Question 16

MySQL supports INSTEAD OF triggers.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

To start working with MySQL Community Edition,use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.

Accepted Answer

A) True 
 B)False

Question 20

What term does MySQL use as a synonym for backup?

Accepted Answer

A) Replica 
B) Export 
C) Data export 
D) Data export dump 
E) None of the above. 
A) Replica 
B) Export 
C) Data export 
D) Data export dump 
E) None of the above.

Exam 10: C: Managing Databases With MySQL

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

What MySQL utility is used for DBMS administration?

MySQL users may be granted MySQL server administrative roles.

The active MySQL database is specified using:

What is the MySQL Command-Line Client?

What is the MySQL Workbench?

Which of the following MySQL configuration settings are recommend for use with this book?

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

MySQL supports BEFORE triggers.

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

The MySQL Command Line Client is the MySQL command line utility.

MySQL uses the MySQL OLD transition variable with triggers to access old data updated or deleted from a table row.

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

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

Which schema privilege should not be specifically assigned to a user account?

MySQL supports INSTEAD OF triggers.

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

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

To start working with MySQL Community Edition,use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.

What term does MySQL use as a synonym for backup?

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