Which three are true regarding error propagation? (Choose three)

• A. An exception cannot propagate across remote procedure calls.
• B. The use of the RAISE; statement in an exception handler reraises the current exception.
• C. An exception raised inside an exception handler immediately propagates to the enclosing block.
• D. An exception raised inside a declaration immediately propagates to the current block.

Explanation: Only visible for TestValid members. You can sign-up / login (it's free).

When using a packaged function in a query, what is true?

• A. The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.
• B. The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.
• C. The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.
• D. You can not use packaged functions in a query statement.
• E. The COMMIT and ROLLBACK commands are allowed in the packaged function.

Explanation: Only visible for TestValid members. You can sign-up / login (it's free).

What part of a database trigger determines the number of times the trigger body executes?

• A. Trigger timing
• B. Trigger event
• C. Trigger body
• D. Trigger type

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?

• A. Row is: 4 Row is: 5 Row is: 6
• B. Row is: 1 Row is: 2 Row is: 3
• C. ERROR at line 1:
• D. Row is: Row is: Rows is:

Explanation: Only visible for TestValid members. You can sign-up / login (it's free).

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%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
What is the output in your session?

• A. Row is: Row is: Row is:
• B. Row is: 4 Row is: 5 Row is: 6
• C. Row is: 1 Row is: 2 Row is: 3
• D. ERROR at line 1:

Explanation: Only visible for TestValid members. You can sign-up / login (it's free).