Deck 11: Getting Started With Mysql 56 Community Server

Question 1

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

Answer 1

False

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

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.

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

The MySQL Workbench EER models are data models.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

SQL query results are displayed in a tabbed results window.

Question 16

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

Question 17

Table names are edited in the MySQL EER Component Editor.

Question 18

MySQL Community Server 5.6 uses DBMS authentication.

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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 26

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 27

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

Question 28

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 29

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 30

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 31

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 32

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

Question 33

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 34

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 35

The MySQL Workbench can be used to create:

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

Question 36

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 37

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 38

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 39

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 40

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

Question 41

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 42

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

Question 43

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

Question 44

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

Question 45

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

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

Question 46

MySQL 5.6 Server Community Edition uses ________ authentication.

Question 47

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 48

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

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

Question 49

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

Question 50

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

Question 51

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 52

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

Question 53

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

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

Question 54

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

Question 55

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

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

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

Question 58

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 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

SQL query results are displayed in a tabbed ________ window.

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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