AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2805

View the Exhibit to examine a Java source file.
You have the corresponding Java class file and you execute the command as follows:
SQL> CREATE OR REPLACE PROCEDURE ccformat
(x IN OUT VARCHAR2)
AS LANGUAGE JAVA
NAME 'FormatCreditCardNo.formatCard()';
Which statement is true about the command?
 

Option A

A.    It loads the Java class method into Oracle Database and publishes it.
 

Option B

B.    It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed.
 

Option C

C.    It creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to invoke the Java class method.
 

Option D

D. It publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java class method when it is executed.
 

Correct Answer B
Explanation


Question ID 2806

View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = 'SA_REP';
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?
 

Option A

A.    Replace EMP_CV in line 3 with employees.salary%TYPE.
 

Option B

B.    Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
 

Option C

C.    Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
 

Option D

D.    Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
 

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!