Paper 15a

55. What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Add_parameter
Create_Parameter_list
Delete_parameter
Destroy_parameter_list
Get_parameter_attr
Get_parameter_list
set_parameter_attr

56. What are the two ways to incorporate images into a oracle forms application?

Boilerplate Images
Image_items

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

57. 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)

58. List some built-in routines used to manipulate images in image_item?

Image_add
Image_and
Image_subtract
Image_xor
Image_zoom

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

60. What is a predefined exception available in forms 4.0?

Raise form_trigger_failure

61. What are the menu items that oracle forms 4.0 supports?

Plain, Check,Radio, Separator, Magic

FORMS4.5

object groups

01. what ia an object groups?

An object group is a container for a group of objects, you define an object group when you want to package related objects. so that you copy or reference them in another modules.

02. what are the different objects that you cannot copy or reference in object groups?

objects of differnt modules
another object groups
individual block dependent items
program units.

canvas views

03. what are different types of canvas views?

content canvas views
stacked canvas views
horizontal toolbar
vertical toolbar.

04. explain about content canvas views?

Most Canvas views are content canvas views a content canvas view is the "base" view that occupies the entire content pane of the window in which it is displayed.

05. Explain about stacked canvas views?

Stacked canvas view is displayed in a window on top of, or "stacked" on the content canvas view assigned to that same window. Stacked canvas views obscure some part of the underlying content canvas view, and or often shown and hidden programmatically.

06. Explain about horizontal, Vertical tool bar canvas views?

Tool bar canvas views are used to create tool bars for individual windows Horizontal tool bars are display at the top of a window, just under its menu bar.
Vertical Tool bars are displayed along the left side of a window

07. Name of the functions used to get/set canvas properties?

Get_view_property, Set_view_property

Windows

07. What is relation between the window and canvas views?

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate
objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

08. What are the different modals of windows?

Modalless windows
Modal windows

09. What are modalless windows?

More than one modelless window can be displayed at the same time, and operators can navigate among them if your application allows them to do so . On most GUI platforms, modelless windows can also be layered to appear either in front of or behind other windows.

10. What are modal windows?

Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

11. How do you display console on a window ?

The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned.
To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null.

12. What is the remove on exit property?

For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an item in the another window.

13. How many windows in a form can have console?

Only one window in a form can display the console, and you cannot chage the console assignment at runtime.

14. Can you have more than one content canvas view attached with a window?

Yes.
Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulate contant canvas view. At run time only one of the content canvas views assign to a window is displayed at a time.

15. What are the different window events activated at runtimes?

When_window_activated
When_window_closed
When_window_deactivated
When_window_resized
Within this triggers, you can examine the built in system variable system.event_window to determine the name of the window for which the trigger fired.

Modules

27. What are different types of modules available in oracle form?

Form module - a collection of objects and code routines
Menu modules - a collection of menus and menu item commands that together make up an application menu
library module - a collectio of user named procedures, functions and packages that can be called from other modules in the application

18. What are the default extensions of the files careated by forms modules?

.fmb - form module binary
.fmx - form module executable

19. What are the default extentions of the files created by menu module?

.mmb, .mmx

20 What are the default extension of the files created by library module?

The default file extensions indicate the library module type and storage format
.pll - pl/sql library module binary

Master Detail

21. What is a master detail relationship?

A master detail relationship is an association between two base table blocks- a master block and a detail block. The relationship between the blocks reflects a primary key to foreign key relationship between the tables on which the blocks are based.

22. What is coordination Event?

Any event that makes a different record in the master block the current record is a coordination causing event.

23. What are the two phases of block coordination?

There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete detail records. During the population phase, Oracle Forms issues a SELECT statement to repopulate the detail block with detail records associated witjh the new master record. These operations are accomplished through the execution of triggers.

24. What are Most Common types of Complex master-detail relationships?

There are three most common types of complex master-detail relationships:
master with dependent details
master with independent details
detail with two masters

25. What are the different types of Delete details we can establish in Master-Details?
Cascade
Isolate
Non-isolote

26. What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?
Master Delets Property Resulting Triggers

Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details

26. Whar are the different default triggers created when Master Deletes Property is set to Cascade?
Ans: Master Deletes Property Resulting Triggers

Cascading On-Clear-Details
On-Populate-Details
Pre-delete

28. What are the different default triggers created when Master Deletes Property is set to isolated?

Master Deletes Property Resulting Triggers

Isolated On-Clear-Details
On-Populate-Details

29. What are the Coordination Properties in a Master-Detail relationship?
The coordination properties are
Deferred
Auto-Query
These Properties determine when the population phase of block
coordination should occur.