Oracle
1Z0-882 · Question #39
When working with stored routines, these details are available: - The affected -rows count - The number of conditions that occurred - The condition information, such as the error code and message…
The correct answer is C. In the Diagnostics area, part, of which can be stored in user-defined or routine variables. See the full explanation below for the reasoning.
Question
When working with stored routines, these details are available:
- The affected -rows count
- The number of conditions that occurred
- The condition information, such as the error code and message
Where can you find these default?
Options
- AIn the Handler area, defined in the DECLARE handler_action HANDLER block in a stored routine
- BIn the Signal area, which is set with the help of the SIGNAL statement in a stored routine
- CIn the Diagnostics area, part, of which can be stored in user-defined or routine variables
- DIn the Error area, which can be accessed with the help of the SHOW ERRORS statement
How the community answered
(28 responses)- A18% (5)
- B7% (2)
- C71% (20)
- D4% (1)
Community Discussion
No community discussion yet for this question.