201. What are the different modals of windows?
Modalless windows
Modal windows
202. 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.
203. What are the different default triggers created when Master Deletes Property is set to Non-isolated?
Master Deletes Property Resulting Triggers
-----------------------------------------------------
Non-Isolated(the default) On-Check-Delete-Master
On-Clear-Details
On-Populate-Details
204. 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
205. What are the different default triggers created when Master Deletes Property is set to Cascade?
Master Deletes Property Resulting Triggers
----------------------------------------------------
Cascading On-Clear-Details
On-Populate-Details
Pre-delete
206. What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
LOVs can be attached to parameters in the reports 2.5 parameter form.
207. What are the difference between lov & list item?
Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.
208. What is the advantage of the library?
Libraries provide a convenient means of storing client-side program units and sharing them among multiple applications. Once you create a library, you can attach it to any other form, menu, or library
modules. When you can call library program units from triggers menu items commands and user named routine, you write in the modules to which you have attach the library. When a library attaches another library, program units in the first library can reference program units in the attached library. Library support dynamic loading-that is library program units are loaded into an application only when needed. This can significantly reduce the run-time memory requirements of applications.
209. What is lexical reference? How can it be created?
Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.
210. What is system.coordination_operation?
It represents the coordination causing event that occur on the master block in master-detail relation.
211. What is synchronize?
It is a terminal screen with the internal state of the form. It updates the screen display to reflect the
information that oracle forms has in its internal representation of the screen.
212. What use of command line parameter cmd file?
It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.
213. What is a Text_io Package?
It allows you to read and write information to a file in the file system.
214. What is forms_DDL?
Issues dynamic Sql statements at run time, including server side pl/SQl and DDL
215. How is link tool operation different bet. reports 2 & 2.5?
In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to
link the first field to the second field.
216. What are the different styles of activation of ole Objects?
In place activationExternal activation
217. How do you reference a Parameter?
In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name
218. What is the difference between object embedding & linking in Oracle forms?
In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.
219. Name of the functions used to get/set canvas properties?
Get_view_property, Set_view_property
220. What are the built-ins that are used for setting the LOV properties at runtime?
get_lov_property
set_lov_property
221. What are the built-ins used for processing rows?
Get_group_row_count(function)
Get_group_selection_count(function)
Get_group_selection(function)
Reset_group_selection(procedure)
Set_group_selection(procedure)
Unset_group_selection(procedure)
222. What are built-ins used for Processing rows?
GET_GROUP_ROW_COUNT(function)
GET_GROUP_SELECTION_COUNT(function)
GET_GROUP_SELECTION(function)
RESET_GROUP_SELECTION(procedure)
SET_GROUP_SELECTION(procedure)
UNSET_GROUP_SELECTION(procedure)
223. What are the built-in used for getting cell values?
Get_group_char_cell(function)
Get_groupcell(function)
Get_group_number_cell(function)
224. What are the built-ins used for Getting cell values?
GET_GROUP_CHAR_CELL (function)
GET_GROUPCELL(function)
GET_GROUP_NUMBET_CELL(function)
225. Atleast how many set of data must a data model have before a data model can be base on it?
Four
226. To execute row from being displayed that still use column in the row which property can be used?
Format trigger.
227. 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 collection of user named procedures, functions and packages that can be called from other modules in the application
228. 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.
229. What is WHEN-Database-record trigger?
Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or
commit as an insert or update. c generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.
230. What is a difference between pre-select and pre-query?
Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires
just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode.Pre-query trigger fires before
pre-select trigger.
231. What are built-ins associated with timers?
find_timercreate_timerdelete_timer
232. What are the built-ins used for finding object ID functions?
Find_group(function)
Find_column(function)
233. What are the built-ins used for finding Object ID function?
FIND_GROUP(function)
FIND_COLUMN(function)
234. Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
False
235. Use the Add_group_row procedure to add a row to a static record group 1. true or false?
False
False
237. What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
238. How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
By dragging the column outside the group.
239. What is the use of place holder column? What are the various sub events a mouse double click event involves?
A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.
240. What is the use of hidden column? What are the various sub events a mouse double click event involves?
A hidden column is used to when a column has to embed into boilerplate text.
241. What is the use of break group? What are the various sub events a mouse double click event involves?
A break group is used to display one record for one group ones.
While multiple related records in other group can be displayed.
242. What is an anchoring object & what is its use? What are the various sub events a mouse double click event involves?
An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.
243. What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.
245. What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
Destype and Desname.
246. What are the built-ins used for Creating and deleting groups?
CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY(function)
DELETE_GROUP(procedure)
247. What are different types of canvas views?
Content canvas views
Stacked canvas views
Horizontal toolbar
vertical toolbar.
248. What are the different types of Delete details we can establish in Master-Details?
Cascade
Isolate
Non-isolate
249. 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.
250. What is a User_exit?
Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.
