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...)