Managing Databases with MySQL (10C)
The MySQL GUI tool(s) used for database administration and management is (are): A) MySQL Workbench. B) MySQL*Plus. C) MySQL Command Shell. D) A and B E) A, B, and C
A
The MySQL block structure defines variables with the keyword: A) DECLARE. B) BEGIN. C) IF...THEN...ELSE...END IF. D) REPEAT. E) END.
A
The MySQL keyword to create a cursor is: A) DECLARE CURSOR {CursorName}. B) OPEN {CursorName}. C) FETCH. D) CLOSE {CursorName}. E) None of the above.
A
The MySQL statement to store a stored procedure in the database is: A) CREATE PROCEDURE. B) ALTER PROCEDURE. C) DROP PROCEDURE. D) CLOSE PROCEDURE. E) None of the above.
A
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) A or C E) B or C
A
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. E) in the command tab.
B
The MySQL command line utility is: A) MySQL*Plus. B) the MySQL Command-Line Client. C) MySQL-Shell. D) MySQL-CMD. E) None of the above is correct.
B
The MySQL keyword to actually start using a cursor is: A) DECLARE CURSOR {CursorName}. B) OPEN {CursorName}. C) FETCH. D) CLOSE {CursorName}. E) None of the above.
B
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. E) None of the above.
B
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. E) END.
B
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) Disable AUTO_INCREMENT or Use the AUTO_INCREMENT_INSERT command. E) Temporarily remove AUTO_INCREMENT or Use the AUTO_INCREMENT_INSERT command.
B
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.
C
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) command set.
C
The MySQL delimiter that must be used with MySQL procedures as used in this text is: A) /. B) \. C) //. D) \\. E) None of the above.
C
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}. E) None of the above.
C
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. E) None of the above.
C
The MySQL statement used to test for a condition and then direct when 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. E) END.
C
The main MySQL GUI utility is: A) MySQL Management Studio. B) MySQL Developer. C) My SQL Workbench. D) A and B E) A, B, and C
C
Which schema privilege should not be specifically assigned to a user account? A) SELECT B) CREATE C) GRANT D) A and B E) A, B, and C
C
Which trigger type(s) does MySQL not support? A) BEFORE B) AFTER C) INSTEAD OF D) A and B E) A, B, and C
C
Logging into the MySQL DBMS is done using: A) the Connect to Server command. B) the Connect to Server dialog box. C) the Connect to MySQL Server Instance command. D) the Connect to MySQL Server Instance dialog box. E) None of the above is correct.
D
MySQL indexes can be created by using: A) the MySQL Table Editor. B) the MySQL Index Editor. C) an SQL statement. D) A and C E) B and C
D
The MySQL Installer for Windows requires the ________ operating system. A) Suse Linux B) Red Hat Linux C) FreeBSD D) Microsoft Windows E) Any of the above
D
The MySQL keyword to close and exit a cursor is: A) DECLARE CURSOR {CursorName}. B) OPEN {CursorName}. C) FETCH. D) CLOSE {CursorName}. E) None of the above.
D
The MySQL statement used to repeat a set of SQL statements as long as some condition is true is: A) DECLARE. B) BEGIN. C) IF...THEN.ELSE...END IF. D) REPEAT. E) END.
D
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. E) the Set Schema dialog box.
D
What term does MySQL use as a synonym for backup ? A) Replica B) Export C) Data export D) Data export dump E) None of the above.
D
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) A and B E) A, B, and C
D
Which trigger type(s) does MySQL support? A) BEFORE B) AFTER C) INSTEAD OF D) A and B E) A, B, and C
D
SQL query results are displayed: A) in a tabbed Resultset window. B) in a tabbed Results window. C) in a tabbed Document window. D) in a tabbed Messages window. E) in a tabbed results window named the same as the window with the SQL code.
E
The MySQL statement used to complete the basic SQL block structure is: A) DECLARE. B) BEGIN. C) IF...THEN...ELSE...END IF. D) LOOP. E) END.
E
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 in Connected Server button in the MySQL Workbench. E) click the Execute Current SQL Statement in Connected Server button in the MySQL Workbench.
E
Which of the following MySQL configuration settings are recommend for use with this book? A) Developer machine B) Multifunction machine C) Decision Support (DSS)/OLAP D) A and B E) A, B, and C
E
Which transaction isolation level option(s) is (are) available in MySQL? A) READ UNCOMMITTED B) READ COMMITTED C) REPEATABLE READ D) A and B E) A, B, and C
E
Which transaction isolation level scope(s) is (are) available in MySQL? A) GLOBAL B) SESSION C) TRANSACTION D) A and B E) A, B, and C
E
A new MySQL database is created using the New Database dialog box.
FALSE
In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.
FALSE
MySQL Community Edition uses operating system authentication.
FALSE
MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL, LOCAL, SESSION and TRANSACTION.
FALSE
MySQL databases are backed up using the MySQL Backup System.
FALSE
MySQL is an open source DBMS that only runs on Unix and Linux operating systems.
FALSE
MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.
FALSE
MySQL supports INSTEAD OF triggers.
FALSE
MySQL users are granted MySQL privileges for specific schemas only.
FALSE
MySQL users should always be given the GRANT OPTION for each schema.
FALSE
MySQL uses the MySQL TODAYS_DATE() function to provide the value of the current date.
FALSE
The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.
FALSE
The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user.
FALSE
The MySQL Workbench is included in the MySQL Server Community Edition installation.
FALSE
The MySQL block structure defines variables with the BEGIN keyword.
FALSE
To run an SQL script, click the Execute button on the Query Toolbar.
FALSE
Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.
FALSE
When MySQL Server Administration is opened in the MySQL Workbench, the Startup/Shutdown page is initially displayed.
FALSE
Database objects are displayed in the Object Explorer window in the MySQL Workbench.
TRUE
For use with this book, it is recommended that MySQL be configured as a Decision Support (DSS)/OLAP machine.
TRUE
For use with this book, it is recommended that MySQL be configured as a developer machine.
TRUE
It is recommended that MySQL be used with the InnoDB storage engine.
TRUE
Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.
TRUE
MySQL Workbench is the MySQL GUI application development utility.
TRUE
MySQL Workbench is the MySQL GUI database administration utility.
TRUE
MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.
TRUE
MySQL backups that contain the entire database are run using the Export to Self-Contained File option.
TRUE
MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.
TRUE
MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.
TRUE
MySQL is configured using the MySQL Server Instance Configuration Wizard.
TRUE
MySQL supports AFTER triggers.
TRUE
MySQL supports BEFORE triggers.
TRUE
MySQL users are created on the Users and Privileges page in the MySQL Workbench.
TRUE
MySQL users may be granted MySQL server administrative roles.
TRUE
MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.
TRUE
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.
TRUE
MySQL uses the MySQL CALL statement to run a stored procedure.
TRUE
MySQL uses the MySQL LAST_INSERT_ID() function to provide the value of the most recently created surrogate key.
TRUE
MySQL uses the MySQL NEW transition variable with triggers to access new data inserted into a table row.
TRUE
MySQL uses the MySQL OLD transition variable with triggers to access old data updated or deleted from a table row.
TRUE
MySQL uses the term data export dump as a synonym for backup.
TRUE
SQL statements can be run individually or as part of a related group of SQL statements known as a script.
TRUE
Schema is the MySQL synonym for database.
TRUE
The MySQL Command Line Client is the MySQL command line utility.
TRUE
The MySQL END statement is used to complete the basic SQL block structure.
TRUE
The MySQL IF statement is used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test.
TRUE
The MySQL Table Editor is accessible from the MySQL Workbench.
TRUE
The MySQL Workbench is the main utility used to implement MySQL security.
TRUE
The MySQL statement BEGIN is used to define a set of MySQL procedure statements.
TRUE
The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.
TRUE
The default transaction isolation level in MySQL is REPEATABLE READ.
TRUE
To execute an SQL query, click the Execute Current SQL Statement in Connected Server button.
TRUE
To run an SQL script, click the Execute SQL Script in Connected Server button on the MySQL Workbench.
TRUE
To start working with MySQL Community Edition, use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.
TRUE
Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.
TRUE