View the exhibit and examine the structure of the products table.
Examine the following code
Which statement is true when the procedure DELETE_DETAILS is invoked?
A. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
B. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
A is Correct
Delete statement will not return an error even if there is no product with this Id.
should be B
B is also wrong
“any error messages get recorded in the DEBUG_OUTPUT table” — not possible in this scenario, as DELETE statement doesn’t raise any exception like NO-DAT-Found etc.
A BEFORE trigger can raise an exception in which case the debugging method will be called
Answer: D
D is wrong.
RAGMA AUTONOMOUS_TRANSACTION can be used for subprograms