Oracle Database Advanced PL SQL 12c 1z0 148

Question : 15 of 54

Marks: +1, -0

Examine this Java method in class Employee, loaded into the Oracle database:
public static int updateSalary ( String name, float salary ) { … }
Which PL/SQL function specification can be used to publish this method?

CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA LIBRARY “Employee” NAME “updateSalary” PARAMETERS (p_nm java.lang. String, p_sal float, RETURN int);
CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME “Employee.updateSalary” PARAMETERS (p_nm java.lang.String, p_sal float, RETURN int);
CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME “Employee.updateSalary” PARAMETERS (“name” java.lang.String, “salary” float, RETURN int);
CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME ‘Employee.updateSalary (java.lang.String, float) return int’;
CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER) RETURN PLS_INTEGER AS LANGUAGE JAVA NAME ‘int Employee.updateSalary (java.lang.String, float)’;

Validate

Go to Question:

Prev Question

Next Question