Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The MySQL command line utility is:

Accepted Answer

A)  MySQL*Plus.
B)  the MySQL Command-Line Client.
C)  MySQL-Shell.
D)  MySQL-CMD.
E)  None of the above is correct.F) All of the above
G) A) and B)

Question 4

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) D) and E)
G) None of the above

Question 5

The MySQL GUI tool(s) used for database administration and management is(are) :

Accepted Answer

A)  MySQL Workbench.
B)  MySQL*Plus.
C)  MySQL Command Shell.
D)  A and B
E)  A,B,and CF) B) and D)
G) A) and B)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

MySQL Community Edition uses operating system authentication.

Accepted Answer

A) True 
 B)False

Question 8

Which transaction isolation level scope(s) is (are) available in MySQL?

Accepted Answer

A)  GLOBAL
B)  SESSION
C)  TRANSACTION
D)  A and B
E)  A,B,and CF) A) and B)
G) All of the above

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

Explain the MySQL control-of-flow statements.

Accepted Answer

The MySQL control-of-flow statements are...

Question 12

To run a single SQL command in MySQL Community Edition:

Accepted Answer

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

Question 13

MySQL supports AFTER triggers.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The MySQL keyword to close and exit a cursor is:

Accepted Answer

A)  DECLARE CURSOR {CursorName}.
B)  OPEN {CursorName}.
C)  FETCH.
D)  CLOSE {CursorName}.
E)  None of the above.F) C) and D)
G) None of the above

Question 16

Logging into the MySQL DBMS is done using:

Accepted Answer

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.F) B) and E)
G) B) and D)

Question 17

The MySQL Installer for Windows requires the ________ operating system.

Accepted Answer

A)  Suse Linux
B)  Red Hat Linux
C)  FreeBSD
D)  Microsoft Windows
E)  Any of the aboveF) All of the above
G) A) and B)

Question 18

The main MySQL GUI utility is:

Accepted Answer

A)  MySQL Management Studio.
B)  MySQL Developer.
C)  My SQL Workbench.
D)  A and B
E)  A,B,and CF) B) and D)
G) C) and D)

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The MySQL keyword to actually start using a cursor is:

Accepted Answer

A)  DECLARE CURSOR {CursorName}.
B)  OPEN {CursorName}.
C)  FETCH.
D)  CLOSE {CursorName}.
E)  None of the above.F) B) and E)
G) None of the above

Exam 10: C: Managing Databases With MySQL

MySQL Community Edition uses operating system authentication.

Correct AnswerverifiedShow Answer

To run a single SQL command in MySQL Community Edition:

Correct AnswerverifiedShow Answer

Which transaction isolation level scope(s) is (are) available in MySQL?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The MySQL command line utility is:

Correct AnswerverifiedShow Answer

The MySQL keyword to close and exit a cursor is:

Correct AnswerverifiedShow Answer

The MySQL Installer for Windows requires the ________ operating system.

Correct AnswerverifiedShow Answer

The MySQL GUI tool(s) used for database administration and management is(are) :

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Logging into the MySQL DBMS is done using:

Correct AnswerverifiedShow Answer

The main MySQL GUI utility is:

Correct AnswerverifiedShow Answer

The MySQL block structure defines variables with the keyword:

Correct AnswerverifiedShow Answer

MySQL supports AFTER triggers.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain the MySQL control-of-flow statements.

Correct AnswerverifiedThe MySQL control-of-flow statements are...View AnswerShow Answer

The MySQL keyword to actually start using a cursor is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The MySQL control-of-flow statements are...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified