1⟩ Explain built-in routines for the controlling canvas views during run-time?
Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
Alert
Oracle Forms 4.0
Home Oracle Oracle Forms 4.0
“Oracle Forms 4.0 guideline for job interview preparation. Explore list of Oracle Forms 4.0 frequently asked questions(FAQs) asked in number of Oracle Forms 4.0 interviews. Post your comments as your suggestions, questions and answers on any Oracle Forms 4.0 Interview Question or answer. Ask Oracle Forms 4.0 Question, your question will be answered by our fellow friends.”
22 Oracle Forms 4.0 Questions And Answers
2⟩ Explain the built-in routine used to count the no of rows in a group?
Get_group _row_count
System Variables
3⟩ Explain How image_items can be populate to field in forms 4.0?
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.
4⟩ Explain What are the menu items that oracle forms 4.0 supports?
Plain,
Check,
Radio,
Separator,
Magic
5⟩ Can we change the default value of the radio button group at run time?
No
6⟩ Explain What is a predefined exception available in forms 4.0?
Raise form_trigger_failure
7⟩ How to Give built-in routine related to a record groups?
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)
8⟩ Explain What is a window?
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.
9⟩ Explain What are the types of canvas-views?
Content View, Stacked View and Tab view.
10⟩ Explain some built-in routines used to manipulate images in image_item?
Image_add
Image_and
Image_subtract
Image_xor
Image_zoom
11⟩ Can we attach an alert to a field?
NO
12⟩ Explain 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 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.
13⟩ Explain System.effective_date system variable is read only True/False?
False
14⟩ Explain What are the triggers associated with a check box?
Only When-checkbox-activated Trigger associated with a Check box.
15⟩ Explain What is the built-in function used for finding the alert?
Find_alert
Editors
16⟩ Explain 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.
17⟩ Can we change the color of the push button in design time?
No
18⟩ Explain 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".
19⟩ Explain the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL
FMB ----- Form Module Binary.
MMB ----- Menu Module Binary.
PLL ------ PL/SQL Library Module Binary.
20⟩ Explain 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.
