Database Processing, 15e (Kroenke)
Online Chapter 10C: Managing Databases with MySQL 5.7
1) MySQL is an open source DBMS that only runs on Unix and Linux operating systems.
2) Microsoft Windows users should install MySQL Community Edition using the MySQL
Installer for Windows.
3) The MySQL Workbench is included in the MySQL Server Community Edition installation.
4) MySQL is configured using the MySQL Server Instance Configuration Wizard.
5) For use with this book, it is recommended that MySQL be configured as a developer machine.
6) The spreadsheet data must first be highlighted (selected) to be imported using the MySQL for
Excel Add-In.
7) It is recommended that MySQL be used with the InnoDB storage engine.
8) To start working with MySQL Community Edition in Windows, use the command Start | All
Programs | MySQL | MySQL Workbench CE 6.2. (or the version number you have installed).
9) Users log into MySQL Workbench using the Connect to Database and Connect to MySQL
Server dialog boxes.
10) MySQL Community Edition uses only operating system authentication.
11) Schema is the MySQL synonym for database.
12) Database objects are displayed in the Object Explorer window in the MySQL Workbench.
13) A new MySQL database is created using the New Database dialog box.
14) The MySQL Command Line Client is the MySQL command line utility.
15) MySQL Workbench is the MySQL GUI application development utility.
16) MySQL Workbench is the MySQL GUI database administration utility.
17) The MySQL Table Editor is accessible from the MySQL Workbench.
18) SQL statements can be run individually or as part of a related group of SQL statements
known as a script.
19) To run an SQL script, click the “Execute SQL Script (or selected portion)” button on the
MySQL Workbench.
20) To display an existing SQL script, click the “Open an SQL script file (in new query tab)”
button.
21) In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data
type of IDENTITY.
22) MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.
23) To execute an SQL query, click the “Execute the selected portion of the script or everything,
if there is no selection” button.
24) The MySQL statement BEGIN is used to define a set of MySQL procedure statements.
25) The MySQL block structure defines variables with the BEGIN keyword.
26) The MySQL IF statement is used to test for a condition and then direct which blocks of code
should be run depending on the outcome of the test.
27) The MySQL LOOP statement is used to repeat a set of SQL statements as long as some
condition is true.
28) The MySQL END statement is used to complete the basic SQL block structure.
29) MySQL supports BEFORE triggers.
30) MySQL supports AFTER triggers.
31) MySQL supports INSTEAD OF triggers.
32) MySQL uses the MySQL LAST_INSERT_ID() function to provide the value of the most
recently created surrogate key.
33) MySQL uses the MySQL CALL statement to run a stored procedure.
34) MySQL uses the MySQL TODAYS_DATE() function to provide the value of the current
date.
35) MySQL uses MySQL NEW transition variables with triggers to access new data inserted into
a table row.
36) MySQL uses MySQL OLD transition variables with triggers to access old data updated or
deleted from a table row.
37) MySQL uses the “Safe Updates”—Forbid UPDATE and DELETE statements with no key in
WHERE clause or no LIMIT clause—checkbox to control the behavior of UPDATE and
DELETE statements run from the MySQL Workbench.
38) Triggers that have been created in MySQL are displayed as objects in the Object Browser of
the MySQL Workbench.
39) MySQL concurrency options include four transaction isolation levels: READ
UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.
40) The default transaction isolation level in MySQL is REPEATABLE READ.
41) MySQL concurrency options include four scopes for the transaction isolation level:
GLOBAL, LOCAL, SESSION and TRANSACTION.
42) The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE}
TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.
43) The MySQL Workbench is the main utility used to implement MySQL security.
44) When MySQL Server Administration is opened in the MySQL Workbench, the
Startup/Shutdown page is initially displayed.
45) MySQL users are created on the Users and Privileges page in the MySQL Workbench.
46) MySQL users are granted MySQL privileges for specific schemas only.
47) MySQL users may be granted MySQL server administrative roles.
48) MySQL users must be granted the right to have MySQL schema privileges before the
specific privileges themselves are granted.
49) The MySQL Schema Privileges Select “ALL” button marks all MySQL privileges for
assignment to the user.
50) MySQL users should always be given the GRANT OPTION for each schema.
51) MySQL databases are backed up using the MySQL Backup System.
52) MySQL uses the term data export dump as a synonym for backup.
53) MySQL backups are run on the Administration – Data Export tab of the Data Export page.
54) A MySQL data backup is accomplished by using the “Data Export” feature.
55) MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.
56) The MySQL Installer for Windows requires the ________ operating system.
A) Suse Linux
B) Red Hat Linux
C) Android
D) Microsoft Windows
57) The main MySQL GUI utility is ________.
A) MySQL Management Studio
B) MySQL Developer
C) My SQL Workbench
D) Both A and B are correct
58) Which of the following MySQL configuration settings are recommended for use with this
book?
A) Developer machine
B) Multifunction machine
C) Decision Support (DSS)/OLAP
D) Custom setup that only installs the needed components
59) Logging into the MySQL DBMS is done using ________.
A) the Connect to Server command
B) the Connect to Server dialog box
C) the Local instance MySQL56 command
D) the Local instance MySQL56 dialog box
60) DBMS objects are displayed ________.
A) in the Navigation Pane
B) in the Object Browser
C) in the tabbed database window
D) in the tabbed document window
61) A new MySQL database is created using ________.
A) the New Database dialog tab
B) the Create Database command
C) the new_schema dialog tab
D) the Create Schema command
62) The active MySQL database is specified using ________.
A) the Set Schema command
B) the Set Database command
C) the Make Default Schema command
D) the Set as Default Schema command