Lab 11.3 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	The SQLCODE function returns an Oracle error number. _____ True _____ False
2)	The SQLERRM function returns the error text corresponding to a specific error number. _____ True _____ False
3)	When the SQLERRM function cannot return an error message corresponding to a particular error number, which of the following occurs? _____ SQLERRM causes an error. _____ SQLERRM does not return anything. _____ SQLERRM returns "non-ORACLE exception" message.
4)	What is the maximum length of the error text returned by the SQLERRM function? _____ 450 bytes _____ 550 bytes _____ 512 bytes
5)	The SQLCODE function always returns a negative number. _____ True _____ False

Answers appear in Appendix A, Section 11.3 .