Which of the following statements is correct?
A) An exception that has been declared must be referred to in the RAISE statement, or a PL/SQL error will occur.
B) An exception that has not been declared must be referred to in the RAISE statement, or a PL/SQL error will occur.
C) An exception that has been declared must not be referred to in the RAISE statement, or a PL/SQL error will occur.
D) An exception that has been declared must be referred to in the SELECT statement, or a PL/SQL error will occur.

Question

Quizplus · Accepted Answer

When an exception is declared, it must be referred to in the RAISE statement to be able to handle the exception properly. If the exception is not referred to, a PL/SQL error will occur. Therefore, option A is the correct statement. Option B is incorrect as declaring an exception means it has already been defined and can be referred to. Option C is incorrect as not referring to an exception in the RAISE statement will result in unhandled exceptions. Option D is also incorrect as exceptions are not related to SELECT statements.

Which of the Following Statements Is Correct