Oracle Forms 3.0 Interview Preparation Guide Download PDF
Oracle Forms 3.0 guideline for job interview preparation. Explore list of Oracle Forms 3.0 frequently asked questions(FAQs) asked in number of Oracle Forms 3.0 interviews. Post your comments as your suggestions, questions and answers on any Oracle Forms 3.0 Interview Question or answer. Ask Oracle Forms 3.0 Question, your question will be answered by our fellow friends.
24 Oracle Forms 3.0 Questions and Answers:
Table of Contents
1 :: Explain What is the significance of PAGE 0 in forms 3.0?
Hide the fields for internal calculation.
2 :: Explain What is an Alert?
An alert is window that appears in the middle of the screen overlaying a portion of the current display.
3 :: Explain What SYNCHRONIZE procedure does?
It synchronizes the terminal screen with the internal state of the form.
4 :: Explain How do we trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
5 :: Explain What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS?
These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.
6 :: How to execute the user defined triggers in forms 3.0?
Execute Trigger (trigger-name)
7 :: Explain What are the types of Pop-up window?
the pop-up field editor
pop-up list of values
pop-up pages.
Alert
pop-up list of values
pop-up pages.
Alert
8 :: Explain What Enter package procedure does?
Enter Validate-data in the current validation unit.
9 :: Explain What package procedure used for invoke sql *plus from sql *forms?
Host (E.g. Host (sqlplus))
10 :: Explain What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger?
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.
Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.
11 :: Explain What is an User Exits?
A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.
12 :: Explain What is an SQL *FORMS?
SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.
13 :: Explain What package procedure is used for calling another form?
Call (E.g. Call(formname)
14 :: Explain What are the types of TRIGGERS?
1. Navigational Triggers.
2. Transaction Triggers.
2. Transaction Triggers.
16 :: Explain What are the main types of TRIGGERS?
1)Block processing trigger
2)Interface event trigger
3)Message-handling trigger
4)Validation trigger
5)Navigation trigger
6)Trancation trigger
7)Query_time trigger
2)Interface event trigger
3)Message-handling trigger
4)Validation trigger
5)Navigation trigger
6)Trancation trigger
7)Query_time trigger
17 :: Explain What is a Package Procedure?
A Package procedure is built in PL/SQL procedure.
18 :: Explain What ERASE package procedure does?
Erase removes an indicated global variable.
20 :: Explain What is the maximum size of a form?
255 character width and 255 characters Length.
21 :: Explain When does an on-lock trigger fire?
It will fires whenever SQL * Forms would normally attempt to lock a row.
22 :: Explain 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.
Name in is a package function and returns the contents of the variable to which you apply.
23 :: Explain What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
24 :: Explain When is PRE-QUERY trigger executed?
When Execute-query or count-query Package procedures are invoked.