Oracle® PL/SQL® Interactive Workbook, Second Edition

Chapter 7 Error Handling and Built-In Exceptions

Lab 7.1 ▪ Self-Review Answers

A1:	Questions Answers Comments 1) B A compiler is able to detect only syntax errors. It cannot detect any runtime errors because they do not occur prior to the execution of the program. Furthermore, a runtime error generally occurs only on some occasions, and not the others.
A2:	Questions Answers Comments 2) B An exception-handling section is an optional section of a PL/SQL block. You will recall that only executable section is a required section of a PL/SQL block.
A3:	Questions Answers Comments 3) B
A4:	Questions Answers Comments 4) B
A5:	Questions Answers Comments 5) B, C Both options are correct. However, you should remember that the value of number 1 is ...