Exam 11: Learn how to create a database in MySQL 5.7 Community Server Edition

The MySQL Workbench is included in the MySQL Community Server 5.7 installation when the MySQL Installer for Windows is used.

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

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.

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

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

When importing data from Excel,what SQL statement is needed to add constraints to your newly created tables?

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

In the MySQL Table Editor,the abbreviation for Primary Key is ________.

Database objects are displayed in the ________ window in the MySQL Workbench.

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.

Table names are edited in the MySQL EER Component Editor.

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

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

A new MySQL database is created using ________.

Logging into the MySQL Community Server 5.7 DBMS is done using ________.

MySQL Community Server 5.7 requires the prior installation of ________.

DBMS objects are displayed ________.

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 the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

A new MySQL database is created using the New Database dialog box.