Oracle
1Z0-146 · Question #98
1Z0-146 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
Question
Examine the following error: SQL> DECLARE v_runid NUMBER; BEGIN v_runid := DBMS_HPROF.ANALYZE (LOCATION => 'PROFILE_DATA', FILENAME => 'pd_cc_pkg.txt'); DBMS_OUTPUT.PUT_LINE('Run ID: ' || v_runid); END; DECLARE * ERROR at line 1: ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_HPROF", line 299 ORA-06512: at line 4 What would you do to execute the above block successfully?
Options
- AStart the PL/SQL profiler before executing the block.
- BRun the tracetab.sql script located at ORACLE_HOME\RDBMS\ADMIN.
- CRun the dbmshptab.sql script located at ORACLE_HOME\RDBMS\ADMIN.
- DGrant READ and WRITE privileges to the current user on the PROFILE_DATA directory object.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.