Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
