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.
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.
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.
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
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
Stop, Caution, note
What built-in is used for showing the alert during run-time?
Show_alert.
Show_alert.
What built-in is used for changing the properties of the window dynamically?
Set_window_property
Canvas-View
Set_window_property
Canvas-View
What are the different types of windows?
Root window, secondary window.
Root window, secondary window.
What is a predefined exception available in forms 4.0?
Raise form_trigger_failure
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.
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
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
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.
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.
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.
Only When-checkbox-activated Trigger associated with a Check box.
Can you attach an alert to a field?
No
No
Can a root window be made modal?
No
No
What is a list item?
It is a list of text elements.
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
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.
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
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
Get_group _row_count
System Variables
Give the Types of modules in a form?
Form
Menu
Library
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.
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
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
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
Find_alert
Editors
List the editors availables in forms 4.0?
Default editor
User_defined editors
system editors.
Default editor
User_defined editors
system editors.
What buil-in routines are used to display editor dynamically?
Edit_text item
show_editor
LOV
Share This :
Edit_text item
show_editor
LOV
When can hash cluster used?
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.
What are the types of database links?
Private database link, public database link & network database link.
Private database link, public database link & network database link.
What is private database link?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.
What is public database link?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.
What is network database link?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.
What is data block?
Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.
How to define data block size?
A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.
A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.
0 comments:
Post a Comment