Multiple choice technology databases

Using EM Database Control, you discover that two application PL/SQL functions and a view are currently invalid. Which of the following might you use to fix these objects?

  1. Shut down and restart the database.

  2. Use EM Database Control to recompile the object.

  3. Export the invalid objects, drop them, and then import them.

  4. Use the ALTER FUNCTION … COMPILE and ALTER VIEW … COMPILE commands.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

EM Database Control provides a recompile option for invalid objects directly in its interface. Additionally, you can use ALTER FUNCTION ... COMPILE and ALTER VIEW ... COMPILE commands to manually recompile specific PL/SQL objects. Shutting down the database won't fix invalid objects, and export/import is unnecessarily complex for simple recompilation.

Keep practicing — related questions