Now you need to enable all triggers on the employees

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6th Row. QUESTION 87: You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplished this? A. You cannot enable multiple triggers on a table in one command. B. ALTER TRIGGERS ON TABLE employees ENABLE; C. ALTER employees ENABLE ALL TRIGGERS; D. ALTER TABLE employees ENABLE ALL TRIGGERS; Answer: D Explanation: To enable or disable a single Trigger you issue the following Command at the Trigger Level: Actualtests.com - The Power of Knowing 1Z0-147 ALTER TRIGGER TriggerName ENABLE|DISABLE TriggerName; QUESTION 88: When creating stored procedures and functions, which construct allows you to transfer values to and from the calling environment? A. local variables B. arguments C. Boolean variables D. Substitution variables Answer: B Explanation: Arguments declared in the parameter list of the subprogram are called formal parameters. The MODE determines whether the values can be transferred to the calling environment OUT & IN OUT or from the calling Environment IN & IN OUT. Incorrect Answers A, C & D These variables can't be used to transfer values to & from the calling environment. QUESTION 89: You have the following table: CREATE TABLE Emp_log ( Emp_id NUMBER Log_date DATE, New_salary NUMBER, Action VARCHAR (20)); You have the following data in the EMPLOYEES table: EMPLOYEE_ID LAST_NAME SALARY DEPARTMENT_ID ----------- ------------------- ------------ ------------100 Bill 24000 90 101 Kochhar 17000 90 102 De Haan 17000 90 103 Hunold 9000 60 104 Ernst 6000 60 105 Austin 4800 60 106 Pataballa 4800 60 107 Lorentz 4200 60 108 Greenberg 12000 100 201 Hartstein 13000 20 Actualtests.com - The Power of Knowing 1Z0-147 202 Fay 6000 20 You create this trigger: CREATE OR REPLACE TRIGGER Log_salary_increase AFTER UPDATE ON employees FOR EACH ROW WHEN (new.Salary > 1000) BEGIN INSERT INTO Emp_log (Emp_id, Log_date, New_Salary, Action) VALUES (:new.Employee_id, SYSDATE, :new.SALar...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online