Oracle Interview Questions = Part -13

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.

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

List the Types of Items?
Text item.
Chart item.
Check box.
Display item.
Image item.
List item.
Radio Group.
User Area item.

List system variables available in forms 4.0, and not available in forms 3.0?
System.cordination_operation
System Date_threshold
System.effective_Date
System.event_window
System.suppress_working

What are the display styles of an alert?
Stop, Caution, note

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

What built-in is used for changing the properties of the window dynamically?
Set_window_property
Canvas-View

What are the different types of windows?
Root window, secondary window.

What is a predefined exception available in forms 4.0?
Raise form_trigger_failure

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.

What are the different type of a record group?
Query record group
Static record group
Non query record group

What are the menu items that oracle forms 4.0 supports?
Plain, Check,Radio, Separator, Magic

Give the equivalent term in forms 4.0 for the following. Page, Page 0?
Page - Canvas-View
Page 0 - Canvas-view null.

What triggers are associated with the radio group?
Only when-radio-changed trigger associated with radio group
Visual Attributes.

What are the triggers associated with a check box?
Only When-checkbox-activated Trigger associated with a Check box.

Can you attach an alert to a field?
No

Can a root window be made modal?
No

What is a list item?
It is a list of text elements.

List some built-in routines used to manipulate images in image_item?
Image_add
Image_and
Image_subtract
Image_xor
Image_zoom

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

What is the built-in used to get and set lov properties during run-time?
Get_lov_property
Set_lov_property
Record Group

What is the built-in routine used to count the no of rows in a group?
Get_group _row_count
System Variables

Give the Types of modules in a form?
Form
Menu
Library

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

List the built-in routine for controlling window during run-time?
Find_window,
get_window_property,
hide_window,
move_window,
resize_window,
set_window_property,
show_View

List the built-in routine for controlling window 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

What is the built-in function used for finding the alert?
Find_alert
Editors

List the editors availables in forms 4.0?
Default editor
User_defined editors
system editors.

What buil-in routines are used to display editor dynamically?
Edit_text item
show_editor
LOV