Oracle-Database-12c-Advanced-PL-SQL-(1Z0-148).pdf - Oracle 1Z0-148 Oracle Database 12c Advanced PL\/SQL http\/killexams.com\/exam-detail\/1Z0-148 QUESTION

Oracle-Database-12c-Advanced-PL-SQL-(1Z0-148).pdf - Oracle...

This preview shows page 1 - 4 out of 8 pages.

1Z0-148 Oracle Oracle Database 12c: Advanced PL/SQL
Image of page 1
QUESTION: 67 Examine this Java method in class Employee, loaded into the Oracle database: Public static int updateSala ry (String name, float salary) {…} Which PL/SQL specification can be used to publish this method? A. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVALIBRARY “Employee” NAME “updateSalary” PARAMETERS (p_nm java .lang. String, p_sal float, RETURN int); B. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME “Employee.updateSalary” PARAMETERS (p_nm java.lang.String, p_sal float, RETURN int); C. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME “Employee.updateSalary” PARAMETERS (“name” java.lang.String, “salary” float, RETURN int); D. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME ‘Employee.updateSalary (java.lang.String, float) return int’; E. CREATE FUNCTION update_salary (p_nm VARCHAR2, p_sal NUMBER)RETURN PLS_INTEGER AS LANGUAGE JAVANAME ‘int Employee.updateSalary (java.lang.String, float)’; Answer: C QUESTION: 68 Which two PL/SQL blocks give the output “this is a test message”?
Image of page 2
A. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (‘this is a test message’, TRUE));END; B. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (‘this is a “ “test” ” message’, TRUE));END; C. BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSER T.ENQUOTE_NAME (‘ “this
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '20
  • CPU cache

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture