10 Apr, 2007
Database Interview Questions
- How is link tool operation different bet. reports 2 & 2.5? - 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 2.5 the first field is selected and the link tool is then used to link the first field to the second field.
- What are the different styles of activation of ole Objects? - In place activation, External activation
- How do you reference a Parameter? - 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
- What is the difference between object embedding & linking in Oracle forms? - 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.
- Name of the functions used to get/set canvas properties? - Get_view_property, Set_view_property
- What are the built-ins that are used for setting the LOV properties at runtime? - get_lov_property set_lov_property
- What are the built-ins used for processing rows? - 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)
- What are built-ins used for Processing rows? - 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)
- What are the built-in used for getting cell values? - Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)
- What are the built-ins used for Getting cell values? - GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)
- A tleast how many set of data must a data model have before a data model can be base on it? - Four
- To execute row from being displayed that still use column in the row which property can be used? - Format trigger.
