Testking 1Z0-146 Questions are updated and all 1Z0-146 answers are verified by experts. Once you have completely prepared with our 1Z0-146 exam prep kits you will be ready for the real 1Z0-146 exam without a problem. We have Improved Oracle 1Z0-146 dumps study guide. PASSED 1Z0-146 First attempt! Here What I Did.
♥♥ 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
Q71. 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
Q72. Which two statements are true about cursor variables? (Choose two.)
A. Cursor variables can be parameterized like cursors.
B. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
C. The FETCH statement executes the query associated with a cursor variable and identifies the result set.
D. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
E. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
Answer: D,E
Q73. You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?
A. All PL/SQL blocks that are executed subsequently in the session are traced.
B. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.
C. Only anonymous PL/SQL blocks that are executed subsequently in the session are traced.
D. It enables only named PL/SQL blocks that are executed subsequently in the session for tracing.
Answer: B
Q74. Which two types of query results cannot be stored in the query result cache? (Choose two.)
A. subquery results
B. results of a query having the SYSDATE function
C. results of a query having the GROUP BY clause
D. results of a query having the DATE data type in the WHERE clause
Answer: A,B
Q75. When do you use static SQL as a technique for avoiding SQL injection?
A. when the WHERE clause values are unknown
B. when the code contains data definition language (DDL) statements
C. when all Oracle identifiers are known at the time of code compilation
D. when the SET clause values are unknown at the time of code compilation
Answer: C
Q76. Examine the following line of code that is part of a PL/S QL application: stmt:='SELECT session_id FROM sessions WHERE ' || p_where_stmt; Identify a solution for preventing SQL injection in the above code.
A. Replace P_WHERE_STMT with a bind variable.
B. Do not use APIs that allow arbitrary query parameters to be exposed.
C. Use the RESTRICT_REFERENCES clause in the PL/SQL subprogram that contains the code.
D. Use DBMS_SQL to detect that the expression provided for P_WHERE_STMT is free from SQL injection.
Answer: B
Q77. 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
Q78. You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:,
SQL> select dbms_result_cache.status() from dual;
You receive the following output:
DBMS_RESULT_CACHE.STATUS()
DISABLED
Identify the reason for the output.
A. The RESULT_CACHE_MODE parameter is set to FORCE.
B. The RESULT_CACHE_MODE parameter is set to MANUAL.
C. The database instance is not able to allocate memory for the result cache.
D. The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0.
Answer: D
Q79. Examine the structure of the PRINT_MEDIA table: Name Null? Type
ADVT_ID NUMBER ADVT_SOURCE CLOB Examine the following PL/SQL block:
DECLARE
lobloc CLOB;
buffer VARCHAR2(100);
amount NUMBER;
offset NUMBER :=1;
BEGIN
buffer :='This is the second line of a new document'
amount := LENGTH(buffer);
SELECT advt_source INTO lobloc FROM print_media WHERE advt_id=2 FOR UPDATE;
DBMS_LOB.WRITE(lobloc,amount,offset,buffer);
COMMIT;
END;
/
What must be the value in the ADVT_SOURCE column for the above code to execute
successfully?
A. null
B. an empty locator
C. a non-NULL value
D. either null or any non-NULL values
Answer: C
Q80. 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