P2Pprogrammer 2 programmer

Home > Interview Question and Answer > Oracle > Oracle Forms, D2K Interview Questions and Answers

Interview Questions and Answers for Oracle Forms 4.0, 4.5, 6i, 10g, D2K

Interview questions and answers for Oracle database, Oracle Forms and D2K Interview Questions and Answers Oracle Forms 4.0, 4.5, 6i, 10g, D2K Interview Questions and Answers includes, visual attribute, visual attribute settings, window, root window, event triggers, canvas-view, Alert, display styles of an alert, Lov, showing lov at runtime, record Group, System Variables, library, Pl/SQL program units, file extension, pass the parameters, built-in routines, incorporate images into a oracle, trapping errors, predefined exception, menu items, Layout Editor, Types of modules, design facilities, block, types of Block, Navigable item.

Oracle Forms and D2K Interview Questions and Answers

1. Types of modules in a form?

  1. Form
  2. Menu
  3. Library

2. Write the Abbreviation for the following File Extension

  1. FMB ----- Form Module Binary.
  2. MMB ----- Menu Module Binary.
  3. PLL ------ PL/SQL Library Module Binary.

3. What are the design facilities available in forms

  1. Default Block facility.
  2. Layout Editor.
  3. Menu Editor.
  4. Object Lists.
  5. Property Sheets.
  6. PL/SQL Editor.
  7. Tables Columns Browser.
  8. Built-ins Browser.

4. What is a Layout Editor?

he Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.

5. What do you mean by a block in forms?

Block is a single mechanism for grouping related items into a functional unit for storing,displaying and manipulating records.

6. Explain types of Block in forms?

  1. Base table Blocks - A base table block is one that is associated with a specific database table or view.
  2. Control Blocks - A control block is a block that is not associated with a database table.

7. What are the options available to refresh snapshots?

  1. COMPLETE - Tables are completely regenerated using the snapshot's query and the master tables every time the snapshot referenced.
  2. FAST - If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
  3. FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.

8. List the Types of tems?

  1. Text item.
  2. Chart item.
  3. Check box.
  4. Display item.
  5. Image item.
  6. List item.
  7. Radio Group.
  8. User Area item

9. What is a Navigable item?

A navigable item is one that operators can navigate to with the keyboard during default navigation, or that Oracle forms can navigate to by executing a navigational built-in procedure.

10. Can you change the color of the push button in design time?


11. What is a Check Box?

A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".

12. What are the triggers associated with a check box?

Only When-checkbox-activated Trigger associated with a Check box.

13. What is a display item?

Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

14. What is a list item?

It is a list of text elements.

15. What are the display styles of list items?

Poplist, No text Item displayed in the list item.
Tlist, No element in the list is highlighted.

16. What is a radio Group?

Radio groups display a fixed no of options that are mutually exclusive. User can select one out of n number of options.

17. How many maximum number of radio buttons can you assign to a radio group?

Unlimited no of radio buttons can be assigned to a radio group

18. Can you change the default value of the radio button group at run time?


19. What triggers are associated with the radio group?

Only when-radio-changed trigger associated with radio group

20. What is a visual attribute?

Visual Attributes are the font, color and pattern characteristics of objects that operators see and intract with in our application.

21. What are the types of visual attribute settings?

  1. Custom Visual attributes
  2. Default visual attributes
  3. Named Visual attributes

22. What is a window?

A window, byitself, can be thought of as an empty frame. The frame provides a way to intract with the window, including the ability to scroll, move, and resize the window. The content of the window ie. what is displayed inside the frame is determined by the canvas View or canvas-views displayed in the window at run-time.

23. What are the differrent types of windows?

Root window, and Secondary window.

24. Can a root window be made modal?


25. List the buil-in routine for controlling window during run-time?

  1. Find_window,
  2. get_window_property,
  3. hide_window,
  4. move_window,
  5. resize_window,
  6. set_window_property,
  7. show_View

26. List the windows event triggers available in Forms ?

When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

27. What built-in is used for changing the properties of the window dynamically?


28. What is a canvas-view?

A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assiged to a specific canvas. Each canvas, in term, must be displayed in a specfic window.

