Oracle
1Z0-882 · Question #84
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…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #84. The question stem and answer options stay visible for context.
Question
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?
Options
- AAn empty result is returned.@msg is set to message of the warning.
- BA warning message is generated that adds error 1758 (invalid condition number) to the
- CA line will be an output to the error log that contains the warning message details from the failed
- DAn error is generated as only one condition can exist in the diagnostics area.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.