Deck 12: Managing Databases With MySQL 55

Question 1

MySQL Community Edition requires that the .NET Framework version 2.0 be installed.

Answer 1

False

Question 2

To run an SQL script,click the Execute SQL Script in Connected Server button on the MySQL Workbench.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

MySQL Community Edition uses operating system authentication.

Question 6

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

Question 7

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

Question 8

The MySQL Table Editor is accessible from the MySQL Workbench.

Question 9

It is recommend that MySQL be used with InnoDB storage engine.

Question 10

For use with this book,it is recommend that MySQL be configured as a Decision Support (DSS)/OLAP machine.

Question 11

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

Question 12

MySQL is configured using the MySQL Server Instance Configuration Wizard.

Question 13

To start working with MySQL Community Edition use the command Start | All Programs | MySQL | MySQL Workbench CE 5.2.

Question 14

To run an SQL script,click the Execute button on the Query Toolbar.

Question 15

MySQL Workbench is the MySQL GUI application development utility.

Question 16

MySQL Workbench is the MySQL GUI database administration utility.

Question 17

Schema is the MySQL synonym for database.

Question 18

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

Question 19

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

Question 20

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

Question 21

The MySQL block structure defines variables with the BEGIN keyword.

Question 22

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

Question 23

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

Question 24

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

Question 25

MySQL supports INSTEAD OF triggers.

Question 26

The default transaction isolation level in MySQL is REPEATABLE READ.

Question 27

MySQL supports AFTER triggers.

Question 28

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

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 uses the MySQL LAST_INSERT_ID()function to provide the value of the most recently created surrogate key.

Question 31

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

Question 32

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

Question 33

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

Question 34

MySQL supports BEFORE triggers.

Question 35

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.

Question 36

To execute an SQL query,click the Execute Current SQL Statement in Connected Server button.

Question 37

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

Question 38

MySQL uses the Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)checkbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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.

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

MySQL backups are run on the Export to Disk tab of the Data Export and Restore page.

Question 49

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

Question 50

The MySQL Installer for Windows requires the prior installation of:

A)the .NET Framework version 2.0.
B)the .NET Framework version 3.0.
C)the .NET Framework version 3.5 SP1.
D)the .NET Framework version 4.0.
E)None of the above - the .NET Framework is not required.

Question 51

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.

Question 52

MySQL backups that contain the entire database are run using the Export to Self-Contained File option.

Question 53

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

Question 54

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

Question 55

MySQL users are granted MySQL privileges for specific schemas only.

Question 56

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

Question 57

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

Question 58

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

Question 59

MySQL databases are backed up using the MySQL Backup System.

Question 60

MySQL users may be granted MySQL server administrative roles.

Question 61

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.

Question 62

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.

Question 63

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

Question 64

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.

Question 65

The MySQL block structure defines variables with the keyword:

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

Question 66

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.

Question 67

A default 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.

Question 68

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.

Question 69

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.

Question 70

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.

Question 71

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.

Question 72

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.

Question 73

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.

Question 74

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.

Question 75

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

Question 76

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.

Question 77

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

Question 78

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.

Question 79

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)A or C
E)B or C

Question 80

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.