1Z0-147

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: rst time that it executes and it will recompile the second time that it is invoked Incorrect Answers A. We are using Timestamp checking not signature checking. The EMP Table is the referenced object. If the definition of a referenced object is changed or modified, its dependent objects become invalid. Modifying any of the dependent procedures (Emp Table in this case) will not invalidate the referenced object regardless of the mode to check dependencies. Actualtests.com - The Power of Knowing 1Z0-147 C. In this scenario we are using TimeStamp method not the Signature method. D. Since QUERY_EMP is a remote procedure, this procedure will be set to invalid the first time that it executes and it will recompile the second time that it is invoked. QUESTION 95: Examine this package: CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT prodid FROM poduct ORDER BY prodid DESC; PROCEDURE proc1; PROCEDURE proc2; END pack_cur; / CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodid NUMBER; PROCEDURE proc1 IS BEGIN OPEN C1 LOOP FETCH C1 INTO v_prodid; DBMS_OUTPUT.PUT_LINE ( 'Row is: '| | c1%ROWCOUNT); EXIT WHEN c1%ROWCONT >= 3; END LOOP; END procl; PROCEDURE proc2 IS BEGIN LOOP FETCH C1 INTO v_prodid; DBMS_OUTPUT.PUT_LINE ( 'Row is: '| | c1%ROWCOUNT); EXIT WHEN c1%ROWCONT >= 6; END LOOP; CLOSE C1; END proc2; END pack_cur; / The product table has more than 1000 rows. The SQL *Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure PROC1 from SQL *Plus with the command: EXECUTE pack_cur.proc1 What is the output in your session? Actualtests.com - The Power of Knowing 1Z0-147 A. ERROR at line 1: B. Row is: Row is: Row is: C. Row is: 1 Row is: 2 Row is: 3 D. Row is: 4 Row is: 5 Row is: 6 Answer: C Explanation: proc1 will open the C1 Cursor and go into a Loop. The Loop Fetches and outputs the first three records. Since the SET SERVEROUTPUT Command was set the results will be displayed Incorrect Answers A. This procedure will successfully execute with errors. B. The output will include the Row Number f...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online