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.
The answer is correct. Explanation : Till the time a number value is passed to the procedure, it will not error out as if the row gets deleted it executes successfully. Even if the row is not deleted it is the case of '0 rows' deleted and still the procedure will execute successfully.
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
pmeyer
1 year, 8 months agovobla
2 years, 6 months agoAnubhav244
4 years ago