Deck 12: Managing Databases With Mysql 5.6

Question 1

MySQL is an open source DBMS that only runs on Unix and Linux operating systems.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

To display an existing SQL script,click the "Open an SQL script file (in new query tab)" button.

Question 5

Database objects are displayed in the Object Explorer window in the MySQL Workbench.

Question 6

For use with this book,it is recommended that MySQL be configured as a developer machine.

Question 7

MySQL Workbench is the MySQL GUI database administration utility.

Question 8

Schema is the MySQL synonym for database.

Question 9

The MySQL Table Editor is accessible from the MySQL Workbench.

Question 10

SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Question 11

Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

Question 12

Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

Question 13

MySQL Community Edition uses only operating system authentication.

Question 14

The MySQL Workbench is included in the MySQL Server Community Edition installation.

Question 15

The spreadsheet data must first be highlighted (selected)in order to be imported using the MySQL for Excel Add-In.

Question 16

MySQL Workbench is the MySQL GUI application development utility.

Question 17

It is recommended that MySQL be used with the InnoDB storage engine.

Question 18

MySQL is configured using the MySQL Server Instance Configuration Wizard.

Question 19

To run an SQL script,click the "Execute SQL Script (or selected portion)" button on the MySQL Workbench.

Question 20

The MySQL Command Line Client is the MySQL command line utility.

Question 21

To execute an SQL query,click the "Execute the selected portion of the script or everything,if there is no selection" button.

Question 22

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.

Question 23

MySQL uses the MySQL CALL statement to run a stored procedure.

Question 24

Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.

Question 25

MySQL uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

Question 26

The MySQL block structure defines variables with the BEGIN keyword.

Question 27

MySQL supports INSTEAD OF triggers.

Question 28

MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.

Question 29

The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.

Question 30

MySQL supports BEFORE triggers.

Question 31

The MySQL statement BEGIN is used to define a set of MySQL procedure statements.

Question 32

MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row.

Question 33

MySQL uses the MySQL TODAYS_DATE()function to provide the value of the current date.

Question 34

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.

Question 35

MySQL supports AFTER triggers.

Question 36

The MySQL END statement is used to complete the basic SQL block structure.

Question 37

MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row.

Question 38

The default transaction isolation level in MySQL is REPEATABLE READ.

Question 39

In MySQL,surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Question 40

MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED,READ COMMITTED,REPEATABLE READ,and SERIALIZABLE.

Question 41

MySQL databases are backed up using the MySQL Backup System.

Question 42

The MySQL Installer for Windows requires the ________ operating system.

A)Suse Linux
B)Red Hat Linux
C)Android
D)Microsoft Windows

Question 43

MySQL users are granted MySQL privileges for specific schemas only.

Question 44

The MySQL Workbench is the main utility used to implement MySQL security.

Question 45

MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL,LOCAL,SESSION and TRANSACTION.

Question 46

The main MySQL GUI utility is ________.

A)MySQL Management Studio
B)MySQL Developer
C)My SQL Workbench
D)Both A and B are correct

Question 47

The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.

Question 48

MySQL users should always be given the GRANT OPTION for each schema.

Question 49

MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

Question 50

MySQL backups are run on the Administration - Data Export tab of the Data Export page.

Question 51

MySQL users may be granted MySQL server administrative roles.

Question 52

When MySQL Server Administration is opened in the MySQL Workbench,the Startup/Shutdown page is initially displayed.

Question 53

A MySQL data backup is accomplished by using the "Data Export" feature.

Question 54

The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user.

Question 55

MySQL uses the term data export dump as a synonym for backup.

Question 56

MySQL users are created on the Users and Privileges page in the MySQL Workbench.

Question 57

MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

Question 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

Question 59

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

Question 60

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

Question 61

The MySQL keyword to close and exit a cursor is ________.

A)DECLARE CURSOR {CursorName}
B)OPEN {CursorName}
C)FINISH {CursorName}
D)CLOSE {CursorName}

Question 62

The MySQL statement used to complete the basic SQL block structure is ________.

A)DECLARE
B)BEGIN
C)a right brace symbol }
D)END

Question 63

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

Question 64

The MySQL command line utility is ________.

A)MySQL*Plus
B)the MySQL Command-Line Client
C)MySQL-Shell
D)MySQL-CMD

Question 65

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

Question 66

The MySQL keyword to create a cursor is ________.

A)DECLARE CURSOR {CursorName}
B)OPEN {CursorName}
C)FETCH
D)CLOSE {CursorName}

Question 67

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

Question 68

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}

Question 69

The MySQL delimiter that must be used with MySQL procedures as used in this text is ________.

A)/
B)\
C)//
D)\\

Question 70

The MySQL SQL/PSM code structure defines variables with the keyword ________.

A)DECLARE
B)BEGIN
C)IF...THEN...ELSE...END IF
D)VAR

Question 71

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.

Question 72

The MySQL keyword to actually start using a cursor is ________.

A)DECLARE CURSOR {CursorName}
B)OPEN {CursorName}
C)FETCH
D)CLOSE {CursorName}

Question 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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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