Question 1

MySQL Community Edition uses operating system authentication.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

MySQL Workbench is the MySQL GUI database administration utility.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

The MySQL Workbench is the main utility used to implement MySQL security.

Accepted Answer

A) True 
 B)False

Question 10

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 11

What is the MySQL Table Editor?

Accepted Answer

The MySQL Table Editor is a GUI administ

Question 12

To create a MySQL index using SQL,the correct SQL statement is:

Accepted Answer

A) ALTER TABLE {TableName} ADD INDEX {IndexName}. 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}. 
C) CREATE INDEX {IndexName} ON TABLE {TableName}. 
D) A or C 
E) B or C 
A) ALTER TABLE {TableName} ADD INDEX {IndexName}. 
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}. 
C) CREATE INDEX {IndexName} ON TABLE {TableName}. 
D) A or C 
E) B or C

Question 13

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

Accepted Answer

A) True 
 B)False

Question 14

To run an SQL script,click the Execute SQL Script in Connected Server button on the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which trigger types does MySQL 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 17

A new MySQL database is created using:

Accepted Answer

A) the New Database dialog box. 
B) the Create Database command. 
C) the new_schema dialog box. 
D) the Create Schema command. 
E) the New Object dialog box. 
A) the New Database dialog box. 
B) the Create Database command. 
C) the new_schema dialog box. 
D) the Create Schema command. 
E) the New Object dialog box.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is the MySQL Workbench?

Accepted Answer

The MySQL Workbench is the GUI tool that

Question 20

MySQL databases are backed up using the MySQL Backup System.

Accepted Answer

A) True 
 B)False

Exam 12: Managing Databases With MySQL 55

MySQL Community Edition uses operating system authentication.

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

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

MySQL Workbench is the MySQL GUI database administration utility.

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

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

The MySQL block structure defines variables with the keyword:

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

The MySQL Workbench is the main utility used to implement MySQL security.

DBMS objects are displayed:

What is the MySQL Table Editor?

To create a MySQL index using SQL,the correct SQL statement is:

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

To run an SQL script,click the Execute SQL Script in Connected Server button on the MySQL Workbench.

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

Which trigger types does MySQL support?

A new MySQL database is created using:

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

What is the MySQL Workbench?

MySQL databases are backed up using the MySQL Backup System.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters