Here is a collection of Technical Job Interview Questions on “Oracle Forms 3.0″
Explain the points of difference between ON-VALIDATE-FIELD trigger and POST-CHANGE Trigger.
Describe the points of difference betweeen a trigger and ON-VALIDATE-FIELD trigger.
Describe the points of difference between a POST-CHANGE trigger and POST-FIELD trigger.
What is the purpose of ERASE package procedure?
When do we use teh PRE-QUERY trigger?
Explain the difference between COPY and NAME_IN.
Is it possible to use a GO-BLOCK package in a pre-field trigger?
When does the execution of ON-VALIDATE-FIELD take place?
How are errors in form 3.0 trapped?
What system variables are there in Block and field?
Explain the difference between system.cursor_field and system.current_field.
What do you mean by an Alert?
When is the on-clear-block trigger executed?
When are the following triggers fired: On-insert, post-insert, pre-insert
Explain the purpose of ON-INSERT trigger.
Why is ON-DELETE and ON-UPDATE trigger used?
Explain the sequence in which triggers are fired.
How is a function key trigger different from key function trigger?
Explain various types of key triggers.
What do you mean by a trigger?
Is it mandatory to specify the join condition during the master/detail relations between two blocks?
Is it possible to have two blocks with same name in form 3.0?
What do you mean by Committed block?
How are constraints controlled in forms?
Which files are generatd when we create a form with filex extension?
What can be the maximum form size?
What do you understand by SQL *FORMS?
Is it possible to call a form on a form?
How is a form called from a form?
Explain the various types of triggers.
How many times will the pre query and post query trigger be fired if 10 records are fetched by a query?
Explain the various types of pop window.
Explain the Synchronize procedure.
Explain Enter package procedure.
Why is Page 0 important?
What is a page?
What is meant by User Exit?
What procedures are used to vary the runtime popup screen position?
Are all fields removed after a page is deleted?
What are the various Package Procedures?
Explain the difference between keystartup and pre-form.
What is EXIT_FORM procedure?
Explain the uses of on-lock trigger, Pause Package procedure, Post Block and key startup trigger.
How can we invoke sql *plus from sql *forms? Which package procedure can be used for this?
How are command Post and COMMIT different from each other?
See all types of Oracle Apps Technical Interview Questions, practice test questions and other sample preparation resources here.