Set - 4

Question 61 :

What is the difference between restricted and unrestricted package procedure ?

Answer :

Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.


Question 62 :

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

Answer :

PRE-QUERY fires once.
POST-QUERY fires 10 times.


Question 63 :

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Answer :

a. ON-INSERT b. POST-INSERT c. PRE-INSERT


Question 64 :

State the order in which these triggers are executed ?

Answer :

POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.


Question 65 :

What the PAUSE package procedure does ?

Answer :

Pause suspends processing until the operator presses a function key