Explore topic-wise InterviewSolutions in .

A PHYSICAL page is a SIZE of a page. That is OUTPUT by the printer. The logical page is the size of one page of the ACTUAL report as seen in the Previewer.

A physical page is a size of a page. That is output by the printer. The logical page is the size of one page of the actual report as seen in the Previewer.

A property clause is a named OBJECT that contains a LIST of properties and their SETTINGS. Once you create a property clause you can BASE other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

A property clause is a named object that contains a list of properties and their settings. Once you create a property clause you can base other object on it. An object based on a property can inherit the setting of any property in the clause that makes sense for that object.

A record group is an internal Oracle Forms that STRUCTURE that has a column/row framework SIMILAR to a database table. HOWEVER, unlike database tables, record GROUPS are separate objects that belong to the form module which they are defined.

A record group is an internal Oracle Forms that structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to the form module which they are defined.

A static RECORD GROUP is not associated with a query, RATHER, you define its structure and row values at design time, and they remain FIXED at runtime.

A static record group is not associated with a query, rather, you define its structure and row values at design time, and they remain fixed at runtime.

A user named editor has the same TEXT editing functionality as the default editor, but, because it is a named OBJECT, you can SPECIFY editor attributes such as windows DISPLAY size, POSITION, and title.

A user named editor has the same text editing functionality as the default editor, but, because it is a named object, you can specify editor attributes such as windows display size, position, and title.

A WAY in which to pass control (and possibly arguments ) form Oracle report to ANOTHER Oracle products of 3 GL and then RETURN control ( and ) back to Oracle REPORTS.

A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

• ADD-GROUP_COLUMN (FUNCTION)
• ADD_GROUP_ROW (PROCEDURE)
• DELETE_GROUP_ROW(procedure)

After the QUERY is EXECUTED but before the REPORT is executed and the RECORDS are DISPLAYED.

After the query is executed but before the report is executed and the records are displayed.

An LOV is a SCROLLABLE popup window that PROVIDES the operator with EITHER a single or MULTI column selection LIST.

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

An object group is a container for a group of OBJECTS; you DEFINE an object group when you want to package RELATED objects, so that you copy or REFERENCE them in other MODULES.

An object group is a container for a group of objects; you define an object group when you want to package related objects, so that you copy or reference them in other modules.

An Ole SERVER application creates ole Objects that are embedded or linked in ole Containers EX. Ole SERVERS are ms_word & ms_excel. OLE containers provide a PLACE to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.

Any EVENT that MAKES a different record in the MASTER block the CURRENT record is a coordination causing event.

Any event that makes a different record in the master block the current record is a coordination causing event.

At the CLIENT.

At the client.

At the SERVER.

At the server.

Because for each query, REPORT has to OPEN a SEPARATE cursor and has to REBIND, execute and fetch DATA

Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data

False

False

False

False

Find_group(FUNCTION)

Find_column(function)

Find_group(function)

Find_column(function)

find_timercreate_timerdelete_timer

find_timercreate_timerdelete_timer

Fires during the execute query and COUNT query processing after oracle forms constructs the select statement to be ISSUED, but before the statement is ACTUALLY issued. The pre-query trigger fires just before oracle forms issues the select statement to the DATABASE after the operator as define the example RECORDS by entering the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode.Pre-query trigger fires before pre-select trigger.

FIRES when ORACLE forms first marks a record as an insert or an update. The trigger fires as SOON as oracle forms determines through validation that the record should be PROCESSED by the next post or commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

For a modelless WINDOW, it determines whether oracle forms HIDES the window automatically when the OPERATORS NAVIGATES to an item in the another window.

For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

Form module - a collection of objects and CODE routines Menu modules - a collection of menus and menu item COMMANDS that together make up an application menu library module - a collection of user named PROCEDURES, FUNCTIONS and PACKAGES that can be called from other modules in the application

Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

FORMAT TRIGGER.

Format trigger.

Four

Four

• GET_GROUP_CHAR_CELL (FUNCTION)
• GET_GROUPCELL(function)
• GET_GROUP_NUMBET_CELL(function)

• Get_group_char_cell(FUNCTION)
• Get_groupcell(function)
• Get_group_number_cell(function)

• GET_GROUP_ROW_COUNT(FUNCTION)
• GET_GROUP_SELECTION_COUNT(function)
• GET_GROUP_SELECTION(function)
• RESET_GROUP_SELECTION(PROCEDURE)
• SET_GROUP_SELECTION(procedure)
• UNSET_GROUP_SELECTION(procedure)

• Get_group_row_count(FUNCTION)
• Get_group_selection_count(function)
• Get_group_selection(function)
• Reset_group_selection(PROCEDURE)
• Set_group_selection(procedure)
• Unset_group_selection(procedure)

get_lov_property

set_lov_property

get_lov_property

set_lov_property

Get_view_property, Set_view_property

Get_view_property, Set_view_property

In ORACLE forms, Embedded objects become part of the FORM module, and LINKED objects are references from a form module to a linked source FILE.

In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

In Pl/Sql, You can REFERENCE and SET the values of form PARAMETERS using bind variables syntax. EX. PARAMETER name = '' or :block.item = PARAMETER Parameter name

In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

In PLACE activationExternal ACTIVATION

In place activationExternal activation

ISSUES DYNAMIC Sql statements at run TIME, including SERVER side pl/SQl and DDL

Issues dynamic Sql statements at run time, including server side pl/SQl and DDL

It allows you to READ and write INFORMATION to a FILE in the file SYSTEM.

It allows you to read and write information to a file in the file system.

It is a command LINE argument that ALLOWS you to specify a file that contain a SET of arguments for r20run.

It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

It is a terminal SCREEN with the internal state of the form. It updates the screen display to REFLECT the information that oracle FORMS has in its internal REPRESENTATION of the screen.

It is a terminal screen with the internal state of the form. It updates the screen display to reflect the information that oracle forms has in its internal representation of the screen.

It represents the COORDINATION causing event that occur on the MASTER BLOCK in master-detail RELATION.

It represents the coordination causing event that occur on the master block in master-detail relation.

Lexical reference is place_holder for text that can be EMBEDDED in a sql statements. A lexical reference can be created USING & before the COLUMN or parameter NAME.

Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.

Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a LIBRARY, you can attach it to any other FORM, menu, or library modules. When you can call library program units from triggers menu items COMMANDS and user NAMED routine, you write in the modules to which you have attach the library. When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.

Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, menu, or library modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.

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.

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.

Master Deletes PROPERTY Resulting TRIGGERS
---------------------------------------------------
CASCADING On-Clear-Details
On-Populate-Details
Pre-delete

Master Deletes Property Resulting Triggers
---------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete

MASTER Deletes Property RESULTING TRIGGERS
---------------------------------------------------
Isolated On-Clear-Details
On-Populate-Details

Master Deletes Property Resulting Triggers
---------------------------------------------------
Isolated On-Clear-Details
On-Populate-Details

MASTER DELETES Property Resulting TRIGGERS
----------------------------------------------------
Non-Isolated(the DEFAULT) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details

Master Deletes Property Resulting Triggers
----------------------------------------------------
Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details

Modal windows are usually used as dialogs, and have restricted FUNCTIONALITY compared to modelless windows. On some PLATFORMS for EXAMPLE operators cannot resize, SCROLL or iconify a modal WINDOW.

Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

Modalless WINDOWS

MODAL windows

Modalless windows

Modal windows

no

no

No

No

ONE down REPEATING FRAME below one ACROSS repeating frame.

One down repeating frame below one across repeating frame.