P2Pprogrammer 2 programmer

Home > Interview Question and Answer > Oracle > Oracle Forms 4.5, 6i

Interview Questions and Answers for Oracle D2k Forms 4.5, 6i

Oracle Forms 4.5 Interview Questions and Answers, Oracle Forms 6i Interview Questions and Answers, D2K Interview Questions and Answers. Oracle D2K Forms 4.5 Interview Questions and Answers includes, object groups, canvas views, canvas properties, different modals of windows, display console on a window, remove on exit property, different types of modules available in oracle form, master detail relationship, coordination types of Complex master-detail relationships, User-Named Editor, Built-ins, LOV of Validation, record group, Record group Column, Query Record Group, Non Query Record Group, Static Record Group, parameters,

Oracle Forms 4.5, 6i Interview Questions and Answers

1. What is an object groups?

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 another modules.

2. What are the different objects that you cannot copy or reference in object groups?

  1. objects of differnt modules
  2. another object groups
  3. individual block dependent items
  4. program units.

3. What are different types of canvas views?

  1. Content canvas views
  2. Stacked canvas views
  3. Horizontal toolbar
  4. Vertical toolbar.

4. Explain about content canvas views?

Most Canvas views are content canvas views a content canvas view is the "base" view that occupies the entire content pane of the window in which it is displayed.

5. Explain about stacked canvas views?

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.

6. Explain about horizontal, vertical tool bar canvas views?

  1. Tool bar canvas views are used to create tool bars for individual windows
  2. Horizontal tool bars are display at the top of a window, just under its menu bar.
  3. Vertical Tool bars are displayed along the left side of a window

7. Name of the functions used to get/set canvas properties?

Get_view_property, Set_view_property

8. What is relation between the window and canvas views?

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

9. What are the different modals of windows?

Modalless windows and Modal windows

10. What are modalless windows?

More than one modelless window can be displayed at the same time, and operators can navigate among them if your application allows them to do so . On most GUI platforms, modelless windows can also be layered to appear either in front of or behind other windows.

11. What are modal windows?

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.

12. How do you display console on a window?

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.

13. What is the remove on exit property?

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

14. How many windows in a form can have console?

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

15. Can you have more than one content canvas view attached with a window?


Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulate contant canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

16. What is the different window events activated at runtimes?


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.

17. What are different types of modules available in oracle form?

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

18. What are the default extensions of the files careated by forms modules?

.fmb - form module binary
.fmx - form module executable

19. What are the default extentions of the files created by menu module?

.mmb and .mmx

20. What is the default extension 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

21. What is a master detail relationship?

A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.

22. What is coordination Event?

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

23. What are the two phases of block coordination?

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 witjh the new master record. These operations are accomplished through the execution of triggers.

24. What are Most Common types of Complex master-detail relationships?

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

  1. Master with dependent details
  2. Master with independent details
  3. Detail with two masters

25. What are the different types of Delete details we can establish in Master-Details?

  1. Cascade
  2. Isolate
  3. Non-isolote

26. What are the different defaust triggers created when Master Deletes set to Non-isolated, Cascade or Isolated ?

1. Master Delets Property Resulting Triggers is set to Non-isolated ?
    Non-Isolated (the default) On-Check-Delete-Master

2. What is the different default triggers created when Master Deletes Property is set to Cascade?
    Cascading On-Clear-Details

3. What is the different default triggers created when Master Deletes Property is set to isolated?
    Isolated On-Clear-Details

27. What are the Coordination Properties in a Master-Detail relationship?

The coordination properties are Deferred and Auto-Query

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

28. What is the User-Named Editor?

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

29. What are the Built-ins to display the user-named editor?

A user named editor can be displayed programmatically with the built in procedure SHOW-EDITOR, EDIT_TETITEM independent of any particular text item.

30. What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

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

31. What is an LOV?

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

32. What is the basic data structure that is required for creating an LOV?

Record Group.

33. What is the "LOV of Validation" Property of an item? What is the use of it?

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.

34. What are the built_ins used the display the LOV?

Show_lov and List_values

35. What are the built-ins that are used to Attach an LOV programatically to an item?

set_item_property and get_item_property
(by setting the LOV_NAME property)

36. What are the built-ins that are used for setting the LOV properties at runtime?

get_lov_property and set_lov_property

37. What is a record group?

A record group is an internal Oracle Forms that structure that hs 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.

38. How many numbers of columns a record group can have?

A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE provided that the total number of column does not exceed 64K.

39. What is the Maximum allowed length of Record group Column?

Record group column names cannot exceed 30 characters.

40. What are the different types of Record Groups?

Query Record Groups, NonQuery Record Groups and State Record Group

41. What is a Query Record Group?

A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced in the SELECT statement. The records in query record group are the rows retrieved by the query associated with that record group.

42. What is a Non Query Record Group?

A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime.

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

44. What are the built-ins used for Creating and deleting groups?

  1. CREATE-GROUP (function)
  3. DELETE_GROUP (procedure)

