__________ is present in Oralce9i only.

Which statements is correct with regard to stored procedures?

Which procedure is called after a row has been fetched to transfer the value from the select list of the cursor to a local variable?

Which program declarations are correct for a stored program unit?

Examine the code given below: Declare cursor emps is select Empno,ename,sal,deptno,job from emp; begin for rec in emps loop open emps; dbms_output.put_line(rec.empno||rec.ename||rec.sal||rec.deptno||rec.job); end loop; end; / What is wrong in above declaration?

Which statement is correct?

The Technique employed by the Oracle engine to protect table data when several people are accessing is called:

Which exception is raised when the data type or data size is invalid?

Which of the following Triggers is fired each time a row in the table is affected by the triggering statement?

Which type of argument passes a value from a procedure to the calling environment?

You need to create a trigger on the EMP table, which monitors every row that is changed and places this information in the AUDIT_TABLE. What type of trigger would you create?