Question 1

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 2

Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

Accepted Answer

A) True 
 B)False

Question 3

Describe how to create and run an SQL query in MySQL Server Community Edition.

Accepted Answer

[This is actually covered in Chapter 2,b

Question 4

What is MySQL?

Accepted Answer

MySQL is an open source database that ru

Question 5

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

Accepted Answer

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

Question 6

To execute an SQL query,click the Execute Current SQL Statement in Connected Server button.

Accepted Answer

A) True 
 B)False

Question 7

Schema is the MySQL synonym for database.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE READ 
D) A and B 
E) A,B,and C 
A) READ UNCOMMITTED 
B) READ COMMITTED 
C) REPEATABLE READ 
D) A and B 
E) A,B,and C

Question 9

MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The default transaction isolation level in MySQL is REPEATABLE READ.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The MySQL Table Editor is accessible from the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 15

To run an SQL script,click the Execute button on the Query Toolbar.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT:

Accepted Answer

A) Disable AUTO_INCREMENT. 
B) Temporarily remove AUTO_INCREMENT. 
C) Use the AUTO_INCREMENT_INSERT command. 
D) A or C 
E) B or C 
A) Disable AUTO_INCREMENT. 
B) Temporarily remove AUTO_INCREMENT. 
C) Use the AUTO_INCREMENT_INSERT command. 
D) A or C 
E) B or C

Question 20

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.

Exam 10: C: Managing Databases With MySQL

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

Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

Describe how to create and run an SQL query in MySQL Server Community Edition.

What is MySQL?

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

To execute an SQL query,click the Execute Current SQL Statement in Connected Server button.

Schema is the MySQL synonym for database.

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

MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.

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

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

The default transaction isolation level in MySQL is REPEATABLE READ.

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

The MySQL Table Editor is accessible from the MySQL Workbench.

To run an SQL script,click the Execute button on the Query Toolbar.

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

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

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.

To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT:

A new MySQL database is created using:

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