Explore topic-wise InterviewSolutions in .

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.

Before FORM , After form , Before REPORT, Between PAGE, After report.

Before form , After form , Before report, Between page, After report.

Bind reference are USED to replace the single VALUE in SQL, pl/sql statements a bind reference can be created using a (:) before a COLUMN or a PARAMETER name.

Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.

Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. One must always DROP existing SEQUENCES before re-importing. If the sequences are not DROPPED, they will generate numbers inconsistent with the rest of the DATABASE. 

Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. One must always DROP existing Sequences before re-importing. If the sequences are not dropped, they will generate numbers inconsistent with the rest of the database. 

By setting the ACTION associated with BUTTON to Execute pl/sql OPTION and USING the SRW.Run_report function.

By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

By USING SRW.MESSAGE FUNCTION.

By using SRW.MESSAGE function.

By USING the LINK file property in the layout BOILER PLATE property sheet.

By using the link file property in the layout boiler plate property sheet.

By using the rectangle TOOL while pressing the (CONSTRAINT) key.

By using the rectangle tool while pressing the (Constraint) key.

By USING the STATEMENT EXECIAFGET & EXECIAFPUT.

By using the statement EXECIAFGET & EXECIAFPUT.

By USING the tables/columns BUTTON and then SPECIFYING the table and the COLUMN NAMES.

By using the tables/columns button and then specifying the table and the column names.

CALLS the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your CURRENT oracle FORMS executable.

Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

Canvas views are the back ground objects on which you PLACE the interface ITEMS (Text items), check BOXES, radio GROUPS etc., and boilerplate objects (boxes, lines, images etc.,) that OPERATORS interact with us they run your form . Each canvas views displayed in a window.

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc., and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

• CASCADE, 
• ISOLATE, 
• Non-isolate.

• CONTENT canvas VIEWS,
• Stacked canvas views, 
• Horizontal TOOLBAR, 
• vertical toolbar.

• CREATE-GROUP (FUNCTION),
• CREATE_GROUP_FROM_QUERY(function),
• DELETE_GROUP(PROCEDURE).

DOUBLE CLICKING the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

A HIDDEN COLUMN is USED to when a column has to EMBED into BOILERPLATE text.

A hidden column is used to when a column has to embed into boilerplate text.

A placeholder COLUMN is used to hold calculated values at a SPECIFIED place rather than ALLOWING is to appear in the ACTUAL row where it has to appear.

A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.

By DRAGGING the COLUMN OUTSIDE the GROUP.

By dragging the column outside the group.

False.

False.

False.

False.

• FIND_GROUP(FUNCTION),
• FIND_COLUMN(function).

• Find_group(FUNCTION),
• Find_column(function).

• find_timer,
• create_timer,
• delete_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.

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_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 REPORTS 2.0 the link tool has to be selected and then two FIELDS to be LINKED are selected and the link is AUTOMATICALLY created. In Reports 2.5 the first field is selected and the link tool is then used to link the first field to the SECOND field.

In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In Reports 2.5 the first field is selected and the link tool is then used to link the first field to the second field.

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
---------------------------------------------------------- 

Master Deletes PROPERTY RESULTING TRIGGERS
----------------------------------------------------------- 

• ISOLATED On-Clear-Details,
• On-Populate-Details.

Master Deletes Property Resulting Triggers
----------------------------------------------------------- 

Master DELETES Property RESULTING TRIGGERS
---------------------------------------------------------- 

• Non-Isolated(the DEFAULT) On-Check-Delete-Master,
• On-Clear-Details, 
• On-Populate-Details.

Master Deletes Property Resulting Triggers
----------------------------------------------------------