-
What is a Static Record Group?
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.
-
What are the built-ins used for Creating and deleting groups?
CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)
-
What are the built -ins used for Modifying a groups structure?
ADD-GROUP_COLUMN (function) ADD_GROUP_ROW (procedure) DELETE_GROUP_ROW(procedure)
-
What are the built-ins used for Getting cell values?
GET_GROUP_CHAR_CELL (function) GET_GROUP_DATE_CELL(function) GET_GROUP_NUMBET_CELL(function)
-
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-ins used for finding Object ID function?
FIND_GROUP(function) FIND_COLUMN(function)
-
-
What are the built-in used for getting cell values?
Get_group_char_cell(function)Get_group_date_cell(function)Get_group_number_cell(function)
-
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 the built-ins used for finding object ID functions?
Find_group(function)Find_column(function)
-
-
-
What are different types of modules available in oracle form?
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
-
-
What are the default extensions of the files created by library module?
The default file extensions indicate the library module type and storage format.pll - pl/sql library module binary
-
What are the various sub events a mouse double click event involves?
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
-
State any three mouse events system variables?
System.mouse_button_pressedSystem.mouse_button_shift_statesystem.mouse_itemsystem.mouse_canvassystem.mouse_record
-
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). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False
-
-
Oracle Concepts Interview Questions
Ans