Unformatted text preview: :
CREATE [OR REPLACE] FUNCTION [(parameter [mode1]
parameter2 [mode2] datatype2 ...)]
IS | AS
C. This is the correct syntax for creating a Procedure.The syntax for creating a procedure
CREATE [OR REPLACE] PROCEDURE
[parameter1 [mode1] datatype1,
parameter2 [mode2] datatype2,
. . .)]
IS | AS
B. This is incorrect syntax for a Procedure. Functions have a RETURN Clause,
Procedures do not.
D. When you define the data type, the length of the data type is not
allowed in the parameter list. If you specify the length of a formal parameter, Oracle
issues an error at
E. The length of the data type is not allowed in the parameter list for functions or
procedures. Actualtests.com - The Power of Knowing 1Z0-147
QUESTION 58: You need to implement a virtual private database (vpd). In order to have the vpd
functionality, a trigger is required to fire when every user initiates a session in the
What type of trigger needs to be created?
A. DML trigger
B. System event trigger
C. INSTEAD OF trigger
D. Application trigger
System Event Triggers can be defined to fire at either at the schema level or database
level. You can create a trigger that is fired when a user connects to the
database. The triggering event in this case is LOGON. This trigger can be created either
database level or at the schema level. If the trigger is created at the database level, the
fired for all the users that connect to the database. If the trigger is created at the schema
the trigger is fired when the user that created the trigger connects to the database.
A. DML Triggers fire when a DML Operation is perform on a Table BEFORE OR
AFTER (Trigger Timing) the DML Event (INSERT, UPDATE or DELETE) on the
C. INSTEAD OF TRIGGERS will fire on a view.
D. Application trigger - Fires when a particular event occurs in the application.
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09