Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-146
Title
: Oracle 11g: Advanced
PL/SQL
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Identify two strategies against SQL injection. (Choose two.)
A. Using parameterized queries with bind arguments.
B. Use subprograms that are run with the definer's right.
C. Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.
D. Validate user inputs to functions that use dynamic SQLs built with concatenated values.
Answer: AD
2. There is a Java class file in your system and you publish it using the following command:
CREATE OR REPLACE PROCEDURE ccformat
(x IN OUT VARCHAR2)
AS LANGUAGE JAVA
NAME 'FormatCreditCardNo.formatCard(java.lang.String[])';
However, you receive the following error when executing the CCFORMAT procedure:
ERROR at line 1:
ORA-29540: class FormatCreditCardNo does not exist
ORA-06512: at "SH.CCFORMAT", line 1
ORA-06512: at line 1
What would you do to execute the procedure successfully?
A. Change the listener configuration.
B. Create a directory object and link it to the Java class file.
C. Rebuild the Java class file when the database instance is running.
D. Use the loadjava utility to load the Java class file into the database.
Answer: D
3. Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL
package? (Choose two.)
A. DDL report for all objects dependent on a table
B. DDL report for all the objects stored in a tablespace
C. DDL report for all the invalidated objects in a schema
D. data definition language (DDL) report for all the tables in a schema
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Answer: AD
4. View the Exhibit and examine the code in the PL/SQL block.
The PL/SQL block generates an error on execution. What is the reason?
A. The DELETE(n) method cannot be used with varrays.
B. The DELETE(n) method canno