Master the 1Z0-146 Oracle 11g: Advanced PL/SQL content and be ready for exam day success quickly with this Testking 1Z0-146 test preparation. We guarantee it!We make it a reality and give you real 1Z0-146 questions in our Oracle 1Z0-146 braindumps.Latest 100% VALID Oracle 1Z0-146 Exam Questions Dumps at below page. You can use our Oracle 1Z0-146 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-146 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-146 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-146-exam-dumps.html
Q61. View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the following PL/SQL block for storing the salary of all sales representatives from the
EMPLOYEES table in an associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = 'SA_REP'
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?
A. Replace EMP_CV in line 3 with employees.salary%TYPE.
B. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
C. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
D. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
Answer: A
Q62. 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?
A. It loads the Java class method into Oracle Database and publishes it.
B. It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed.
C. It creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to invoke the Java class method.
D. It publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java class method when it is executed.
Answer: B
Q63. Examine the section of code taken from a PL/SQL program:
PROCEDURE p1 (x PLS_INTEGER) IS
PRAGMA INLINE (p1, 'NO');
x:= p1(1) + p1(2) + 17; -- Call 1
x:= p1(3) + p1(4) + 17; -- Call 2
Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL parameter is set to 3. Which two statements are true in this scenario? (Choose two.)
A. The calls to the P1 procedure are not inlined in the section commented as Call 1. B. The calls to the P1 procedure might be inlined in the section commented as Call 2.
C. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
D. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.
Answer: A,B
Q64. View the Exhibit.
How do you reduce the chances of SQL injection for the procedure?
A. Execute the SQL statement in V_STMT as dynamic SQL.
B. Remove the default value for the arguments in the procedure.
C. Convert the condition in the WHERE clause to be accepted from the user and concatenated.
D. Convert the SELECT statement to static SQL, placing the value of P_EMAIL into a local variable.
Answer: D
Q65. You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
View Exhibit1 to examine the output. After some time, the query produces a different result as shown in Exhibit2.
What is the cause for the change?
A. The FOO procedure has been executed more than once.
B. The PLSQL_DEBUG parameter is set to FALSE for the user session.
C. The FOO procedure has been compiled with the DEBUG option, and executed.
D. Schema level statistics have been gathered by the database administrator (DBA).
Answer: C
Q66. Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)
A. It can be performed only on tables with a single LOB column.
B. It automatically creates an interim table during the migration process.
C. It allows the table that is migrated to be accessed throughout the migration process.
D. It requires free space that is at least equal to the space used by the table that is migrated.
E. It requires all constraints defined on the original table to be re-created manually after the migration.
Answer: C,D
Q67. Examine the structure of the TEXT_TAB table. Name Null? Type
TEXT_ID NUMBER
DOC1 CLOB
DOC2 CLOB
You issue the following INSERT commands:
INSERT INTO text_tab VALUES (1, 'This is line 1',null);
INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2');
Then you execute the following block of the PL/SQL code:
DECLARE
vc1 VARCHAR2(1000):= 'This is the preface'
lb1 CLOB;
lb2 CLOB;
BEGIN
SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1;
SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2;
lb2 := vc1|| lb1;
UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1;
END;
/
What is the outcome?
A. It executes successfully.
B. It gives an error because VARCHAR2 should be explicitly converted to CLOB.
C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB().
D. It gives an error because the concatenation operator cannot be used with the CLOB data type.
Answer: A
Q68. Examine the code snippet from the declarative section of a PL/SQL block:
DECLARE
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
departments.department_id%TYPE;
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.)
A. tb1
B. tb2
C. tb3
D. tb4
E. tb5
Answer: B,C
Q69. Which statement describes the purpose of the plshprof command?
A. It produces HTML output from raw profiler output.
B. It produces HTML output from profiler tables in the database.
C. It populates profiler tables in the database from raw profiler output.
D. It produces raw profiler output on the most recently run applications.
Answer: A
Q70. Examine the following command to create the table EMPLOYEES_TEMP and the PL/SQL block.
CREATE TABLE employees_temp (empid NUMBER(6) NOT NULL,
deptid NUMBER(6) CONSTRAINT c_emp_deptid CHECK (deptid BETWEEN 100 AND 200),
salary Number(8),
deptname VARCHAR2(30) DEFAULT 'Sales')
/
DECLARE
SUBTYPE v_emprec_subtype IS employees_temp%ROWTYPE;
v_emprec v_emprec_subtype;
BEGIN
v_emprec.empid := NULL; v_emprec.salary := 10000.002;
v_emprec.deptid := 50;
DBMS_OUTPUT.PUT_LINE('v_emprec.deptname: ' || v_emprec.deptname);
END;
/
Which statements are true about the above PL/SQL block? (Choose two.)
A. V_EMPREC.DEPTNAME would display a null value because the default value is not inherited.
B. Assigning null to V_EMPREC.EMPID would generate an error because the null constraint is inherited.
C. Assigning the value 1000.002 to V_EMPREC.SALARY would generate an error because of the decimal.
D. Assigning the value 50 to V_EMPREC.DEPTID would work because the check constraint is not inherited.
Answer: A,D
