Oracle Forms Interview Questions|2021

667 Views

SaveSavedRemoved 1

image 49 Oracle Forms Interview Questions 1

Before we see Oracle Forms Interview Questions let’s get some background. Oracle Forms is a great UI development tool from Oracle Corp and has been in use for decades. It is very useful to develop on-premise custom screen for transaction handling and processing.

Oracle forms was also called developer 2000 in early days and releases like forms 6i and forms 9i were major.

Now with web technologies taking precedence oracle forms also run via java runtime and can be easily rendered in internet browsers.

Considering forms being widely used stand alone and with Oralce Ebusiness suite customizations, Forms skills are still in demand. And as many customers may prefer moving there existing applications to cloud infrastructure , developers with this skill will be needed.

So lets see some Oracle Forms Interview Questions which are being asked or can be framed around in 2021 and after.

Latest Oracle Forms Interview Questions| 2021
Frequently Asked

Table of Contents

Latest Oracle Forms Interview Questions| 2021

What is Latest release of oracle forms?

As of 2021 Oracle Forms 11g is the latest one available.
https://www.oracle.com/application-development/technologies/forms/10g-forms.html

What are the new features of Forms 11g ?

Forms 11 g supports new features like

“JavaScript Integration”
“Enhanced Java Support”
“Support for Server-Side Events”
“Proxy User Support”
“PL/SQL Tracing”
“Integration with Oracle Diagnostics and Logging (ODL)”

How can JavaScript integration with oracle forms help?

With Javascript, you can have external events call into your Forms applet, or have your Forms applet execute a JavaScript event.
Earlier it was very complex to call a webpage showing forms. It was also not possible to call from the Web page into Forms, perhaps to update a value acquired from an HTML form.
Read more here https://docs.oracle.com/cd/E15523_01/web.1111/e10240/whats_new.htm#FSDEP102

What is PL SQL Tracing in Forms?

Forms 11g supports tracing where you can enable logging of the names and parameters for called PL/SQL Procedures and functions. The output can be seen in the Forms Trace.

What is the difference between Oracle Forms Developer and Forms Services?

Oracle Forms Developer is used to develop a form that can access an Oracle database and present the data whereas Oracle Forms Services is an application framework to deploy Forms-based applications in a multi-tiered environment.
The Form applications that we build in Oracle Forms Developer are deployed on Oracle Fusion Middleware. These applications run on the middle tier. The UI is on the client tier as a Java applet in the client’s browser.

In which tier the forms services reside?

Forms services are deployed in the middle tier.

What are the 2 components of Oracle Forms Services ?

the three-tier configuration for running a form consists of

Client– On the client tier
Forms Listener servlet– On the middle tier
Forms Runtime process– On the middle tier

At what all levels trigger can be written in Forms ?

Triggers can be written at
Form Level
Block Level
Record level
Item Level

What is difference between POST query and Pre query trigger?

Pre query fires once while post query fires for each record.

How do you create Apps Standard Forms?

Apps Standard forms used in oracle EBS can be created using TEMPLATE.fmb

Explain the difference between OPEN_FORM, CALL_FORM and NEW_FORM commands?

OPEN_FORM: It opens a new form without closing the calling form.
CALL_FORM: It opens a new form that takes control from the calling form.
NEW_FORM: It closes the current form and replaces it with the new called form

What are record groups?

Record groups are select statements that are tied with LOVs to show valid values.

How to automate database connection while launching form?

We can write connection information in on-logon trigger.

How do you generater forms executable from fmb files?

By using f60gen command.

f60gen module=form_name.fmb userid=apps/apps output_file=form_name.fmx module_type=form batch=yes compile_all=special

What are Key Triggers?

A key trigger is a trigger that is executed on the happening of a certain event. In the case of a key trigger, Any event can have a key trigger associated with it. In the case of a key trigger, the event is pressing the function key for which the trigger is defined. We can write our logic in the key triggers.
e.g COMMIT_FORM key trigger is KEY_COMMIT.

What is the difference between CONTENT canvas and STACKED canvas?

Content canvas is the default canvas to display the blocks while stacked canvas can be multiple canvases in a window.

Frequently Asked

What are the sequence of firing triggers?

The sequence of firing in forms is:

Pre-Logon
On-Logon
Post-Logon
Pre-Form
When-Create-record
Pre-Block
Pre-Record
Pre-Text-item

Can you use DDL commands in forms runtime?

Yes, By using FORMS_DDL

What are the forms runtime modes?

Normal mode, Query mode.

How to display a modal window?

Modal windows can be displayed by using ALERT command.

What are Form Parameters?

Form Parameters can be used to call forms at runtime with specific values which are used in forms execution.

How do you create dependent value sets?

By using $Flex$ we can reference parent value set.

What is difference between Post-form-commit and post-database-commit trigger?

The post-form-commit trigger fires after the transactions with inserts, updates, and deletes have been posted to the database but before the transactions have been finalized in the issuing the command.
The post-database-commit trigger fires after the oracle form issues the commit to finalized transactions.

What are the triggers created when creating master details block?

The 3 triggers created are
On-Check_delete_master
On_clear_details and
On_populate_details

What are user-defined triggers? How do you execute them?

User defined trigger are custom trigger which we can give a custom name. These triggers need to be explicitly called with execute_trigger9trigger_name) command.

What is Form Personalization?

Form personalization is used in EBS to to some basic changes to the form functionality without customization.

Explain Zoom Functionality in Forms?

Zoom is a standard function that can be used to call a new form from a form.
We need to customize CUSTOM.PLL with condition that if it’s true make zoom available.