Question 1

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

Accepted Answer

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

Question 2

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.

Accepted Answer

MySQL Workbench has a "Safe Updates" checkbox that forbids UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clause in order to prevent unintentional deletion or modification of large sets of data.

Question 3

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

Accepted Answer

MySQL does use the CALL statement to execute stored procedures.

Question 4

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

Accepted Answer

The answer of Triggers that have been created in MySQL...

Question 5

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

Accepted Answer

The MySQL LAST_INSERT_ID() function returns the value of the most recently created surrogate key, making statement A true.

Question 6

The MySQL block structure defines variables with the BEGIN keyword.

Accepted Answer

The MySQL block structure starts with the BEGIN keyword but it is used to start a compound statement block, not specifically to define variables. Variables are defined using the DECLARE keyword within a BEGIN ... END block.

Question 7

MySQL supports INSTEAD OF triggers.

Accepted Answer

MySQL supports BEFORE and AFTER triggers but does not support INSTEAD OF triggers, which are typically found in other database systems like SQL Server and Oracle.

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

The MySQL LOOP statement is used to repeat a set of SQL statements until a specific condition is met, not while a condition is true.

Question 10

MySQL supports BEFORE triggers.

Accepted Answer

MySQL does support BEFORE triggers, which are executed before the INSERT, UPDATE or DELETE statement is executed on a table. These triggers can be used to validate data, enforce constraints or perform other operations before the actual statement is executed.

Question 11

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

Accepted Answer

The BEGIN statement is used to begin a transaction for a set of MySQL statements, not to define a set of procedure statements.

Question 12

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

Accepted Answer

MySQL triggers support the use of NEW and OLD transition variables, which are used to access new and old data values in a table row. This allows for more sophisticated trigger logic and data manipulation.

Question 13

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

Accepted Answer

MySQL does not have a TODAYS_DATE() function. Instead, the function to get the current date is CURDATE().

Question 14

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.

Accepted Answer

The MySQL IF statement is indeed used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test.

Question 15

MySQL supports AFTER triggers.

Accepted Answer

MySQL does support AFTER triggers, which are executed after the operation which triggers them has completed.

Question 16

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

Accepted Answer

The END statement is used to complete the basic SQL block structure, such as in stored procedures and functions.

Question 17

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

Accepted Answer

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

Question 18

The default transaction isolation level in MySQL is REPEATABLE READ.

Accepted Answer

The default transaction isolation level in MySQL is REPEATABLE READ.

Question 19

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

Accepted Answer

MySQL does not have a data type of IDENTITY. The equivalent data type in MySQL is AUTO_INCREMENT. Therefore, surrogate keys that use a sequence maintained by MySQL should be given a data type of AUTO_INCREMENT.

Question 20

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

Accepted Answer

MySQL supports four isolation levels for transactions, which are READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

Quiz 12: Managing Databases With Mysql 5.6

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

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.

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

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

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

The MySQL block structure defines variables with the BEGIN keyword.

MySQL supports INSTEAD OF triggers.

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

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

MySQL supports BEFORE triggers.

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

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

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

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.

MySQL supports AFTER triggers.

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

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

The default transaction isolation level in MySQL is REPEATABLE READ.

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

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