Part-15

What is the use of transactional triggers? -
Using transactional triggers we can control or modify the default functionality of the oracle forms.

How do you create a new session while open a new form? -
Using open_form built-in setting the session option Ex. Open_form (’Stocks ‘,active,session).


What are the ways to monitor the performance of the report? -
Use reports profile executable statement. Use SQL trace facility.


If two groups are not linked in the data model editor, What is the hierarchy between them? - Two group that is above are the left most rank higher than the group that is to right or below it.


An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form? - True


Explain about horizontal, Vertical tool bar canvas views? -
Tool bar canvas views are used to create tool bars for individual windows. Horizontal tool bars are display at the top of a window, just under its menu bar. Vertical Tool bars are displayed along the left side of a window


What is the purpose of the product order option in the column property sheet? -
To specify the order of individual group evaluation in a cross products.


What is the use of image_zoom built-in? -
To manipulate images in image items.


How do you reference a parameter indirectly? -
To indirectly reference a parameter use the NAME IN, COPY ‘built-ins to indirectly set and reference the parameters value’ Example name_in (’capital parameter my param’), Copy (’SURESH’,'Parameter my_param’)


What is a timer? -
Timer is an “internal time clock” that you can programmatically create to perform an action each time the times.


What are the two phases of block coordination? -
There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated with the new master record. These operations are accomplished through the execution of triggers.