[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-146 Dumps with VCE and PDF 41-50

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

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

  1. Cursor variables can be parameterized like cursors.

  2. The query associated with a cursor variable cannot reference host variables and PL/SQL variables.

  3. The FETCH statement executes the query associated with a cursor variable and identifies the result set.

  4. Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.

  5. The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.

Answer: D,E

Question No: 42 – (Topic 0)

Examine the PL/SQL code for the GET_TABLE_MD function given below:

CREATE OR REPLACE FUNCTION get_table_md RETURN CLOB IS h NUMBER;

th NUMBER;

doc CLOB; BEGIN

h := DBMS_METADATA.OPEN(#39;TABLE#39;); DBMS_METADATA.SET_FILTER(h,#39;SCHEMA#39;,#39;HR#39;); DBMS_METADATA.SET_FILTER(h,#39;NAME#39;,#39;TIMECARDS#39;); th := DBMS_METADATA.ADD_TRANSFORM(h,#39;DDL#39;);

doc := DBMS_METADATA.FETCH_CLOB(h); DBMS_METADATA.CLOSE(h);

RETURN doc; END;

Which statement is true about the compilation and execution of the function?

  1. The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema.

  2. The compilation produces an error because DBMS_METADATA.SET_FILTER(h,#39;SCHEMA#39;,#39;HR#39;)is not placed in the correct order.

  3. The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema.

  4. The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP.

Answer: C

Question No: 43 – (Topic 0)

View the Exhibit to examine a Java source file.

You have the corresponding Java class file and you execute the command as follows:

SQLgt; CREATE OR REPLACE PROCEDURE ccformat (x IN OUT VARCHAR2)

AS LANGUAGE JAVA

NAME #39;FormatCreditCardNo.formatCard()#39;; Which statement is true about the command?

Ensurepass 2018 PDF and VCE

  1. It loads the Java class method into Oracle Database and publishes it.

  2. It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is executed.

  3. It creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to invoke the Java class method.

  4. It publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java class method when it is executed.

Answer: B

Question No: 44 – (Topic 0)

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 = #39;SA_REP#39;;

  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?

Ensurepass 2018 PDF and VCE

  1. Replace EMP_CV in line 3 with employees.salary%TYPE.

  2. Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.

  3. Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.

  4. Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.

Answer: A

Question No: 45 – (Topic 0)

Examine the section of code taken from a PL/SQL program:

PROCEDURE p1 (x PLS_INTEGER) IS

… …

PRAGMA INLINE (p1, #39;NO#39;);

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.)

  1. The calls to the P1 procedure are not inlined in the section commented as Call 1.

  2. The calls to the P1 procedure might be inlined in the section commented as Call 2.

  3. The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.

  4. The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.

Answer: A,B

Question No: 46 – (Topic 0)

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

  1. They can be created only for CLOB and NCLOB data.

  2. They can be accessed only by the user who creates them.

  3. They generate more redo information than persistent LOBs.

  4. They exist for the duration of the session in which they are created.

  5. They are stored temporarily in the default tablespace of the user who creates them.

Answer: B,D

Question No: 47 – (Topic 0)

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?

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

  1. It generates an error because RECORD type cannot be used with varrays.

  2. It generates an error because BULK COLLECT cannot be used with varrays.

  3. It executes successfully only if department ID 60 has five or less than five employees.

  4. It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.

Answer: C

Question No: 48 – (Topic 0)

Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)

  1. When fetching from a cursor, fetch into a record.

  2. When fetching from a cursor, fetch required values into individually declared variables.

  3. Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor instead of using the cursor FOR loop.

  4. Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using the OPEN, FETCH, and CLOSE statements to manipulate the cursor.

Answer: A,D

Question No: 49 – (Topic 0)

Which two statements are true about the initialization of internal LOBs? (Choose two.)

  1. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.

  2. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non- NULL internal LOBs.

  3. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.

  4. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB() functions, respectively.

  5. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.

Answer: C,E

Question No: 50 – (Topic 0)

Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)

  1. It can be performed only on tables with a single LOB column.

  2. It automatically creates an interim table during the migration process.

  3. It allows the table that is migrated to be accessed throughout the migration process.

  4. It requires free space that is at least equal to the space used by the table that is migrated.

  5. It requires all constraints defined on the original table to be re-created manually after the migration.

Answer: C,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