What command is used to create a user-defined exception when an error condition occurs?
A)THROW
B)HANDLE
C)RAISE
D)CREATE EXCEPTION

Question

Quizplus · Accepted Answer

The RAISE command is used to create a user-defined exception when an error condition occurs in PL/SQL. This command allows you to define your own error message and error number, which can then be handled with an exception block.

Option A, THROW, is not a valid command in PL/SQL. Option B, HANDLE, does not create a user-defined exception, but rather specifies how an existing exception should be handled. Option D, CREATE EXCEPTION, is not a valid PL/SQL command, as exceptions are automatically created when they occur or are raised with the RAISE command.

What Command Is Used to Create a User-Defined Exception When