Question 1

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

Accepted Answer

The MySQL Workbench includes a set of bu

Question 2

To access documentation at the MySQL Web site:

Accepted Answer

A)  use the Help | MySQL Workbench command. 
B)  use the Help | Help Index command. 
C)  use the Help | MySQL Website command. 
D)  use the Help | MySQL.com Website command. 
E)  go directly to the Web site http://dev.mysql.com/doc. 
A)  use the Help | MySQL Workbench command. 
B)  use the Help | Help Index command. 
C)  use the Help | MySQL Website command. 
D)  use the Help | MySQL.com Website command. 
E)  go directly to the Web site http://dev.mysql.com/doc.

Question 3

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.

Question 4

MySQL ________ (version)Community Server Edition was generally available when this text was written.

Accepted Answer

The answer of MySQL ________ (version)Community Server Edition was generally...

Question 5

Users log into MySQL Community Server 5.6 using the Connect to MySQL Server dialog box.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  the New Model button 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 New Model button 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

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 2010 Arrow notation. 
E)  None of the above is correct. 
A)  IE Crow's Foot notation. 
B)  IDEF1X notation. 
C)  UML notation. 
D)  Microsoft Visio 2010 Arrow notation. 
E)  None of the above is correct.

Question 8

In the MySQL Workbench,a 1:N non-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

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

Accepted Answer

A)  the Connect to Database dialog box. 
B)  the Connect to MySQL Server dialog box. 
C)  the MySQL | Connect to Server command. 
D)  Both A and B are used together. 
E)  None of the above is correct - no login is required. 
A)  the Connect to Database dialog box. 
B)  the Connect to MySQL Server dialog box. 
C)  the MySQL | Connect to Server command. 
D)  Both A and B are used together. 
E)  None of the above is correct - no login is required.

Question 10

In addition to downloading MySQL Community Server and the MySQL Workbench,it is recommended that the ________ also be downloaded.

Accepted Answer

MySQL Conn

Question 11

Logging into the MySQL Community Server 5.6 DBMS is done using:

Accepted Answer

A)  the Connect to Server command. 
B)  the Connect to Server dialog box. 
C)  the Connect to MySQL Server command. 
D)  the Connect to MySQL Server dialog box. 
E)  None of the above is correct. 
A)  the Connect to Server command. 
B)  the Connect to Server dialog box. 
C)  the Connect to MySQL Server command. 
D)  the Connect to MySQL Server dialog box. 
E)  None of the above is correct.

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

To access documentation at the MySQL Web site:

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

MySQL ________ (version)Community Server Edition was generally available when this text was written.

Users log into MySQL Community Server 5.6 using the Connect to MySQL Server dialog box.

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

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

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

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

In addition to downloading MySQL Community Server and the MySQL Workbench,it is recommended that the ________ also be downloaded.

Logging into the MySQL Community Server 5.6 DBMS is done using:

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 11: Getting Started With Mysql 56 Community Server

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

To access documentation at the MySQL Web site:

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

MySQL ________ (version)Community Server Edition was generally available when this text was written.

Users log into MySQL Community Server 5.6 using the Connect to MySQL Server dialog box.

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

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

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

In order to use MySQL Workbench to create database designs,you must log into MySQL using:

In addition to downloading MySQL Community Server and the MySQL Workbench,it is recommended that the ________ also be downloaded.

Logging into the MySQL Community Server 5.6 DBMS is done using:

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters