Exam 11: Getting Started With Mysql 5.6 Community Server

A new MySQL database is created using:

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

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.

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

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.

To create a new MySQL query,use the ________ command.

The MySQL Workbench EER models are data models.

SQL query results are displayed in a tabbed results window.

MySQL Workbench version ________ was generally available when this text was written.

MySQL 5.6 Server Community Edition uses ________ authentication.

To create a new SQL query,click the New Query button.

MySQL Community Server 5.6 requires the prior installation of:

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

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.

Users log into MySQL 5.6 Community Server Edition using the ________ dialog box.

MySQL Community Server 5.6 uses DBMS authentication.

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

Describe how to create a new database in MySQL 5.6 Community Server Edition.

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