Set - 6

Question 26 :

Difference between NO DATA FOUND and %NOTFOUND?

Answer :

NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.


Question 27 :

Can you use a commit statement within a database trigger?

Answer :

No


Question 28 :

What WHERE CURRENT OF clause does in a cursor?

Answer :

LOOP
SELECT num_credits INTO v_numcredits FROM classes
WHERE dept=123 and course=101;
UPDATE students
FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits
WHERE CURRENT OF X;


Question 29 :

There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Answer :

INSTR('120000 12 0 .125',1,'.')
output 13


Question 30 :

What are different modes of parameters used in functions and procedures?

Answer :

-IN -OUT -INOUT