45. What are the built -ins used for Modifying a group's structure?

  1. ADD-GROUP_COLUMN (function)
  2. ADD_GROUP_ROW (procedure)
  3. DELETE_GROUP_ROW (procedure)
  4. POPULATE_GROUP (function)
  6. SET_GROUP_CHAR_CELL (procedure)
  7. SET_GROUP_DATE_CELL (procedure)
  8. SET_GROUP_NUMBER_CELL (procedure)

46. What are the built-ins used for getting cell values?

  1. GET_GROUP_CHAR_CELL (function)
  2. GET_GROUP_DATE_CELL (function)
  3. GET_GROUP_NUMBET_CELL (function)

47. What are built-ins used for processing rows?

  1. GET_GROUP_ROW_COUNT (function)
  3. GET_GROUP_SELECTION (function)
  4. RESET_GROUP_SELECTION (procedure)
  5. SET_GROUP_SELECTION (procedure)
  6. UNSET_GROUP_SELECTION (procedure)

48. What are the built-ins used for finding Object ID function?

  1. FIND_GROUP (function)
  2. FIND_COLUMN (function)

Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time. I) TRUE II)FALSE


50. Use the ADD_GROUP_ROW procedure to add a row to a static record group I) TRUE II)FALSE


51. What are the built-in used for getting cell values?

  1. Get_group_char_cell(function)
  2. Get_group_date_cell(function)
  3. Get_group_number_cell(function)

52. What are the built-ins used for processing rows?

  1. Get_group_row_count(function)
  2. Get_group_selection_count(function)
  3. Get_group_selection(function)
  4. Reset_group_selection(procedure)
  5. Set_group_selection(procedure)
  6. Unset_group_selection(procedure)

53. What are the built-ins used for finding object ID functions?

  1. Find_group(function)
  2. Find_column(function)

54. Use the add_group_column function to add a column to record group that was created at a design time?


55. Use the Add_group_row procedure to add a row to a static record group 1. true or false?


56. What are parameters?

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

57. What are the Built-ins used for sending Parameters to forms?

You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product

58. What is the maximum no of chars the parameter can store?

The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

59. How do you call other Oracle Products from Oracle Forms?

Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the opertor.

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

61. How do you reference a parameter indirectly?

To indirectly reference a parameter use the NAME IN, COPY 'built-ins to indirectly set and reference the parameters value' Example name_in ('capital parameter my param'), Copy ('SURESH','Parameter my_param')

62. What are the different Parameter types?

Text Parameters and Data Parameters

63. When do you use data parameter type?

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 produts invoked with the run_product built-in subprogram.

64. Can you pass data parametrs to forms?


65. What are different types of images?

Boiler plate images and Image Items

66. What is the difference between boiler plat images and image items?

Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a grapical elements in your form, such as company logos and maps Image items are special types of interface controls that store and display either vector or bitmap images. Llike other items that store values, image items can be either base table items(items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actualy associated with an image item until the item is populate at run time.

67. What are the trigger associated with image items?

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

68. What is the use of image_zoom built-in?

To manipulate images in image items.

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

70. Any attempt to navigate programatically to disabled form in a call_form stack is allowed?


71. An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?


72. When a form is invoked with call_form, Does oracle forms issues a save point?


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

74. State any three mouse events system variables?

  1. System.mouse_button_pressed
  2. System.mouse_button_shift_state
  3. system.mouse_item
  4. system.mouse_canvas
  5. system.mouse_record

75. What is an OLE?

Object Linking & Embadding provides you with the capability to integrate objects from many Ms-Windows applications into a single compound document creating integrated applications enables you to use the features form.

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

77. What is the difference between OLE Server & Ole Container?

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

78. What are the different styles of actvation of ole Objects?

In place activation and External activation

  Go Back to Oracle Interview Qusetion and Answers

More Oracle Database, DBA, Forms and Reports Interview Question and Answers

  1. Oracle Database Administration Interview Questions and Answers
  2. Oracle Cross Products and Matrix Reports Interview Questions and Answers
  3. Oracle Managing Distributed Databases Interview Questions and Answers
  4. Oracle Forms Interview Questions and Answers
  5. Oracle Database Security Interview Questions and Answers
  6. Oracle Database Operation Backup and Recovery Interview Questions and Answers
  7. Oracle Database Security and Administration Interview Questions and Answers
  8. Oracle Data Access Interview Questions and Answers
  9. Oracle Report Triggers Interview Questions and Answers
  10. Oracle Managing Backup and Recovery Interview Questions and Answers
  11. Forms 3.0, 4.0 Basic Interview Questions and Answers
  12. Oracle Package Procedure and Function Interview Questions and Answers
  13. Oracle System Architecture Interview Questions and Answers
  14. Oracle SQL Plus Statements Interview Questions and Answers
  15. Oracle Logical and Physical Architecture of Database Interview Questions and Answers
  16. Oracle Basics of Pl SQL Interview Questions and Answers
  17. Oracle Reports Interview Questions and Answers
  18. Oracle Concepts and Architecture Interview Questions and Answers
  19. Oracle Forms D2K 4.5 and 6i Interview Questions and Answers

Home > Interview Question and Answer > Oracle > Oracle Forms 4.5, 6i