Oracle India Pvt Ltd Placement Paper
Company: Oracle India Pvt Ltd
ORACLE CAMPUS LATEST PLACEMENT PAPER (TECHNICAL)
1. What is a visual attribute?
ANS:-Visual Attributes are the font, color and pattern characteristics of objects that operators see and interact with in our application.
2. What are the types of visual attribute settings?
ANS:-Custom Visual attributes, Default visual attributes ,Named Visual attributes.
3. What is a window?
ANS:-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 ie. what is displayed inside the frame is determined by the canvas View or canvas-views displayed in the window at run-time.
4. What are the different types of windows?
ANS:-Root window, secondary window.
5. Can a root window be made modal?
ANS:- No.
6. List the buil-in routine for controlling window during run-time?
Find_window,
get_window_property,
hide_window,
move_window,
resize_window,
set_window_property,
show_View
7. List the windows event triggers available in Forms 4.0?
ANS:-When-window-activated, when-window-closed, when-window-deactivated, when-window-resized
8. What built-in is used for changing the properties of the window dynamically?
ANS:- Set_window_property
9. What is a canvas-view?
ANS:-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.
10. Give the equivalent term in forms 4.0 for the following. Page, Page 0?
ANS:-Page – Canvas-View
Page 0 – Canvas-view null.
11. What are the types of canvas-views?
ANS:-Content View, Stacked View.
12. What is the content view and stacked view?
ANS:-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
13. List the built-in routines for the controlling canvas views during run-time?
ANS:-Find_canvas
Get-Canvas_property
Get_view_property
Hide_View
Replace_content_view
Scroll_view
Set_canvas_property
Set_view_property
Show_view
14. What is an Alert?
ANS:-An alert is a modal window that displays a message notifies the operator of some application condition
15. What are the display styles of an alert?
ANS:-Stop, Caution, note
16. Can you attach an alert to a field?
ANS:- No
17. What built-in is used for showing the alert during run-time?
ANS:-Show_alert.
18. 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.
ANS:-Yes. Set_alert_property.
19. What is the built-in function used for finding the alert?
ANS:-Find_alert
20. List the editors available in forms 4.0?
ANS:-Default editor, User defined editors, system editors.
21. What built-in routines are used to display editor dynamically?
ANS:- Edit_text item , show_editor
22.. What is an Lov?
ANS:-A list of values is a single or multi column selection list displayed in a pop-up window
23. Can you attach an lov to a field at design time?
ANS:-Yes.
24:- Can you attach an lov to a field at run-time? if yes, give the build-in name.
ANS:-Yes. Set_item_proprety
25. What is the built-in used for showing lov at runtime
ANS:-Show_lov
26. What is the built-in used to get and set lov properties during run-time?
ANS:-Get_lov_property , Set_lov_property
27. What is a record Group?
ANS:-A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table
28. What are the different type of a record group?
ANS:-Query record group, Static record group, Non query record group
29. Give built-in routine related to a record groups?
ANS:- 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)
30. What is the built_in routine used to count the no of rows in a group?
ANS:-Get_group _row_count
31. List system variables available in forms 4.0, and not available in forms 3.0?
ANS:-System.cordination_operation
System Date_threshold
System.effective_Date
System.event_window
System.suppress_working
32. System.effective_date system variable is read only True/False
ANS:- False
33. What is a library in Forms 4.0?
ANS:-A library is a collection of Pl/SQL program units, including user named procedures, functions & packages
34. Is it possible to attach same library to more than one form?
ANS:-Yes
35. Explain the following file extension related to library:- .pll,.lib,.pld?
ANS:-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
36. How do you pass the parameters from one form to another form?
ANS:-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.
Oracle India Pvt Ltd Placement Paper
About Oracle India Pvt Ltd
Oracle India Private Limited develops application software. The Company provides a variety of products including database, applications, java, operating, …visit offical website of Oracle India Pvt Ltd for more details..