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

Question 1

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

Answer 1

True

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.

Answer 2

False

Question 3

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

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

Answer 3

E

Question 4

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

Question 5

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

A) Help | MySQL Workbench command
B) Help | Help Index command
C) Help | MySQL Website command
D) Help | MySQL.com Website command
E) Help | Documentation command

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

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

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

Question 9

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

Question 10

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

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

Question 11

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

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

Question 13

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

Question 14

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

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

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.

Question 18

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

Question 19

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

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

Question 20

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

Question 21

In the MySQL Workbench,a 1:N 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.

Question 22

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

Question 23

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

A) IE Crow's Foot notation
B) IDEF1X notation
C) UML notation
D) Microsoft Visio 2010 Arrow notation
E) None of the above is correct.

Question 24

In order to use MySQL Workbench to create database designs,you must log into MySQL using ________.

A) the Connect to Database dialog box
B) the Connect to MySQL Server dialog box
C) the MySQL | Connect to Server command
D) Both A and B are used together.
E) None of the above is correct - no login is required.

Question 25

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

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 26

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

Question 27

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

Question 28

The MySQL Workbench can be used to create ________.

A) data models
B) data designs
C) database models
D) database designs
E) database diagrams

Question 29

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

A) Table button
B) Entity button
C) Place a New Table button
D) Place a New Entity button
E) None of the above

Question 30

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

Question 31

The MySQL Workbench EER models are data models.

Question 32

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

Question 33

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

A) SQL ALTER TABLE
B) SQL CHANGE TABLE
C) SQL ADD CONSTRAINT
D) SQL ADD ALL
E) SQL OPEN TABLE

Question 34

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

Question 35

MySQL 5.7 Server Community Edition uses ________ authentication.

Question 36

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

Question 37

MySQL Community Server 5.7 requires the prior installation of ________.

A) the .NET Framework version 3.0
B) the .NET Framework version 3.5
C) the .NET Framework version 3.5 SP1
D) the .NET Framework version 4.5.1
E) None of the above-the .NET Framework is not required.

Question 38

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

Question 39

MySQL Community Server 5.7 uses a user account called root for the name of the default MYSQL administrator account.

Question 40

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

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

Question 41

An important reason for using MySQL Community Server 5.7 is that it has full SQL capabilities.

Question 42

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

Question 43

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

Question 44

In the MySQL Table Editor,the abbreviation NN stands for NOT NULL.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Table names are edited in the MySQL EER Component Editor.

Question 50

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.

Question 51

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.

Question 52

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

Question 53

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.

Question 54

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

Question 55

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

Question 56

How can data be inserted into a table in MySQL?

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 57

The MySQL GUI tool is replaced by ________.

A) MySQL Query Browser
B) MySQL Administrator
C) My SQL Workbench
D) MySQL for Excel
E) MySQL for Access

Question 58

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

Question 59

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

Question 60

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

Question 61

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

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 62

SQL query results are displayed in a tabbed ________ window.

Question 63

Describe how to create and run an SQL query in MySQL 5.7 Community Server Edition.

Question 64

SQL query results are displayed ________.

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 65

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

Question 66

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

Question 67

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

Question 68

SQL query results are displayed in a tabbed results window.

Question 69

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

Question 70

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

A) Result
B) Resultset
C) Script
D) Scriptset
E) Commandset

Question 71

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

Question 72

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

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