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

Explore all topics

In addition to downloading MySQL Community Server and the MySQL Workbench,it is recommended that the ________ also be downloaded.

Free

(Short Answer)

4.9/5

(40)

Question 1

Correct Answer:

Verified

MySQL Connector/ODBC

What is an SQL script,and why are SQL scripts useful?

Free

(Essay)

4.9/5

(32)

Question 2

Correct Answer:

Verified

An SQL Script is a group of SQL statements that are run consecutively.Each of the SQL statements in the script could be run separately,but running them as a group is more efficient,and this is what makes SQL scripts useful.A good example is grouping all the SQL CREATE TABLE statements necessary to build a database structure into a single SQL script.

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

Free

(Short Answer)

4.8/5

(36)

Question 3

Correct Answer:

Verified

Execute SQL Script

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

(True/False)

4.8/5

(34)

Question 4

The MySQL GUI tool is replaced by ________.

(Multiple Choice)

4.8/5

(36)

Question 5

Downloading and installing the MySQL connector/ODBC means that the ________ (name and version)driver will be available in the ODBC Data Source Administrator.

(Short Answer)

4.8/5

(30)

Question 6

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

(True/False)

4.8/5

(31)

Question 7

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.

(True/False)

4.9/5

(27)

Question 8

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

(Multiple Choice)

4.9/5

(33)

Question 9

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

(Short Answer)

4.7/5

(35)

Question 10

To access documentation at the MySQL Web site ________.

(Multiple Choice)

4.9/5

(37)

Question 11

The E-R diagrams created in the MySQL Workbench use ________.

(Multiple Choice)

4.8/5

(42)

Question 12

Describe the MySQL Connector/ODBC and how to install it.

(Essay)

4.9/5

(30)

Question 13

The MySQL Workbench EER models are data models.

(True/False)

4.7/5

(37)

Question 14

The MySQL Workbench can be used to create ________.

(Multiple Choice)

4.8/5

(31)

Question 15

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

(Multiple Choice)

4.8/5

(34)

Question 16

The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

(Short Answer)

4.9/5

(32)

Question 17

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

(Multiple Choice)

4.7/5

(41)

Question 18

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

(True/False)

4.9/5

(40)

Question 19

Describe how to create relationships in a MySQL Workbench database design.

(Essay)

4.9/5

(34)

Question 20

Showing 1 - 20 of 72

In addition to downloading MySQL Community Server and the MySQL Workbench,it is recommended that the ________ also be downloaded.

What is an SQL script,and why are SQL scripts useful?

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

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

The MySQL GUI tool is replaced by ________.

Downloading and installing the MySQL connector/ODBC means that the ________ (name and version)driver will be available in the ODBC Data Source Administrator.

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

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.

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

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

To access documentation at the MySQL Web site ________.

The E-R diagrams created in the MySQL Workbench use ________.

Describe the MySQL Connector/ODBC and how to install it.

The MySQL Workbench EER models are data models.

The MySQL Workbench can be used to create ________.

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

The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

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

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

Describe how to create relationships in a MySQL Workbench database design.

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