Oracle
1Z0-882 · Question #84
1Z0-882 Question #84: Real Exam Question with Answer & Explanation
The correct answer is B. A warning message is generated that adds error 1758 (invalid condition number) to the. See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.