Thursday, 22 November 2012

oracle forms and reports interview questions part 2

What are the unrestricted procedures used to change the popup screen position during run time ?
Resize -View
What is an Alert ?
An alert is window that appears in the middle of the screen overlaying a portion of the current display.
Deleting a page removes information about all the fields in that page ?
a. True. b. False

a. True.
Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ?
a. True. b. False?

a. True.
Classify the restricted and unrestricted procedure from the following.
a. Call
b. User-Exit
c. Call-Query
d. Up
e. Execute-Query
f. Message
g. Exit-From
h. Post
i. Break?

a. Call - unrestricted
b. User Exit - Unrestricted
c. Call_query - Unrestricted
d. Up - Restricted
e. Execute Query - Restricted
f. Message - Restricted
g. Exit_form - Restricted
h. Post - Restricted
i. Break - Unrestricted.
What is an User Exits ?
A user exit is a subroutine which are written in programming languages using pro*C pro *Cobol , etc., that link into the SQL * forms executable.
What is a Trigger ?
A piece of logic that is executed at or triggered by a SQL *forms event.
What is a Package Procedure ?
A Package procedure is built in PL/SQL procedure.
What is the maximum size of a form ?
255 character width and 255 characters Length.
What is the difference between system.current_field and system.cursor_field ?
1. System.current_field gives name of the field.
2. System.cursor_field gives name of the field with block name.
List the system variables related in Block and Field?
1. System.block_status
2. System.current_block
3. System.current_field
4. System.current_value
5. System.cursor_block
6. System.cursor_field
7. System.field_status.
What are the different types of Package Procedure ?
1. Restricted package procedure.
2. Unrestricted package procedure.
What are the types of TRIGGERS ?
1. Navigational Triggers.
2. Transaction Triggers.
Identify package function from the following ?
1. Error-Code
2. Break
3. Call
4. Error-text
5. Form-failure
6. Form-fatal
7. Execute-query
8. Anchor View
9. Message_code?

1. Error_Code
2. Error_Text
3. Form_Failure
4. Form_Fatal
5. Message_Code
Can you attach an lov to a field at run-time? if yes, give the build-in name.?
Yes. Set_item_proprety
Is it possible to attach same library to more than one form?
Can you attach an lov to a field at design time?
List the windows event triggers available in Forms 4.0?
What are the triggers associated with the image item?
When-Image-activated(Fires when the operator double clicks on an image Items)
When-image-pressed(fires when the operator selects or deselects the image item)
What is a visual attribute?
Visual Attributes are the font, color and pattern characteristics of objects that operators see and intract with in our application.
How many maximum number of radio buttons can you assign to a radio group?
Unlimited no of radio buttons can be assigned to a radio group
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 Date_threshold
What are the display styles of an alert?
Stop, Caution, note
What built-in is used for showing the alert during run-time?
What built-in is used for changing the properties of the window dynamically?
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?
Can a root window be made modal?
What is a list item?
It is a list of text elements.
List some built-in routines used to manipulate images in image_item?
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?
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?
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?
List the built-in routine for controlling window during run-time?
What is the built-in function used for finding the alert?
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
What is an Lov?
A list of values is a single or multi column selection list displayed in a pop-up window
What is a record Group?
A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
Give built-in routine related to a record groups?
Create_group (Function)
List the built-in routines for the controlling canvas views during run-time?
System.effective_date system variable is read only True/False?
What are the built_in used to trapping errors in forms 4?
Error_type return character
Error_code return number
Error_text return char
Dbms_error_code return no.
Dbms_error_text return char
What are the types of canvas-views?
Content View, Stacked View.
What is an Alert?
An alert is a modal window that displays a message notifies the operator of some application condition
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
What is a record Group?
A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
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.
What is a library in Forms 4.0?
A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
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.
What is the content view and stacked view?
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
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".
What is a canvas-view?
A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.
Explain the following file extension related to library?
The library pll files is a portable design file comparable to an fmb form file
The library lib file is a plat form specific, generated library file comparable to a fmx form file
The pld file is Txt format file and can be used for source controlling your library files Parameter
Explain the usage of WHERE CURRENT OF clause in cursors ?
WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers
Name the tables where characteristics of Package, procedure and functions are stored ?
User_objects, User_Source and User_error. 

No comments:

Post a Comment