Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 36 of 95
26. What is Post-Block is a . a. Navigational Trigger. b. Key trigger c. Transaction Trigger. Navigational Trigger. 27. What is the difference between keystartup and pre-form ? Key-startup trigger fires after successful navigation into a form. Pre-form trigger fires before enter into the form. 28. What is the difference between keystartup and pre-form ? Key-startup triigger fires after successful navigation into a form. Pre-form trigger fires before enter into the form. PACKAGE PROCEDURE & FUNCTION 29. What is a Package Procedure ? A Package proecdure is built in PL/SQL procedure. 30. What are the different types of Package Procedure ? 1. Restricted package procedure. 2. Unrestricted package proecdure. 31. What is the difference between restricted and unrestricted package procedure ? Restricted package procedure that affects the basic basic functions of SQL * Forms. It cannot used in all triggers execpt key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers. 32. Classify the restricted and unrestricted procedure from the following. a. Call b. User-Exit c. Call-Query d. Up e. Execute-Query f. Message g. Exit-From h. Post i. Break a. Call - unrestricted b. User Exit - Unrestricted c. Call_query - Unrestricted d. Up - Restricted e. Execute Query - Restricted f. Message - Restricted g. Exit_form - Restricted |