Question 1

To create a new MySQL Workbench EER model,you can use the Create new EER Model link on the Home page.

Accepted Answer

A) True 
 B)False  True

Question 2

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

Accepted Answer

A) True 
 B)False  True

Question 3

Table column characteristics can be edited in the MySQL Table Editor.

Accepted Answer

A) True 
 B)False  True

Question 4

The MySQL Workbench can be used to create ________.

Accepted Answer

A) data models 
B) data designs 
C) database models 
D) database designs 
A) data models 
B) data designs 
C) database models 
D) database designs

Question 5

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

Accepted Answer

The MySQL Workbench includes a set of bu

Question 6

Table names are edited in the MySQL EER Component Editor.

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

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

Accepted Answer

A) the add Model link on the Home page 
B) the File | New Model command 
C) the Start new EER command 
D) Both A or B are correct 
A) the add Model link on the Home page 
B) the File | New Model command 
C) the Start new EER command 
D) Both A or B are correct

Question 9

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

Accepted Answer

The MySQL Connector/ODBC is a downloadab

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Describe how to set table properties in a MySQL Workbench database design.

Accepted Answer

Double-click the table object to open th

Question 12

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 13

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

Accepted Answer

A) ..\MyDocuments\MySQL Workbench\EER Models 
B) ..\MyDocuments\MySQL Workbench\Schemas 
C) ..\MyDocuments\MySQL Workbench\Databases 
D) Both A and B are correct. 
A) ..\MyDocuments\MySQL Workbench\EER Models 
B) ..\MyDocuments\MySQL Workbench\Schemas 
C) ..\MyDocuments\MySQL Workbench\Databases 
D) Both A and B are correct.

Question 14

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

Accepted Answer

To add a new table object,clic

Question 15

To place a table in a MySQL database design,start by clicking the ________.

Accepted Answer

A) Table button 
B) Entity button 
C) Place a New Table button 
D) Place a New Entity button 
A) Table button 
B) Entity button 
C) Place a New Table button 
D) Place a New Entity button

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In the Windows 8 or 8.1 OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.

Accepted Answer

A) True 
 B)False

Question 20

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) Both B and C are correct 
A) Microsoft Windows 
B) Unix 
C) Linux 
D) Both B and C are correct

Exam 19: Getting Started With Mysql Workbench Data Modeling Tools

To create a new MySQL Workbench EER model,you can use the Create new EER Model link on the Home page.

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

Table column characteristics can be edited in the MySQL Table Editor.

The MySQL Workbench can be used to create ________.

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

Table names are edited in the MySQL EER Component Editor.

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

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

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

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

Describe how to set table properties in 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.

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

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

To place a table in a MySQL database design,start by clicking the ________.

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

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

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

In the Windows 8 or 8.1 OS,to start working with the MySQL Workbench use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.

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

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

Managing Databases With Mysql 5.6

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