Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

What is the advantage of using Microsoft Access as a frontend for a MySQL Server 5.7 database?

Accepted Answer

A)  Access's computational efficiencies 
B)  Access's tools, such as forms and menu systems 
C)  Access's foothold on the personal database market 
D)  Access's product affordability 
E)  Access's compatibility with MySQL 
A)  Access's computational efficiencies 
B)  Access's tools, such as forms and menu systems 
C)  Access's foothold on the personal database market 
D)  Access's product affordability 
E)  Access's compatibility with MySQL

Question 3

Describe how to create a new database design in the MySQL Workbench.

Accepted Answer

In the MySQL Workbench,new database desi

Question 4

SQL query results are displayed in a tabbed ________ window.

Accepted Answer

The answer of SQL query results are displayed in a...

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

To run an SQL script or SQL command in MySQL Server Community Edition ________.

Accepted Answer

A)  click the Execute button on the Query Toolbar 
B)  click the Execute button on the Browser Toolbar 
C)  click the Run button on the Query Toolbar 
D)  click the Run button on the Browser Toolbar 
E)  click the Execute SQL Script button on the Toolbar 
A)  click the Execute button on the Query Toolbar 
B)  click the Execute button on the Browser Toolbar 
C)  click the Run button on the Query Toolbar 
D)  click the Run button on the Browser Toolbar 
E)  click the Execute SQL Script button on the Toolbar

Question 7

MySQL ________ (version)Community Server Edition was generally available when this text was written.

Accepted Answer

The answer of MySQL ________ (version)Community Server Edition was generally...

Question 8

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

Accepted Answer

To add a new table object,clic

Question 9

SQL query results are displayed ________.

Accepted Answer

A)  in a tabbed results window 
B)  in a tabbed Results1 window 
C)  in a tabbed Document window 
D)  in a tabbed Messages window 
E)  in a tabbed Finished window 
A)  in a tabbed results window 
B)  in a tabbed Results1 window 
C)  in a tabbed Document window 
D)  in a tabbed Messages window 
E)  in a tabbed Finished window

Question 10

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

Accepted Answer

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

Question 11

How can data be inserted into a table in MySQL?

Accepted Answer

A)  Populate table statements 
B)  Insert statements in a script 
C)  Auto-insert button 
D)  Append statements in a script 
E)  Prepend statements in a script 
A)  Populate table statements 
B)  Insert statements in a script 
C)  Auto-insert button 
D)  Append statements in a script 
E)  Prepend statements in a script

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

A) True 
 B)False

Question 14

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

Accepted Answer

A)  PK 
B)  NN 
C)  UQ 
D)  BIN 
E)  AI 
A)  PK 
B)  NN 
C)  UQ 
D)  BIN 
E)  AI

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Describe how to set table properties in a MySQL Workbench database design.

Accepted Answer

Double-click the table object to open th

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

Connect to

Question 19

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________.

Accepted Answer

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

Question 20

To create a new MySQL Workbench EER model,you can use ________.

Accepted Answer

A)  the New Model button on the Home page 
B)  the File | New Model command 
C)  the Start new EER command 
D)  Either A or B 
E)  the EER express command 
A)  the New Model button on the Home page 
B)  the File | New Model command 
C)  the Start new EER command 
D)  Either A or B 
E)  the EER express command

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

What is the advantage of using Microsoft Access as a frontend for a MySQL Server 5.7 database?

Describe how to create a new database design in the MySQL Workbench.

SQL query results are displayed in a tabbed ________ window.

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.

To run an SQL script or SQL command in MySQL Server Community Edition ________.

MySQL ________ (version)Community Server Edition was generally available when this text was written.

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

SQL query results 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 ________.

How can data be inserted into a table in MySQL?

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 NOT NULL is ________.

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

Describe how to set table properties in a MySQL Workbench database design.

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

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

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________.

To create a new MySQL Workbench EER model,you can use ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

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

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

What is the advantage of using Microsoft Access as a frontend for a MySQL Server 5.7 database?

Describe how to create a new database design in the MySQL Workbench.

SQL query results are displayed in a tabbed ________ window.

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.

To run an SQL script or SQL command in MySQL Server Community Edition ________.

MySQL ________ (version)Community Server Edition was generally available when this text was written.

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

SQL query results 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 ________.

How can data be inserted into a table in MySQL?

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 NOT NULL is ________.

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

Describe how to set table properties in a MySQL Workbench database design.

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

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

In the MySQL Workbench,a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using ________.

To create a new MySQL Workbench EER model,you can use ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters