Correct Answer: Trigger type
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle PL/SQL 9i Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle PL/SQL 9i MCQ Questions
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?
Examine the code given below: CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON emp BEGIN INSERT INTO audit_table (who, dated) VALUES (USER, SYSDATE); END; / You issue an UPDATE command in the EMP table, which results in changing 10 rows. How many rows are inserted in the AUDIT_TABLE ?
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?