Oracle PL[s]SQL by Example

What is the purpose of the USER_ERRORS view?

1. _____ It prevents you from having to make use of the SHO ERR command.

2. _____ It has the details on database objects in an invalid state.

3. _____ It is a record of all compilation errors you have ever made.

4. _____ It has no purpose but to take up database space.

The DESC command behaves like an overloaded procedure.

1. _____ True

2. _____ False

All functions require a pragma restriction to be used in an SQL statement.

1. _____ True

2. _____ False

What does the purity level of a pragma restriction mean?

1. _____ It refers to whether it is kosher or not.

2. _____ It tells you if the function can be used in a SELECT statement.

3. _____ It shows the effect executing the function will have on other objects in the database or the package.

4. _____ It tells you if the function is overloaded.

What is the principal benefit of an overloaded function?

1. _____ An overloaded function is able to bypass any pragma restriction.

2. _____ An overloaded function behaves differently depending on the type of data passed in when it is called.

3. _____ It is just a lot of hype ”overloaded functions have no benefit.

4. _____ An overloaded function is like a ghost function.