Oracle
1Z0-146 · Question #25
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…
The correct answer is B. It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt loads the Java class method into Oracle Database and publishes it.
- BIt publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed.
- CIt creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to invoke the
- DIt publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java class
How the community answered
(33 responses)- A3% (1)
- B82% (27)
- C12% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.