In order to test your progress, you should be able to answer the following questions.
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.
The DESC command behaves like an overloaded procedure.
_____ True
_____ False
All functions require a pragma restriction to be used in an SQL statement.
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.
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 .