Lab 16.1 Self-Review Questions

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

1)	What is the purpose of the USER_ERRORS view? _____ It prevents you from having to make use of the SHO ERR command. _____ It has the details on database objects in an invalid state. _____ It is a record of all compilation errors you have ever made. _____ It has no purpose but to take up database space.
2)	The DESC command behaves like an overloaded procedure. _____ True _____ False
3)	All functions require a pragma restriction to be used in an SQL statement. _____ True _____ False
4)	What does the purity level of a pragma restriction mean? _____ It refers to whether it is kosher or not. _____ It tells you if the function can be used in a SELECT statement. _____ It shows the effect executing the function will have on other objects in the database or the package. _____ It tells you if the function is overloaded.
5)	What is the principal benefit of an overloaded function? _____ An overloaded function is able to bypass any pragma restriction. _____ An overloaded function behaves differently depending on the type of data passed in when it is called. _____ It is just a lot of hype ”overloaded functions have no benefit. _____ An overloaded function is like a ghost function.

Answers appear in Appendix A, Section 16.1 .