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

In exception handling we have some NOT_FOUND and

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

(Continued from previous question...)

119. In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?

Once you got inside the OUTER_LOOP, it comes out only after the NOTFOUND statement.

So OUTER_LOOP will be valuated first.Its similar to ‘C’ language, first OUTER_LOOP will valuated followed by an INNER_LOOP.

(Continued on next question...)

Other Job Interview Questions