フリー問題

Oracle Database Program with PL/SQL のフリー問題 14 / 20 問目

問題文

A stored procedure detects that an amount breaks a rule of the business and has to report a number and a message of its own to the program that called it. Which description of the two ways of raising an exception is correct?

選択肢

  1. The statement form works in an anonymous block while the procedure form works in a block of any kind, and neither of the two can pass a number of its own to the program that made the call.
  2. The statement form and the procedure form do the same thing, so the choice between them depends on whether the exception was declared in a package or in the block that raises it.
  3. The statement form raises an exception that is already declared, and the procedure form returns an error number from the range reserved for applications together with a message of the developer.
  4. The statement form raises an exception together with a message of the developer, and the procedure form is written in the declarative part so that the message is fixed before the block starts to run.

解答・解説を確認するには

正解と解説の確認、回答の記録には無料登録が必要です。登録すると演習モードでフリー問題に回答し、正誤と解説をその場で確認できます。