Explore topic-wise InterviewSolutions in .

Only one WINDOW in a form can DISPLAY the CONSOLE, and you cannot CHANGE the console assignment at RUNTIME.

Only one window in a form can display the console, and you cannot change the console assignment at runtime.

Oracle PRECOMPILER EXITS, Oracle call INTERFACE, NonOracle user exits.

Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

PARAMETERS provide a SIMPLE mechanism for defining and setting the valuesof inputs that are required by a FORM at startup. Form parameters are VARIABLES of type char,number,date that you define at design time.

Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

PERCENTAGE of TOTAL FUNCTIONS.

percentage of total functions.

PERFORMING the CALCULATION in the QUERY is FASTER.

performing the calculation in the query is faster.

Pop_listText_listCombo BOX

Pop_listText_listCombo box

Post-form COMMIT fires once during the post and commit transactions PROCESS, after the database commit occurs. The post-form-commit trigger fires after 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 oracle forms issues the commit to finalized transactions.

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after 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 oracle forms issues the commit to finalized transactions.

Previewer

Previewer

• QUERY RECORD GROUPS
• NonQuery Record Groups
• STATE Record Groups

READ only

Read only

Record GROUP COLUMN NAMES cannot EXCEED 30 CHARACTERS.

Record group column names cannot exceed 30 characters.

Removes the source code from the library file and generates a library FILES that CONTAINS only pcode. The resulting file can be USED for final deployment, but can not be SUBSEQUENTLY edited in the designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file

Removes the source code from the library file and generates a library files that contains only pcode. The resulting file can be used for final deployment, but can not be subsequently edited in the designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file

REP FILE and RDF file.

Rep file and Rdf file.

1. set_item_property
2. get_item_property
3. (by SETTING the LOV_NAME PROPERTY)

Show editor is the generic built-in which ACCEPTS any editor NAME and takes some INPUT string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the TEXT item before the built-in is executed.

Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the text item before the built-in is executed.

STACKED CANVAS view is displayed in a WINDOW on TOP of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas VIEWS obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

SUMMARY, FORMULA, PLACEHOLDER COLUMN.

Summary, Formula, Placeholder column.

System.mouse_button_pressedSystem.mouse_button_shift

System.mouse_button_pressedSystem.mouse_button_shift

TEXT ParametersData PARAMETERS

Text ParametersData Parameters

The console INCLUDES the STATUS LINE and message line, and is displayed at the bottom of the window to which it is assigned.To SPECIFY that the console should be displayed, SET the console window form property to the name of any window in the form. To include the console, set console window to Null.

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

The coordination PROPERTIES are

• Deferred
• Auto-Query

These Properties DETERMINE when the population PHASE of block coordination should OCCUR.

The coordination properties are

These Properties determine when the population phase of block coordination should occur.

The DEFAULT FILE extensions indicate the library module TYPE and storage format .pll - pl/sql library module BINARY

The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary

The pop LIST style list ITEM appears INITIALLY as a SINGLE field (similar to a text item field). When the operator SELECTS the list icon, a list of available choices appears.

The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.

The TERM FILE which KEY is correspond to which ORACLE REPORT functions.

The term file which key is correspond to which oracle report functions.

The TERM is terminal DEFINITION FILE that describes the terminal form which you are USING r20run.

The term is terminal definition file that describes the terminal form which you are using r20run.

The text list STYLE list ITEM appears as a rectangular box which displays the fixed number of VALUES. When the text list contains values that can not be displayed, a vertical SCROLL bar appears, ALLOWING the operator to view and select undisplayed values.

The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.

There are three most common types of complex MASTER-DETAIL relationships:

• master with dependent details
• master with independent details
• detail with two MASTERS

There are three most common types of complex master-detail relationships:

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.

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.

Timer is an "INTERNAL TIME CLOCK" that you can programmatically create to PERFORM an ACTION each time the times.

Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.

True

True

Use REPORTS profile executable STATEMENT. Use SQL TRACE FACILITY.

Use reports profile executable statement. Use SQL trace facility.

Using open_form built-in setting the session option Ex. Open_form('Stocks ',ACTIVE, session). when INVOKE the MULTIPLE forms with open form and call_form in the same application, state whether the following are true/False

Using open_form built-in setting the session option Ex. Open_form('Stocks ',active, session). when invoke the multiple forms with open form and call_form in the same application, state whether the following are true/False

Using TRANSACTIONAL triggers we can control or modify the DEFAULT functionality of the oracle FORMS.

Using transactional triggers we can control or modify the default functionality of the oracle forms.

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.

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.

VIEW by STRUCTURE.

view by structure.

Visual ATTRIBUTES are the FONT, color, pattern proprieties that you set for form and menu objects that appear in your APPLICATION INTERFACE.

Visual attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.

When confine MODE is on, an object cannot be moved outside its parent in the LAYOUT.

When confine mode is on, an object cannot be moved outside its parent in the layout.

When FLEX MODE is on, reports AUTOMATICALLY resizes the parent when the child is resized.

When flex mode is on, reports automatically resizes the parent when the child is resized.

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.

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.

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.

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.

When the value of a data PARAMETER being passed to a called product is always the name of the record GROUP DEFINED in the current form. Data parameters are USED to pass data to products INVOKED with the run_product built-in subprogram.

When the value of a data parameter being passed to a called product is always the name of the record group defined in the current form. Data parameters are used to pass data to products invoked with the run_product built-in subprogram.

When_window_activated

When_window_closed

When_window_deactivated

When_window_resized

Within this triggers, you can examine the BUILT in system variable system. event_window to determine the NAME of the WINDOW for which the TRIGGER fired.

When_window_activated

When_window_closed

When_window_deactivated

When_window_resized

Within this triggers, you can examine the built in system variable system. event_window to determine the name of the window for which the trigger fired.

When-image-activated FIRES when the OPERATORS double clicks on an image itemwhen-image-pressed fires when an OPERATOR clicks or double clicks on an image ITEM

When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

When-timer-expired.

When-timer-expired.