Deck 11: Getting Started With Mysql 5.6 Community Server

Question 1

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 1

False

Question 2

SQL query results are displayed in a tabbed results window.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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 11

Table names are edited in the MySQL EER Component Editor.

Question 12

To start working with MySQL Server Community Edition in Windows 8.1,use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

MySQL Community Server 5.6 uses DBMS authentication.

Question 19

The MySQL Workbench EER models are data models.

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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 26

Logging into the MySQL Community Server 5.6 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 27

MySQL Community Server 5.6 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 28

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 29

The MySQL Workbench can be used to create:

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

Question 30

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

Question 31

The authors recommend using which of the following folder structures with the MySQL Workbench?

A)..\MyDocuments\MySQL Workbench
B)..\MyDocuments\MySQL Workbench\Schemas
C)..\MyDocuments\MySQL Workbench\EER Models
D)Both A and B
E)All of the above

Question 32

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 33

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 34

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 35

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

Question 36

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

Question 37

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)A or B
E)All of the above

Question 38

The MySQL GUI tool is replaced by:

A)MySQL Query Browser.
B)MySQL Administrator.
C)My SQL Workbench.
D)Both A and B
E)All of the above

Question 39

By default,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 40

DBMS objects are displayed:

A)in the Navigator Pane.
B)in the Object Browser.
C)in the tabbed database window.
D)in the tabbed document window.
E)in the command tab.

Question 41

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

Question 42

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 43

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

Question 44

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

Question 45

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

Question 46

MySQL 5.6 Server Community Edition uses ________ authentication.

Question 47

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

Question 48

In the MySQL Table Editor,the abbreviation for NOT NULL is:

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

Question 49

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

Question 50

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

Question 51

In the MySQL Table Editor,the abbreviation for Primary Key is:

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

Question 52

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 53

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

Question 54

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 55

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

Question 56

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 57

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 58

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

Question 59

In the MySQL Table Editor,the abbreviation for AUTO_INCREMENT is:

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

Question 60

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

Question 61

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

Question 62

SQL query results are displayed in a tabbed ________ window.

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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