Examine the code given below: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, "DY") IN (SAT", "SUN")) OR (TO_CHAR(SYSDATE, "HH24:MI") NOT BETWEEN "08:00" AND "18:00") THEN RAISE_APPLICATION_ERROR (-20500, "You may insert into the EMPLOYEES table only during business hours."); END IF; END; / What type of trigger is this?

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:

Which statement is correct?

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?