Online Access Free 1z1-148 Practice Test

Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?

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

A products TABLE exists with a PROD_ID column.
Examine this PL/SQL block:

Which statement is true?

• A.It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.
• B.It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
• C.It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
• D.It executes successfully.
• E.It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);

Examine this declaration section:

Which two executable sections will display the message 'Summary is null'?

• A.BEGIN1_rec := NULL;1_emp := emp_typ (1_rec);IF 1_emp (1).expr_summary IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• B.BEGIN1_rec.emp_id :=1;1_rec.expr_summary := NULL;1_emp :=emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• C.BEGIN1_rec.emp_id :=1;1_rec.expr_summary := EMPTY_CLOB ();1_emp := emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• D.BEGIN1_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• E.BEGIN1_emp := emp_typ ();IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

• A.When the amount of memory allocated for the result cache is increased
• B.When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
• C.When the function is executed in a session frequently with the same parameter value
• D.When the database administrator disables the result cache during ongoing application patching
• E.When the maximum amount of server result cache memory that can be used for a single result is set to 0.

Examine the structure and data in the CUSTOMERS table:


Examine this code:

What is the outcome on execution with SERVEROUTPUT enabled?

• A.It displays 3 for both the row count and the total.
• B.It throws a PL/SQL: numeric or value error: NULL index table key value exception.
• C.It throws a NO_DATA_FOUND exception.
• D.It displays 3 for the row count and 2 for the total.