Free 1Z0-882 Web TestEngine Demo

Q7 Single choice

Consider the statements:
Mysql> drop function foo;
ERROR 1305 (420000): FUNCTION test, foo does not exist Mysql > show warnings;

Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT;

What is the result of the final statement?

A
An empty result is returned.@msg is set to message of the warning.
B
A warning message is generated that adds error 1758 (invalid condition number) to the diagnostics area.
C
A line will be an output to the error log that contains the warning message details from the failed command.
D
An error is generated as only one condition can exist in the diagnostics area.

1Z0-882 Web TestEngine demo