|
Oracle Interview Questions and Answers
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
Page Numbers :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 35
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Job Interview Questions
for more Interview Questions with Answers
|