#1.You are the DBA for ABC Corp. You are asked to write some fetch statements. What should you do after each
fetch statement in your PL/SQL code block?

A. Test for the rows by utilizing cursor attributes.

B. Test the ODBC connection

C. Start the
timer.

D. Drop the cursor.

E. Start the trigger.

Ans:D.

#2.You are the DBA for ABC Corp. You are asked to test if the current fetch
is successful within the loop of a PL/SQL block. Which SQL cursor attributes can be useful in this case?

A. SQL%FOUND.

B. SQL%SUCCESS.


C. SQL%FETCHED.

D. SQL%ISFOUND.

E. SQL%ISCOUNT.

Ans:D.


#3.You are the DBA for ABC Corp. You are asked to write the following
codes:

DECLARE
V_sal emp.sal%type;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno=&&p_empno;
IF v_sal

---