Question 1

Which trigger types does MySQL support?

Accepted Answer

A)  BEFORE
B)  AFTER
C)  INSTEAD OF
D)  A and B
E)  A,B and CF) All of the above
G) A) and B)

Question 2

To create a MySQL index using SQL,the correct SQL statement is:

Accepted Answer

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 CF) D) and E)
G) A) and D)

Question 3

DBMS objects are displayed:

Accepted Answer

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.F) C) and E)
G) A) and E)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What is the MySQL Table Editor?

Accepted Answer

The MySQL Table Editor is a GUI administ...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

MySQL Workbench is the MySQL GUI database administration utility.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

MySQL databases are backed up using the MySQL Backup System.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

MySQL Community Edition uses operating system authentication.

Accepted Answer

A) True 
 B)False

Question 14

A new MySQL database is created using:

Accepted Answer

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.F) All of the above
G) C) and E)

Question 15

Which schema privilege should not be specifically assigned to a user account?

Accepted Answer

A)  SELECT
B)  CREATE
C)  GRANT
D)  A and B
E)  A,B and CF) C) and D)
G) B) and E)

Question 16

The MySQL statement to change a stored procedure already stored in the database is:

Accepted Answer

A)  CREATE PROCEDURE.
B)  ALTER PROCEDURE.
C)  DROP PROCEDURE.
D)  CLOSE PROCEDURE.
E)  None of the above.F) B) and E)
G) A) and B)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is the MySQL Workbench?

Accepted Answer

The MySQL Workbench is the GUI tool that...

Question 20

The MySQL block structure defines variables with the keyword:

Accepted Answer

A)  DECLARE.
B)  BEGIN.
C)  IF...THEN...ELSE...END IF.
D)  REPEAT.
E)  END.F) All of the above
G) A) and E)

Exam 12: Managing Databases With MySQL 55

A new MySQL database is created using:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To create a MySQL index using SQL,the correct SQL statement is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the MySQL Workbench?

Correct AnswerverifiedThe MySQL Workbench is the GUI tool that...View AnswerShow Answer

The MySQL block structure defines variables with the keyword:

Correct AnswerverifiedShow Answer

MySQL Workbench is the MySQL GUI database administration utility.

Correct AnswerverifiedShow Answer

MySQL Community Edition uses operating system authentication.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which trigger types does MySQL support?

Correct AnswerverifiedShow Answer

The MySQL statement to change a stored procedure already stored in the database is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

DBMS objects are displayed:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which schema privilege should not be specifically assigned to a user account?

Correct AnswerverifiedShow Answer

MySQL databases are backed up using the MySQL Backup System.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the MySQL Table Editor?

Correct AnswerverifiedThe MySQL Table Editor is a GUI administ...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The MySQL Workbench is the GUI tool that...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The MySQL Table Editor is a GUI administ...
View Answer