This preview shows page 1. Sign up to view the full content.
Unformatted text preview: el enabled or an aggregate function. If a function is pipelined or an
aggregate function, the associated implementation type (if any) is also identified. It
doesn't have when the object was last complied.
B. There is nothing called USER_PROCS.
D. There is nothing called USER_PLSQL_UNITS
QUESTION 20: Examine this code:
CREATE OR REPLACE TRIGGER secure_emp
BEFORE LOGON ON employees
IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR
NOT BETWEEN '08:00' AND '18:00')
THEN RAISE_APPLICATION_ERROR (-20500, 'You may
insert into the EMPLOYEES table only during
What type of trigger is it?
A. DML trigger
B. INSTEAD OF trigger
C. Application trigger
D. System event trigger
E. This is an invalid trigger.
The Triggering Event is incorrect. A User does not LOGON or LOGOFF from a Table. You can't
create a BEFORE LOGON or AFTER LOGOFF trigger.
Event When allowed or applicable STARTUP AFTER SHUTDOWN BEFORE SERVERERROR AFTER Actualtests.com - The Power of Knowing 1Z0-147
LOGON AFTER LOGOFF BEFORE A. This trigger is not performing an INSERT, UPDATE or DELETE on Table
B. INSETED OF Triggers are defined on a VIEW
C. Application triggers fire when a particular event occurs in the application. Application
are developed using Oracle client-side tools, such as Oracle Forms Developer.
E. This is a failed attempt of creating a System Event Triiger. Modify the code to specify
AFTER LOGON ON DATABASE to correct the problem .
QUESTION 21: Examine this package:
CREATE OR REPLACE PACKAGE discounts
g_id NUMBER := 7829;
discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
CREATE OR REPLACE PACKAGE BODY discounts
PROCEDURE display_price (p_price NUMBER)
discount_rate := 0.10;
Which statement is true?
A. The value of DISCOUNT_RATE always remai...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09