[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-146 Dumps with VCE and PDF 11-20

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: 11 – (Topic 0)

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, #39;Jones#39;, NULL);

UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses = typ_course_nst(11,#39;Oracle#39;); Which statement is true about the execution of these commands?

  1. All the commands execute successfully.

  2. Only the first two commands execute successfully.

  3. Only the first four commands execute successfully.

  4. Only the first three commands execute successfully.

Answer: C

Question No: 12 – (Topic 0)

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?

Ensurepass 2018 PDF and VCE

  1. The DELETE(n) method cannot be used with varrays.

  2. The DELETE(n) method cannot be used with nested tables.

  3. The NEXT method cannot be used with an associative array with VARCHAR2 key values.

  4. The NEXT method cannot be used with a nested table from which an element has been deleted.

Answer: A

Question No: 13 – (Topic 0)

You created a procedure as follows:

CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2) IS

stmt VARCHAR2(100); pname VARCHAR2(20);

BEGIN

stmt:=#39;SELECT product_name FROM products WHERE product_id=:2#39;; EXECUTE IMMEDIATE stmt INTO pname USING twhr; DBMS_OUTPUT.PUT_LINE(pname);

END;

/

Ensurepass 2018 PDF and VCE

View the Exhibit to examine the structure of PRODUCTS table. Which statement is true about the procedure?

  1. It produces an error when invoked.

  2. It can be invoked only from a PL/SQL block.

  3. It reduces the chances of SQL injection by using bind arguments.

  4. The values for bind arguments remain persistent in the session after the execution of the procedure.

Answer: C

Question No: 14 – (Topic 0)

Identify three guidelines for the DBMS_ASSERT package. (Choose three.)

  1. Prefix all calls to DBMS_ASSERT with the SYS schema name.

  2. Embed DBMS_ASSERT verification routines inside the injectable string.

  3. Escape single quotes when you use the ENQUOTE_LITERAL procedure.

  4. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.

  5. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package.

Answer: A,C,D

Question No: 15 – (Topic 0)

Which two statements are true about cursor variables? (Choose two.)

  1. A cursor variable points to the current row in the result set of a multirow query stored in a work area.

  2. A cursor variable is an explicitly named work area in which the results of different multirow queries can be stored.

  3. A cursor variable can be used only if a query is performed and its results are processed in the same subprogram.

  4. A cursor variable can be used to perform a query in one subprogram, and process the results in a different subprogram.

Answer: A,D

Question No: 16 – (Topic 0)

Examine the code in the following PL/SQL block:

DECLARE

TYPE NumList IS TABLE OF INTEGER;

List1 NumList := NumList(11,22,33,44); BEGIN

List1.DELETE(2);

DBMS_OUTPUT.PUT_LINE

( #39;The last element# in List1 is #39; || List1.LAST ||

#39; and total of elements is #39;||List1.COUNT); List1.EXTEND(4,3);

END;

/

Which two statements are true about the above code? (Choose two.)

  1. LAST and COUNT give different values.

  2. LAST and COUNT give the same values.

  3. The four new elements that are added contain the value 33.

  4. The four new elements that are added contain the value 44.

Answer: A,C

Question No: 17 – (Topic 0)

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

  1. Only varrays must use sequential numbers as subscripts.

  2. Only varrays can be used as column types in database tables.

  3. Both associative arrays and varrays must use sequential numbers as subscripts.

  4. Both associative arrays and varrays can be used as column types in database tables.

Answer: A,B

Question No: 18 – (Topic 0)

You executed the following command:

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

You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for the PACK1 package specification and body.

You issue the following query to see all unique identifiers with a name, such as %1: SQLgt; SELECT NAME, SIGNATURE, TYPE

FROM USER_IDENTIFIERS

WHERE NAME LIKE #39;%1#39; AND USAGE=#39;DECLARATION#39; ORDER BY OBJECT_TYPE, USAGE_ID;

View Exhibit2 to examine the output of the query. Which two statements are true about the output of the query? (Choose two.)

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

  1. The SIGNATURE column has a unique value for an identifier except for identifiers with the same name.

  2. The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, triggers, or exceptions.

  3. The query shows the output for only those identifiers for PL/SQL objects, which are created by the user and are compiled after the ALTER SESSION command.

  4. The ALTER SESSION command automatically collects identifier data and the query shows the output for all the identifiers for PL/SQL objects, which are created by the user.

Answer: B,C

Question No: 19 – (Topic 0)

You enabled PL/SQL tracing in a user session using the following command:

SQLgt; 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?

Ensurepass 2018 PDF and VCE

  1. The FOO procedure has been executed more than once.

  2. The PLSQL_DEBUG parameter is set to FALSE for the user session.

  3. The FOO procedure has been compiled with the DEBUG option, and executed.

  4. Schema level statistics have been gathered by the database administrator (DBA).

Answer: C

Question No: 20 – (Topic 0)

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

  1. Only varrays must have consecutive numbers as subscripts.

  2. Only nested tables can be used as column types in database tables.

  3. Both nested tables and varrays must have consecutive numbers as subscripts.

  4. Both nested tables and varrays can be used as column types in database tables.

Answer: A,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.