Which two blocks of code execute successfully?

• A. DECLARE
  SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; my_val new_one; BEGIN my_val :=2; END;
• B. DECLARE
  SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; my_val new_one; BEGIN my_val :=0; END;
• C. DECLARE
  SUBTYPE new_one IS NUMBER (1, 0); my_val new_one; BEGIN my_val := -1;
  END;
• D. DECLARE
  SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string; BEGIN my_str := 'abc'; END;
• E. DECLARE
  SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END;

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

• A. Users with CREATE TASK privilege can create or run parallel execution tasks.
• B. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
• C. Only DBAs can create or run parallel execution tasks.
• D. No specific system privileges are required to create or run parallel execution tasks.
• E. To execute chunks in parallel, users must have CREATE JOB system privilege.

Examine the structure of the EMP table:
Name Null? Type
------------------ -------------- ---------------------
EMPNO NOT NULL NUMBER (4)
ENAME VARCHAR2 (10)
SAL NUMBER (7, 2)
Examine this code:

Which code should be inserted to display the collection contents?

• A. 1_indx := 1_list.FIRST;WHILE (1_indx IS NOT NULL) LOOPDBMS_OUTPUT.PUT_LINE (1_indx ||
  ' ' || 1_list (1_indx));1_indx := 1_emp.NEXT (1_indx);END LOOP;
• B. FOR indx IN 1_list. COUNT .. -1 LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;
• C. FOR indx IN -1 .. 1_list.LIMIT LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx) );END LOOP;
• D. FOR indx IN 1_list.FIRST . . 1_list.LAST LOOPDBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));END LOOP;

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 the database administrator disables the result cache during ongoing application patching
• C. When the maximum amount of server result cache memory that can be used for a single result is set to 0.
• D. When the function is executed in a session frequently with the same parameter value
• E. 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