return datatype is as plsql block c this is the

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: : CREATE [OR REPLACE] FUNCTION [(parameter [mode1] datatype1, parameter2 [mode2] datatype2 ...)] RETURN datatype IS | AS PL/SQL BLOCK; C. This is the correct syntax for creating a Procedure.The syntax for creating a procedure is: CREATE [OR REPLACE] PROCEDURE [parameter1 [mode1] datatype1, parameter2 [mode2] datatype2, . . .)] IS | AS ... BEGIN ... EXCEPTION END ; Incorrect Answers 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 compilation time. E. The length of the data type is not allowed in the parameter list for functions or procedures. - 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 database. What type of trigger needs to be created? A. DML trigger B. System event trigger C. INSTEAD OF trigger D. Application trigger Answer: B Explanation: 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 at the database level or at the schema level. If the trigger is created at the database level, the trigger is fired for all the users that connect to the database. If the trigger is created at the schema level, the trigger is fired when the user that created the trigger connects to the database. Incorrect Answers 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 TABLE. C. INSTEAD OF TRIGGERS will fire on a view. D. Application trigger - Fires when a particular event occurs in the application. Applicati...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online