We provide real 1Z0-146 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-146 Exam quickly & easily. The 1Z0-146 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-146 dumps pdf and vce product and material, you can easily pass the 1Z0-146 exam.
2017 NEW RECOMMEND
Free VCE & PDF File for Oracle 1Z0-146 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
Q61. View the Exhibit and examine the PL/SQL code.
The code takes a long time to execute. What would you recommend to improve performance?
A. using NOT NULL constraint when declaring the variables
B. using the BULK COLLECT option for query instead of cursor
C. using WHILE.. END LOOP instead of FOR .. END LOOP
D. using the SIMPLE_INTEGER data type instead of the NUMBER data type
Q62. Examine the code snippet from the declarative section of a PL/SQL block:
TYPE va1 IS VARRAY(10) OF VARCHAR2(20);
SUBTYPE scale IS NUMBER(1,0);
TYPE tb1 IS TABLE OF departments.department_name%TYPE INDEX BY
TYPE tb2 IS TABLE OF va1 INDEX BY PLS_INTEGER;
TYPE tb3 IS TABLE OF scale INDEX BY VARCHAR2(10);
TYPE tb4 IS TABLE OF DATE INDEX BY DATE;
TYPE tb5 IS TABLE OF NUMBER INDEX BY CHAR(2);
Which of the above are valid definitions for associative arrays? (Choose all that apply.)
Q63. The user OE is working on an app lication that needs to call an exte rnal C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Wh ich statement is true about the current session by the OE user?
A. The session can continue calling the external C program.
B. The session can call the external C program after republishing it.
C. The session receives an error for the next call to the external C program.
D. The session terminates during the subsequent call to the external C program.
Q64. Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)
A. a PL/SQL program which needs to be recompiled frequently
B. a PL/SQL program that spends most of the time executing SQL
C. a PL/SQL program, which performs computation-intensive procedural operations and is recompiled rarely
D. a PL/SQL program, which is called frequently with the same parameter values by multiple sessions and is recompiled rarely
Q65. Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)
A. Detect a wrong user.
B. Check input string length.
C. Verify qualified SQL names. D. Validate TNS connect strings.
E. Verify an existing schema name.
F. Enclose string literals within double quotation marks.
Q66. View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure.
Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)
A. Explicitly validate the identifier length limit.
B. Add AUTHID DEFINER to the definition of the procedure.
C. Use PRAGMA RESTRICT_REFERENCES in the procedure.
D. Filter out control characters in user-supplied identifier names.
E. Use the object ID of the table from the data dictionary to build the trigger name.
Q67. 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
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.
Q68. The result cache is enabled for the database instance.
Examine the following code for a PL/SQL function:
CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR
RESULT_CACHE RELIES_ON (HR.EMPLOYEES)
SELECT hire_date INTO date_hired
WHERE EMPLOYEE_ID = emp_id;
You notice that results for the functions are not used effectively. What do you recommend for better utilization of the result cache? (Choose all that apply.)
A. Set the RESULT_CACHE_MODE parameter to FORCE.
B. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
C. Add a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.
D. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
Q69. View Exhibit1 and examine the structure of the EMPLOYEES table.
View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60.
Which statement is true about the outcome?
A. It generates an error because RECORD type cannot be used with varrays.
B. It generates an error because BULK COLLECT cannot be used with varrays.
C. It executes successfully only if department ID 60 has five or less than five employees.
D. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.
Q70. Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)
/ CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5), faculty_name VARCHAR2(30), courses typ_course_nst) NESTED TABLE courses STORE AS course_stor_tab / INSERT INTO faculty VALUES (101, 'Jones', NULL); UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses = typ_course_nst(11,'Oracle'); Which statement is true about the execution of these commands?
A. All the commands execute successfully.
B. Only the first two commands execute successfully. C. Only the first four commands execute suc cessfully. D. Only the first three commands execute successfully.