29. Give the equivalent term in forms for the following. Page, Page 0?

Page - Canvas-View
Page 0 - Canvas-view null.

30. What are the types of canvas-views?

Content View, Stacked View.

31. What is the content view and stacked view?

A content view is the "Base" view that occupies the entire content pane of the window in which it is displayed. A stacked view differs from a content canvas view in that it is not the base view for the window to which it is assigned

32. List the built-in routines for the controlling canvas views during run-time?

  1. Find_canvas
  2. Get-Canvas_property
  3. Get_view_property
  4. Hide_View
  5. Replace_content_view
  6. Scroll_view
  7. Set_canvas_property
  8. Set_view_property
  9. Show_view

33. What is an Alert?

An alert is a modal window that displays a message notifies the operator of some application condition

34. What are the display styles of an alert?

Stop, Caution, note

35. Can you attach an alert to a field?


36. What built-in is used for showing the alert during run-time?


37. Can you change the alert messages at run-time? If yes, give the name of th built-in to chage the alert messages at run-time.

Yes. Set_alert_property.

40. What is the built-in function used for finding the alert?


41. List the editors availables in forms ?

  1. Default editor
  2. User_defined editors
  3. system editors

42. What built-in routines are used to display editor dynamicaly?

Edit_text item

43. What is a Lov?

A list of values is a single or multi column selection list displayed in a pop-up window

44. Can you attach a lov to a field at design time?


45. Can you attach a lov to a field at run-time? If yes, give the build-in name

Yes. Set_item_proprety

46. What is the built-in used for showing lov at runtime?


47. What is the built-in used to get and set lov properties during run-time?


48. What is a record Group?

A record group is an internal oracle forms data structure that has a simillar column/row frame work to a database table

49. What are the different types of a record group?

  1. Query record group
  2. Static record group
  3. Non query record group

50. Give built-in routine related to record groups?

  1. Create_group (Function)
  2. Create_group_from_query(Function)
  3. Delete_group(Procedure)
  4. Add_group_column(Function)
  5. Add_group_row(Procedure)
  6. Delete_group_row(Procedure)
  7. Populate_group(Function)
  8. Populate_group_with_query(Function)
  9. Set_group_Char_cell(procedure)

51. What is the built_in routine used to count the no of rows in a group?

Get_group _row_count

52. List system variables available in forms 4.0, and not available in forms?

  1. System.cordination_operation
  2. System Date_threshold
  3. System.effective_Date
  4. System.event_window
  5. System.suppress_working

53. System.effective_date system variable is read only True/False ?


54. What is a library in Forms ?

A library is a collection of Pl/SQL program units, including user named procedures, functions & packages

55. Is it possible to attach same library to more than one form?


56. Explain the following file extention related to library?

.pll - The library pll files is a portable design file comparable to an fmb form file
.lib - The library lib file is a plat form specific, generated library file comparable to an fmx form file
.pld - The pld file is Txt format file and can be used for source controlling your library files

57. How do you pass the parameters from one form to another form?

To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine excute the create_parameter_list built_in function to programatically. Create a parameter list to execute the add parameter built_in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.

58. What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

  1. Add_parameter
  2. Create_Parameter_list
  3. Delete_parameter
  4. Destroy_parameter_list
  5. Get_parameter_attr
  6. Get_parameter_list
  7. set_parameter_attr

59. What are the two ways to incorporate images into a oracle forms application?

Boilerplate Images and Image_items

60. How image_items can be populate to field in forms ?

A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

61. What are the triggers associated with the image item?

  1. When-Image-activated(Fires when the operator double clicks on an image Items)
  2. When-image-pressed(fires when the operator selects or deselects the image item)

62. List some built-in routines used to manipulate images in image_item?

  1. Image_add
  2. Image_and
  3. Image_subtract
  4. Image_xor
  5. Image_zoom

63. What are the built_in used to trapping errors in forms?

  1. Error_type return character
  2. Error_code return number
  3. Error_text return char
  4. Dbms_error_code return no.
  5. Dbms_error_text return char

64. What is a predefined exception available in forms?

Raise form_trigger_failure

65. What are the menu items that oracle forms supports?

Plain, Check,Radio, Separator, Magic

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