978-0134601533 Appendix C

Database Concepts, 8e (Kroenke)

Appendix C Getting Started with MySQL 5.7 Community Server

1) Users log into MySQL Workbench using the Connect to MySQL Server dialog box.

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

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

4) Users should create a MySQL Workspace folder to hold documents created with the MySQL

Workbench.

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

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

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

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

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

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

A) PK

B) NN

C) UQ

D) BIN

E) AI

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

A) PK

B) NN

C) UQ

D) BIN

E) AI

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

A) PK

B) NN

C) UQ

D) BIN

E) AI

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

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

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

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

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

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

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

20) Users should create an EER Models folder to hold EER models created with the MySQL

Workbench.

21) The MySQL Workbench EER models are data models.

22) To create a new MySQL Workbench EER model, you can use the New Model button on the

Home page.

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

command.

24) The MySQL Workbench can be used to create ________.

A) data models

B) data designs

C) database models

D) database designs

E) database diagrams

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.

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

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

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

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

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

31) MySQL Community Server 5.7 uses a user account called root for the name of the default

MYSQL administrator account.

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

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

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

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

36) MySQL ________ (version) Community Server Edition was generally available when this

text was written.

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

38) MySQL 5.7 Server Community Edition uses ________ authentication.

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

40) The MySQL Workbench is included in the MySQL Community Server 5.7 installation when

the MySQL Installer for Windows is used.

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

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

43) In addition to downloading MySQL Community Server and the MySQL Workbench, it is

recommended that the ________ also be downloaded.

44) Downloading and installing the MySQL connector/ODBC means that the ________ (name

and version) driver will be available in the ODBC Data Source Administrator.

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

46) An important reason for using MySQL Community Server 5.7 is that it has full SQL

capabilities.

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

48) Table names are edited in the MySQL EER Component Editor.

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

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

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

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

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.

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

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

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

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

58) SQL statements can be run individually or as part of a related group of SQL statements

known as a script.

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

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

61) SQL query results are displayed in a tabbed results window.

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

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

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

65) SQL statements can be run individually or as part of a related group of SQL statements

known as a(n) ________.

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

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

68) SQL query results are displayed in a tabbed ________ window.

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

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

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

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