Oracle Interview Questions And Answers


Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert

Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel

Oracle Interview Questions And Answers


Page 52 of 95 A library is a collection of Pl/SQL program units, including user
named procedures, functions & packages

52. Is it possible to attach same library to more than one form?

Yes

53. Explain the following file extention related to library?
.pll,.lib,.pld

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

54. 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
excute the create_parameter_list built_in function to programatically.
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.

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

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