Exam 11: Getting Started With Mysql 56 Community Server

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

MySQL Community Server 5.6 uses DBMS authentication.

Describe how to create and run an SQL query in MySQL 5.6 Community Server Edition.

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 MySQL Workbench EER diagrams are actually ________ E-R diagrams.

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

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

An important reason for using MySQL Community Server 5.6 is that it has full SQL capabilities.

To run an SQL script,click the ________ button on the MySQL Workbench toolbar.

In the MySQL Table Editor,the abbreviation for NOT NULL is:

A new MySQL database is created using:

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

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

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 Workbench,a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using:

To run an SQL script,click the Execute button on the Query Toolbar.

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

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:

DBMS objects are displayed:

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