[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-146 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-146
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-146.html

Oracle 11g: Advanced PL/SQL

Question No: 21 – (Topic 0)

Which two statements are true about associative arrays and nested tables? (Choose two.)

  1. Only associative arrays can hold an arbitrary number of elements.

  2. Only associative arrays can use numbers and strings for subscripts.

  3. Both associative arrays and nested tables can hold an arbitrary number of elements.

  4. Both associative arrays and nested tables can use numbers and strings for subscripts.

Answer: B,C

Question No: 22 – (Topic 0)

You executed the following command to alter the session parameter:

SQLgt; ALTER SESSION SET PLSCOPE_SETTINGS = #39;IDENTIFIERS:ALL#39;;

Which two statements are true in this scenario? (Choose two.)

  1. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope does not collect data for the compiled object.

  2. All the identifiers declared in compiled program units before altering the parameter settings appear in the *_IDENTIFIER static data dictionary

    views.

  3. All the identifiers declared in compiled program units before altering the parameter settings do not appear in the *_IDENTIFIER static data

    dictionary views.

  4. If the SYSAUX tablespace is unavailable, and you compile a program unit, PL/Scope collects data for the compiled object and stores it in the

SYSTEM tablespace.

Answer: A,C

Question No: 23 – (Topic 0)

Examine the following line of code that is part of a PL/SQL application: stmt:=#39;SELECT session_id FROM sessions WHERE #39; || p_where_stmt;

Identify a solution for preventing SQL injection in the above code.

  1. Replace P_WHERE_STMT with a bind variable.

  2. Do not use APIs that allow arbitrary query parameters to be exposed.

  3. Use the RESTRICT_REFERENCES clause in the PL/SQL subprogram that contains the

    code.

  4. Use DBMS_SQL to detect that the expression provided for P_WHERE_STMT is free from SQL injection.

Answer: B

Question No: 24 – (Topic 0)

Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)

  1. It must be part of a package.

  2. It must be a pipelined table function.

  3. It must not be defined in an anonymous block.

  4. It must have at least one OUT or IN OUT parameter.

Answer: C,D

Question No: 25 – (Topic 0)

You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?

  1. The corresponding shared library is also removed from the system.

  2. PL/SQL subprograms can be used to invoke the external C procedure.

  3. The existing extproc process is terminated and a new extproc is started.

  4. The PL/SQL subprogram that depends on the external C program becomes invalid.

Answer: D

Question No: 26 – (Topic 0)

DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object.

You create a table using the following command:

CREATE TABLE clob_tab(col2 CLOB);

View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error.

What correction must be done to ensure the PL/SQL block executes successfully?

Ensurepass 2018 PDF and VCE

  1. The L_OUT variable must be initialized to an empty locator.

  2. The L_OUT variable has to be declared as a temporary LOB.

  3. The A_CLOB variable has to be declared as a temporary LOB.

  4. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.

Answer: D

Question No: 27 – (Topic 0)

Which two types of query results cannot be stored in the query result cache? (Choose two.)

  1. subquery results

  2. results of a query having the SYSDATE function

  3. results of a query having the GROUP BY clause

  4. results of a query having the DATE data type in the WHERE clause

Answer: A,B

Question No: 28 – (Topic 0)

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 :=#39;This is the second line of a new document#39;; 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?

  1. null

  2. an empty locator

  3. a non-NULL value

  4. either null or any non-NULL values

Answer: C

Question No: 29 – (Topic 0)

View the Exhibit and examine the PL/SQL code.

The code takes a long time to execute. What would you recommend to improve performance?

Ensurepass 2018 PDF and VCE

  1. using NOT NULL constraint when declaring the variables

  2. using the BULK COLLECT option for query instead of cursor

  3. using WHILE.. END LOOP instead of FOR .. END LOOP

  4. using the SIMPLE_INTEGER data type instead of the NUMBER data type

Answer: B

Question No: 30 – (Topic 0)

Which statements are true about internal LOBs? (Choose all that apply.)

  1. They cannot use redo logging.

  2. They can be used as attributes of a user-defined data type.

  3. They cannot be passed as parameters to PL/SQL subprograms.

  4. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column.

Answer: B,D

100% Ensurepass Free Download!
Download Free Demo:1z0-146 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-146 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.