63) The MySQL command line utility is ________.
A) MySQL*Plus
B) the MySQL Command-Line Client
C) MySQL-Shell
D) MySQL-CMD
64) Which of the following statements is not true concerning the MySQL for Excel Add-In?
A) It must be installed into MySQL before importing from Excel can be performed.
B) The user must enter a password to connect to the MySQL instance.
C) The data must first be normalized before importing.
D) The user can modify some of the table characteristics before the actual data transfer.
65) 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
66) To run a single SQL command in MySQL Community Edition ________.
A) click the “Execute” button in the MySQL Workbench
B) click the “Execute SQL in Connected Server” button in the MySQL Workbench
C) click the “Execute SQL Script in Connected Server” button in the MySQL Workbench
D) click the “Execute SQL Statement under the keyboard cursor” button in the MySQL
Workbench
67) The SQL query data results are displayed ________.
A) in the Navigator window
B) in a tabbed Result Grid
C) in a Messages window
D) in a tabbed Action Output window
68) MySQL indexes can be created by using ________.
A) the MySQL Table Editor
B) the MySQL Index Editor
C) an SQL statement
D) Both A and C are correct
69) To create a MySQL index using SQL, the correct SQL statement is ________.
A) ALTER TABLE {TableName} ADD INDEX {IndexName}
B) ALTER TABLE {TableName} INSERT INDEX {IndexName}
C) CREATE INDEX {IndexName} ON TABLE {TableName}
D) Both A and C are correct
70) To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT,
________.
A) disable AUTO_INCREMENT
B) temporarily remove AUTO_INCREMENT
C) use the AUTO_INCREMENT_INSERT command
D) Both A and C are correct
71) The MySQL statement used to define a set of MySQL procedure statements is ________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) REPEAT
72) The MySQL SQL/PSM code structure defines variables with the keyword ________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) VAR
73) The MySQL SQL/PSM statement used to test for a condition and then direct which blocks of
code should be run depending on the outcome of the test is ________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) REPEAT
74) The MySQL statement used to repeat a set of SQL statements as long as some condition is
true is ________.
A) LOOP
B) BEGIN
C) IF…THEN.ELSE…END IF
D) REPEAT
75) The MySQL statement used to complete the basic SQL block structure is ________.
A) DECLARE
B) BEGIN
C) a right brace symbol }
D) END
76) The MySQL delimiter that must be used with MySQL procedures as used in this text is
________.
A) /
B) \
C) //
D) \\
77) The MySQL keyword to create a cursor is ________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FETCH
D) CLOSE {CursorName}
78) The MySQL keyword to actually start using a cursor is ________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FETCH
D) CLOSE {CursorName}
79) The MySQL keyword to close and exit a cursor is ________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FINISH {CursorName}
D) CLOSE {CursorName}
80) The MySQL keyword used to retrieve a row of data while the cursor is operating is
________.
A) DECLARE CURSOR {CursorName}
B) OPEN {CursorName}
C) FETCH
D) CLOSE {CursorName}
81) The MySQL statement to store a stored procedure in the database is ________.
A) CREATE PROCEDURE
B) ALTER PROCEDURE
C) DROP PROCEDURE
D) CLOSE PROCEDURE
82) The MySQL statement to change a stored procedure already stored in the database is
________.
A) CREATE PROCEDURE
B) ALTER PROCEDURE
C) DROP PROCEDURE
D) CLOSE PROCEDURE
83) The MySQL statement to delete a stored procedure already in the database is ________.
A) CREATE PROCEDURE
B) ALTER PROCEDURE
C) DROP PROCEDURE
D) CLOSE PROCEDURE
84) Which trigger type(s) does MySQL support?
A) BEFORE
B) AFTER
C) INSTEAD OF
D) Both A and B are correct
85) Which trigger type(s) does MySQL not support?
A) BEFORE
B) AFTER
C) INSTEAD OF
D) Both A and B are correct
86) Which transaction isolation level scope(s) is (are) available in MySQL?
A) LOCAL
B) SESSION
C) TRANSACTION
D) Both B and C are correct
87) Which transaction isolation level option(s) is (are) available in MySQL?
A) READ UNCOMMITTED
B) READ COMMITTED
C) REPEATABLE WRITE
D) Both A and B are correct
88) Which of the following set of MySQL authorizations can be specifically assigned to a user
account?
A) Administrative roles
B) Schema privileges
C) Root user equivalence
D) Both A and B are correct
89) Which schema privilege should not be specifically assigned to a user account?
A) SELECT
B) CREATE
C) GRANT
D) Both A and B are correct
90) What term does MySQL use as a synonym for backup?
A) Replica
B) Export
C) Data export
D) Data export dump
91) What is MySQL?
92) Describe how to create a new database in MySQL Community Edition.
93) Describe how to create and run an SQL query in MySQL Server Community Edition.
94) What is the MySQL Command-Line Client?
95) What is the MySQL Workbench?
96) What MySQL utility is used for DBMS administration?
97) What is the MySQL Table Editor?
98) Explain the MySQL Block Structure.
99) Explain the MySQL control-of-flow statements.
100) Explain the MySQL cursor statements.
101) Briefly explain the process for configuring MySQL for importing Excel 2016 spreadsheet
data into a SQL Server table, then discuss the import process using the MySQL for Excel Add-
In.