-
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