Question 1

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

Accepted Answer

It is recommended to create a folder to hold all the EER models created with the MySQL Workbench in order to keep them organized and easily accessible.

Question 2

Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.

Accepted Answer

It is a good practice to create a separate folder to organize and store the documents and files created using MySQL Workbench. This makes it easier to manage and locate them later.

Question 3

The MySQL Workbench EER models are data models.

Accepted Answer

False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

NN stands for NOT NULL in MySQL Table Editor.

Question 6

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

Accepted Answer

Both A and B are correct choices for folder structures to use with MySQL Workbench. The EER Models folder can be used to store the visual models of database schemas, while the Schemas folder can be used to store the actual SQL scripts for creating the schemas. Both of these folders can be easily exported and shared with other team members or uploaded to a version control system. The Databases folder, however, should not be used as it is a default folder created by MySQL Workbench and is not meant for storing individual database schemas.

Question 7

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

The answer of In the Windows 8 or 8.1 OS,to...

Question 8

Table names are edited in the MySQL EER Component Editor.

Accepted Answer

Table names are edited in the MySQL Table Editor, not the EER Component Editor. The EER Component Editor is used for editing elements in an EER diagram, such as relationships and views, rather than the tables themselves.

Question 9

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

Accepted Answer

AI stands for AUTO_INCREMENT in MySQL Table Editor.

Question 10

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

Accepted Answer

The MySQL Table Editor allows users to edit various characteristics of table columns such as column name, type, length, default value, and more.

Question 11

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

Accepted Answer

The MySQL Installer for Linux is used to install MySQL Server and related components on Linux systems. It does not include the MySQL Workbench, which must be separately installed.

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

To create MySQL EER diagrams, users need to use a third-party tool such as MySQL Workbench, which provides a graphical interface for creating and managing EER diagrams. Users do not need to log in to MySQL directly to create these diagrams.

Question 13

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

Accepted Answer

The Create new EER Model link on the Home page allows you to create a new MySQL Workbench EER model.

Question 14

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

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

Question 15

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

Accepted Answer

The abbreviation PK stands for Primary Key, not partial key.

Question 16

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

Accepted Answer

The MySQL Installer for Windows should only be used to install MySQL Community Edition components on computers running Microsoft Windows operating system.

Question 17

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

Accepted Answer

MySQL Community Edition 5.6 installation does not automatically include MySQL Workbench; it must be downloaded and installed separately.

Question 18

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

This is the correct procedure to add a table to a database design using most database design software, including Microsoft Access and SQL Server Management Studio.

Question 19

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 1:N Non-identifying Relationship button.

Accepted Answer

The answer of In the MySQL Workbench,a 1:N non-identifying relationship...

Question 20

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

Accepted Answer

The MySQL Installer for Windows can be used to install various MySQL products, including the MySQL Workbench.

Quiz 19: Getting Started With Mysql Workbench Data Modeling Tools