Free Oracle 1z0-148 Exam Dumps Questions & Answers

Which statement describes the plshprof command-line utility?

• A.  It stores hash values in hierarchical profiler tables in the database.
• B.  It produces HTML output from hierarchical profiler tables in the database.
• C.  It produces HTML output from raw profiler output.
• D.  It produces raw profiler output for the most recently executed PL/SQL block.
• E.  It executes a script to create hierarchical profiler tables in the database.

Which three statements are correct with reference to intra unit inlining?

• A.  You cannot inline an external subroutine.
• B.  Inlining will always decrease the size of a unit.
• C.  Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
• D.  Programs that make use of smaller helper subroutines are good candidates for inlining.
• E.  You cannot inline local subroutines.
• F.  Pragmas apply only to calls in the next statement following the pragma.

You are logged on to the SCOTT schema and the schema has EMP and DEPT tables already created:
Examine this PL/SQL procedure:

Which PL/SQL block will raise an exception?

• A.  EXEC get_tab_row_count ('DEPT, EMP')
• B.  EXEC get_tab_row_count ('SCOTT.EMP');
• C.  EXEC get_tab_row_count ('DEPT');
• D.  EXEC get_tab_row_count (' "EMP" ');
• E.  EXEC get_tab_row_count ('emp');

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

• A.  The function must be declared as a pipelined table function.
• B.  The IN parameters must not include BLOB, CLOB, collection or record data types.
• C.  The function must be created with invoker's rights or in an anonymous block.
• D.  The function must have an OUT or an IN OUT parameter.

Your company's executive team voted to give a one-time special bonus, the amount of which is to be based on number of years of service. The bonus table will be updated using a procedure called update_bonus().
Examine this PL/SQL block which shows the logic to calculate the bonus:

Consider these possible optimization actions:
1.Remove the service_days calculation statement.
2.Move bonus1 and bonus2 initializations out of the loop.
3.Inline the update_bonus() subprogram.
4.Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables.
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?

• A.  1 and 3 only
• B.  3 and 4 only
• C.  1 and 2 only
• D.  1, 2, 3, and 4
• E.  1, 2, and 4 only