Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-3

1. What is trigger associated with the timer?
When-timer-expired.

2. When a form is invoked with call_form, Does oracle forms issues a save point?
Yes

3. What is new_form built-in?
When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second. If there are changes pending in the first form, the operator will be prompted to save them before the new form is loaded.

4. Can you execute a DDL statements from Oracle Forms?
No. DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported from Forms because your Oracle Forms are not suppose to manipulate the database structure.

A statement like CREATE TABLE X (A DATE); will result in error:
Encountered the symbol "CREATE" which is a reserved word.

However, you can use the FORMS_DDL built-in to execute DDL statements. Eg:
FORMS_DDL('CREATE TABLE X (A DATE)');

5. Can you execute dynamic SQL from Oracle Forms?
Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg:
FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')');
Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.

6. What is the difference between the following statements?
Form A: Insert into emp(ename) values ('Scott ');
Form B: FORMS_DDL('insert into emp(ename) values('||''Scott')');

User have to commit the form manually for Form A
Once the Form B statement executes, it will be implicitly commited.

7. What are the vbx controls?
Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.

8. What is the "LOV of Validation" Property of an item? What is the use of it?
When LOV for Validation is set to True, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV. Whenever the validation event occurs. If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally. If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.

9. How do you use the same lov for 2 columns?
We can use the same lov for 2 columns by passing the return values in global values and using the global values in the code

10. What are the difference between lov & list item?
Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.

Other Articles Related To Oracle Forms:

1. How To Find Last Query Executed On The Oracle Form | Oracle Forms Interview Questions.
2. How To Find Oracle Forms(fmb/fmx) Version
3. Oracle Forms 6i Tutorial
4. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-1
5. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-2
6. Oracle Forms Interview Questions & Answers - Oracle Forms FAQ- Part-4