Top Most Oracle Form 4.0 Interview Questions
Q – 1 Explain What is the content view and stacked view?
Ans- 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
Q – 2 Explain What is a Layout Editor?
Ans- The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application’s interface.
Q – 3 Explain what is a display item?
Ans- 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.
Q – 4 Explain the Abbreviation for the following File Extension:
1. FMB
2. MMB
3. PLL
Ans- FMB —– Form Module Binary.
MMB —– Menu Module Binary.
PLL —— PL/SQL Library Module Binary.
Q – 5 Explain What is a Check Box?
Ans- 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”.
Q – 6 Explain What is a Navigable item?
Ans- 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.
Q – 7 Can we change the color of the push button in design time?
Ans- No
Q – 8 Explain What is the built-in function used for finding the alert?
Ans- Find_alert
Editors
Q – 9 Explain What are the triggers associated with a check box?
Ans- Only When-checkbox-activated Trigger associated with a Check box.
Q – 10 Explain System.effective_date system variable is read only True/False?
Ans- False
Q – 11 Can we attach an alert to a field?
Ans- NO
Q – 12 Explain some built-in routines used to manipulate images in image_item?
Ans- Image_add
Image_and
Image_subtract
Image_xor
Image_zoom
Q – 13 Explain What are the types of canvas-views?
Ans- Content View, Stacked View and Tab view.
Q – 14 Explain What is a window?
Ans- A window, by itself , can be thought of as an empty frame. The frame provides a way to interact with the window, including the ability to scroll, move, and resize the window. The content of the window i.e. what is displayed inside the frame is determined by the canvas View or canvas-views displayed in the window at run-time.
Q – 15 How to Give built-in routine related to a record groups?
Ans- Create_group (Function)
Create_group_from_query(Function)
Delete_group(Procedure)
Add_group_column(Function)
Add_group_row(Procedure)
Delete_group_row(Procedure)
Populate_group(Function)
Populate_group_with_query(Function)
Set_group_Char_cell(procedure)
Q – 16 Explain What is a predefined exception available in forms 4.0?
Ans- Raise form_trigger_failure
Q – 17 Can we change the default value of the radio button group at run time?
Ans- No
Q – 18 Explain What are the menu items that oracle forms 4.0 supports?
Ans- Plain,
Check,
Radio,
Separator,
Magic
Q – 19 Explain How image_items can be populate to field in forms 4.0?
Ans- 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.
Q – 20 Explain the built-in routine used to count the no of rows in a group?
Ans- Get_group _row_count
System Variables
Q – 21 Explain How do you pass the parameters from one form to another form?
Ans- 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 execute the create_parameter_list built-in function to programmatically. 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.
Q – 22 Explain built-in routines for the controlling canvas views during run-time?
Ans- Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
Alert