Oracle9i program with pl/sql - 1Z0-147 FREE EXAM DUMPS QUESTIONS & ANSWERS

Which two statements about object dependencies are accurate? (Choose two.)

Which three are valid ways to minimize dependency failure? (Choose three)

Which three are true statements about dependent objects? (Choose three)

When creating a function, in which section will you typically find the RETURN keyword?

Examine this code:
CREATE OR REPLACE PRODECURE add_dept (p_dept_name VARCHAR2 DEFAULT 'placeholder', p_location VARCHAR2 DEFAULT 'Boston')
IS BEGIN INSERT INTO departments VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location); END add_dept; /
Which three are valid calls to the add_dep procedure? (Choose three)

Examine this package:
CREATE OR REPLACE PACKAGE pack_cur
IS
CURSOR c1 IS
SELECT prodid
FROM product
ORDER BY prodid DESC;
PROCEDURE proc1;
PROCEDURE proc2;
END pack_cur;
/
CREATE OR REPLACE PACKAGE BODY pack_cur
IS
v_prodif NUMBER;
PROCEDURE proc1 IS
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' || c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 3;
END LOOP;
END proc1;
PROCEDURE proc2 IS
BEGIN
LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' ||c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 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;
You then execute the procedure PROC2 from SQL *Plus with the command:
EXECUTE pack_cur.PROC2;
What is the output in your session from the PROC2 procedure?