Exam 11: Getting Started With Mysql 56 Community Server

SQL statements can be run individually or as part of a related group of SQL statements known as a:

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

SQL statements can be run individually or as part of a related group of SQL statements known as a(n)________.

Describe how to create a new database design in 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.

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

Database objects are displayed in the Object Browser window in the MySQL Workbench.

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

MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.

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

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

An important reason for using MySQL 5.6 Community Server Edition is that it has ________.

SQL query results are displayed in a tabbed ________ window.

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

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

Database objects are displayed in the ________ window in 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 Place a Relationship Using Existing Columns button.

MySQL Community Server 5.6 requires the prior installation of:

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.

Table names are edited in the MySQL EER Component Editor.