Question 1

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

Accepted Answer

It is a good practice to create a separate folder to organize and store the documents and files created using MySQL Workbench. This makes it easier to manage and locate them later.

Question 2

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.

Accepted Answer

MySQL Workbench, which is typically used to create EER diagrams, requires users to connect to a MySQL server, but this is not done through the dialog boxes mentioned. Instead, users must click on the "New Connection" button in the "MySQL Connections" tab to create a new connection to a server. Once the connection is established, they can then create EER diagrams.

Question 3

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is ________.
A) PK
B) NN
C) UQ
D) BIN
E) AI

Accepted Answer

AUTO_INCREMENT is abbreviated as AI in MySQL.

Question 4

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

Accepted Answer

The answer of Database objects are displayed in the ________...

Question 5

Accepted Answer

The "Help | Help Index" command is the most likely option to access the MySQL Workbench documentation. It typically provides an index of the available documentation resources and allows the user to search for specific topics or keywords. The other options listed may provide some help or information, but they are less direct or specific to the MySQL Workbench documentation.

Question 6

Logging into the MySQL Community Server 5.7 DBMS is done using ________.
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

Accepted Answer

The recommended way to log into the MySQL Community Server 5.7 DBMS is using the Connect to MySQL Server dialog box, which is accessed through the MySQL Workbench interface. This dialog box allows the user to specify the connection parameters, such as server hostname or IP address, port, username, and password. The other choices listed are either incomplete or slightly inaccurate.

Question 7

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 ________. 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.

Accepted Answer

A non-identifying relationship between two tables is created using the 1:N Non-identifying Relationship button in MySQL Workbench. This creates a relationship where the child table does not have a foreign key that references the parent table's primary key.

Question 8

A new MySQL database is created using ________.
A) the new_database dialog box
B) the Create Database command
C) the new_schema dialog box
D) the Create Schema command
E) the New Object dialog box

Accepted Answer

The answer of A new MySQL database is created using...

Question 9

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

Accepted Answer

The answer of Describe how to create a new database...

Question 10

In the MySQL Table Editor,the abbreviation for NOT NULL is ________.
A) PK
B) NN
C) UQ
D) BIN
E) AI

Accepted Answer

NOT NULL means that the column must have a value and cannot be left empty. NN is the abbreviation used in MySQL Table Editor for NOT NULL.

Question 11

A new MySQL Server database is known as a new ________.

Accepted Answer

The answer of A new MySQL Server database is known...

Question 12

To access documentation at the MySQL Web site ________.
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

Accepted Answer

Going directly to the Web site http://dev.mysql.com/doc is the best choice to access documentation at the MySQL Web site.

Question 13

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

Accepted Answer

A new MySQL database is typically created using SQL commands such as `CREATE DATABASE` executed through a command-line interface or a database management tool, not through a "New Database dialog box." The dialog box approach might be specific to certain database management tools or IDEs, but it's not a standard MySQL feature.

Question 14

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

Accepted Answer

Users can log into MySQL Workbench using the Connect to MySQL Server dialog box.

Question 15

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

Accepted Answer

The answer of Database objects are displayed in the Object...

Question 16

DBMS objects are displayed ________.
A) in the Navigator Window
B) in the Object Browser
C) in the tabbed database window
D) in the tabbed document window
E) in the command tab

Accepted Answer

DBMS objects are typically displayed in the Navigator Window, which provides a hierarchical view of the database objects.

Question 17

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 ________. 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.

Accepted Answer

The correct way to create a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys in MySQL Workbench is by using the "Place a Relationship Using Existing Columns" button. This option allows you to specify the existing columns to be used for the relationship.

Question 18

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

Accepted Answer

The answer of Users log into MySQL 5.7 Community Server...

Question 19

In the MySQL Table Editor,the abbreviation for Primary Key is ________.
A) PK
B) NN
C) UQ
D) BIN
E) AI

Accepted Answer

Primary Key is usually abbreviated as PK in MySQL Table Editor.

Question 20

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

Accepted Answer

It is a good practice to create a separate folder to organize and store EER models created with the MySQL Workbench for easy management and access.

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

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

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 Table Editor,the abbreviation for AUTO_INCREMENT is ________.

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

To access documentation about the MySQL Workbench,use the ________.

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

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 ________.

A new MySQL database is created using ________.

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

In the MySQL Table Editor,the abbreviation for NOT NULL is ________.

A new MySQL Server database is known as a new ________.

To access documentation at the MySQL Web site ________.

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

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

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

DBMS objects are displayed ________.

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 ________.

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

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

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