DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

Talk about “Exception Handling” in PL/SQL?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

133. Talk about “Exception Handling” in PL/SQL?

2 types of Exception In User-defined & Pre-defined.Any Error can be Handled by Pre-defined Exception Handler (Ex. no_data_found,too_many_rows etc.)
In User-defined exception has to declare in Declaration section and any exception can be handled by that Exception name. Any types of Exception(User-defined & Pre-defined) can be Handled by When Others exception Handler.

(Continued on next question...)

Other Job Interview Questions