GeekInterview.com
  I am new, Sign me up!
 

Oracle Forms Interview Questions


Oracle Forms Interview Questions

Questions: 66
Comments: 55
 Showing Questions 21-30 of 66 Questions
<< Previous 1 2 [3] 4 5 6 7 Next >>
 Sponsored Links

 
 Oracle Forms Interview Questions
Sorting Options :  

 These triggers are executes when inserting, deleting and updating operations are   performed  and  can  be  used  to  change  the  default  
Latest Answer: hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for ...

 It  fires  when a value in a field has been changed and the field status is changed  or  new  and  the   key has been pressed. If the field status  is 
Latest Answer: on-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate. ...

A query fetched 10 records How many times does a PRE-QUERY Trigger  and POST-QUERY Trigger will get executed ?
 PRE-QUERY fires once.   POST-QUERY fires 10 times. 

What  is  the  difference  between  ON-VALIDATE-FIELD  trigger  and  a POST-CHANGE trigger ?
 When you changes the Existing  value to null, the On-validate field trigger will  fire  post change trigger will not fire. At the time of execute-query post-change trigger will fire, 

What  is  the  difference  between  an ON-VALIDATE-FIELD trigger and a trigger ?
 On-validate-field  trigger  fires,  when the field Validation status New or changed.Post-field-trigger  whenever  the  control  leaving form the field, it will 

 Post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed. 

 When Execute-query or count-query Package procedures are invoked. 
Latest Answer: pre-query trigger fires before any execution of a query.  this trigger fires only once per query. where as post query fires for each row. ...

Give  the  sequence  in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
 a. ON-INSERT b. POST-INSERT c. PRE-INSERT PRE-INSERT,ON-INSERT & POST-INSERT. 

 No. 
Latest Answer: No, we cann't use go_block in pre_field trigger ...

 No. 

View page << Previous 1 2 [3] 4 5 6 7 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape