- 
                    
When does an on-lock trigger fire ?
It will fires whenever SQL * Forms would normally attempt to lock a row.
 - 
                    
What is the difference between key startup and pre-form ?
Key-startup trigger fires after successful navigation into a form. Pre-form trigger fires before enter into the form.
 - 
                    
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. PACKAGE PROCEDURE & FUNCTION
 - 
                    
What is a Package Procedure ?
A Package procedure is built in PL/SQL procedure.
 - 
                    
What are the different types of Package Procedure ?
1. Restricted package procedure. 2. Unrestricted package procedure.
 - 
                    
What is the difference between restricted and unrestricted package procedure ?
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.
 - 
                    
 - 
                    
 - 
                    
What SYNCHRONIZE procedure does ?
It synchronizes the terminal screen with the internal state of the form.
 - 
                    
What are the unrestricted procedures used to change the popup screen position during run time ?
Anchor-view Resize -View Move-View.
 - 
                    
What Enter package procedure does ?
Enter Validate-data in the current validation unit.
 - 
                    
What is the difference between NAME_IN and COPY ?
Copy is package procedure and writes values into a field.Name in is a package function and returns the contents of the variable to which you apply.
 - 
                    
Identify package function from the following ?
1. Error-Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code 1. Error_Code ...
 - 
                    
What the PAUSE package procedure does ?
Pause suspends processing until the operator presses a function key
 - 
                    
What package procedure is used for calling another form ?
Call (E.g. Call(formname)
 - 
                    
What package procedure used for invoke sql *plus from sql *forms ?
Host (E.g. Host (sqlplus))
 - 
                    
Error_Code is a package proecdure ?
a. True b. false False.
 - 
                    
EXIT_FORM is a restricted package procedure ?
a. True b. False True.
 - 
                    
 - 
                    
List the system variables related in Block and Field?
1. System.block_status 2. System.current_block 3. System.current_field 4. System.current_value 5. System.cursor_block 6. System.cursor_field 7. System.field_status.
 
Oracle Forms Interview Questions

		
Ans