Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 241:

  Examine the settings for a user session given below:

  RESULT_CACHE_MODE= FORCE

  What would be the implications of this setting on query execution? (Choose all that apply.)

  A. All query results are stored in the result cache if possible.

  B. Query results that are bigger than the available space in the result cache are not cached.

  C. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.

  D. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.

  Correct Answer: AB

• Question 242:

  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?

  A. Start the PL/SQL profiler before executing the block.

  B. Run the tracetab.sql script located at ORACLE_HOME\RDBMS\ADMIN.

  C. Run the dbmshptab.sql script located at ORACLE_HOME\RDBMS\ADMIN.

  D. Grant READ and WRITE privileges to the current user on the PROFILE_DATA directory object.

  Correct Answer: C

• Question 243:

  Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.

  A. the trace file component

  B. the analyzer component

  C. the shared library component

  D. the data collection component

  Correct Answer: B