Question 1

In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.

Accepted Answer

A) True 
 B)False  True

Question 2

Describe the MySQL Connector/ODBC and how to install it.

Accepted Answer

The MySQL Connector/ODBC is a downloadable utility that provides the MySQL ODBC 5.1 driver.For the Windows operating system,use the MySQL Installer for Windows.For non-Windows operating systems,download it from the MySQL development Web site,and run the installation.After the installation,the MySQL ODBC 5.1 driver will appear in the ODBC Data Source Administrator.

Question 3

The authors recommend using which of the following folder structures with the MySQL Workbench?

Accepted Answer

A) .\MyDocumnets\MySQL Workbench. 
B) .\MyDocumnets\MySQL Workbench\Schemas. 
C) .\MyDocumnets\MySQL Workbench\EER Models. 
D) Both A and B. 
E) All of the above. 
A) .\MyDocumnets\MySQL Workbench. 
B) .\MyDocumnets\MySQL Workbench\Schemas. 
C) .\MyDocumnets\MySQL Workbench\EER Models. 
D) Both A and B. 
E) All of the above. E

Question 4

Describe how to create relationships in a MySQL Workbench database design.

Accepted Answer

The MySQL Workbench includes a set of bu

Question 5

To create a new MySQL Workbench EER model,you can use the File | New Model command.

Accepted Answer

A) True 
 B)False

Question 6

To create a new MySQL Workbench EER model,you can use:

Accepted Answer

A) the Create new EER Model link on the Home page. 
B) the File | New Model command. 
C) the Start new EER command. 
D) A or B. 
E) All of the above. 
A) the Create new EER Model link on the Home page. 
B) the File | New Model command. 
C) the Start new EER command. 
D) A or B. 
E) All of the above.

Question 7

The MySQL Installer for Windows should be used to install MySQL Community Edition components on computers running which operating system(s)?

Accepted Answer

A) Microsoft Windows 
B) Unix 
C) Linux 
D) Either B or C 
E) Any of the above. 
A) Microsoft Windows 
B) Unix 
C) Linux 
D) Either B or C 
E) Any of the above.

Question 8

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

Accepted Answer

A) the 1:N Identifying Relationship button. 
B) the 1:N Non-identifying Relationship button. 
C) the N:M Identifying Relationship button. 
D) the Place a Relationship Using Existing Columns button. 
E) None of the above is correct. 
A) the 1:N Identifying Relationship button. 
B) the 1:N Non-identifying Relationship button. 
C) the N:M Identifying Relationship button. 
D) the Place a Relationship Using Existing Columns button. 
E) None of the above is correct.

Question 9

The MySQL Installer for Linux can be used to install the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 10

In the MySQL Table Editor,the abbreviation PK stands for partial key.

Accepted Answer

A) True 
 B)False

Question 11

Users should create a Data Models folder to hold EER models created with the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 12

Describe how to add a table object to a MySQL Workbench database design.

Accepted Answer

To add a new table object,clic

Question 13

In order to create MySQL EER diagrams,users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.

Accepted Answer

A) True 
 B)False

Question 14

In the MySQL Table Editor,the abbreviation for Primary Key is:

Accepted Answer

A) PK 
B) NN 
C) UQ 
D) BIN 
E) AI 
A) PK 
B) NN 
C) UQ 
D) BIN 
E) AI

Question 15

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button.

Accepted Answer

A) True 
 B)False

Question 16

To add a table to a database design,click the Place a New Table button,move the cursor to the diagram area and click the left mouse button.

Accepted Answer

A) True 
 B)False

Question 17

The MySQL Workbench EER models are data models.

Accepted Answer

A) True 
 B)False

Question 18

The installation of the MySQL Community Edition 5.6 always includes the installation of the MySQL Workbench.

Accepted Answer

A) True 
 B)False

Question 19

By default,the E-R diagrams created in the MySQL Workbench use:

Accepted Answer

A) IE Crow's Foot notation. 
B) IDEF1X notation. 
C) UML notation. 
D) Microsoft Visio 2013 Arrow notation. 
E) None of the above is correct. 
A) IE Crow's Foot notation. 
B) IDEF1X notation. 
C) UML notation. 
D) Microsoft Visio 2013 Arrow notation. 
E) None of the above is correct.

Question 20

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:

Accepted Answer

A) the 1:N Identifying Relationship button. 
B) the 1:N Non-identifying Relationship button. 
C) the N:M Identifying Relationship button. 
D) the Place a Relationship Using Existing Columns button. 
E) None of the above is correct. 
A) the 1:N Identifying Relationship button. 
B) the 1:N Non-identifying Relationship button. 
C) the N:M Identifying Relationship button. 
D) the Place a Relationship Using Existing Columns button. 
E) None of the above is correct.

Exam 17: Getting Started With MySQL Workbench Data Modeling Tools

In the MySQL Table Editor,the abbreviation AI stands for AUTO_INCREMENT.

Describe the MySQL Connector/ODBC and how to install it.

The authors recommend using which of the following folder structures with the MySQL Workbench?

Describe how to create relationships in a MySQL Workbench database design.

To create a new MySQL Workbench EER model,you can use the File | New Model command.

To create a new MySQL Workbench EER model,you can use:

The MySQL Installer for Windows should be used to install MySQL Community Edition components on computers running which operating system(s)?

In the MySQL Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

The MySQL Installer for Linux can be used to install the MySQL Workbench.

In the MySQL Table Editor,the abbreviation PK stands for partial key.

Users should create a Data Models folder to hold EER models created with the MySQL Workbench.

Describe how to add a table object to a MySQL Workbench database design.

In order to create MySQL EER diagrams,users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.

In the MySQL Table Editor,the abbreviation for Primary Key is:

In the MySQL Workbench,a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button.

To add a table to a database design,click the Place a New Table button,move the cursor to the diagram area and click the left mouse button.

The MySQL Workbench EER models are data models.

The installation of the MySQL Community Edition 5.6 always includes the installation of the MySQL Workbench.

By default,the E-R diagrams created in the MySQL Workbench use:

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys 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

C: Managing Databases With MySQL

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 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