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?

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

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

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

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

The OLD and NEW qualifiers can be used in Row level system trigger.

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 program declarations are correct for a stored program unit?

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 statements is correct with regard to stored procedures?

__________ is present in Oralce9i only.