Multiple choice technology databases

An application developer has written a database package for an Order Entry application using SQL Plus editor. While compiling the package, he receives errors. What will be the next step to troubleshoot the error?

  1. Execute the command FIX ERROR

  2. Execute the command SHOW ERROR

  3. Execute the command TROUBLESHOOT ERROR

  4. Execute the command INVESTIGATE ERROR

  5. Execute the command ANALYZE ERROR

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL*Plus, the SHOW ERRORS (or SHOW ERROR) command displays compilation errors for the most recently compiled PL/SQL block or database object. Commands like FIX, TROUBLESHOOT, INVESTIGATE, or ANALYZE error are not valid SQL*Plus instructions.