|
|
|
|
1.
|
What is 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.
|
|
2.
|
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.
|
|
3.
|
What are different types of canvas views? |
|
|
Content canvas views
Stacked canvas views
horizontal toolbar
Vertical toolbar.
|
|
4.
|
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.
|
|
5.
|
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.
|
|
6.
|
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
|
|
7.
|
Name of the functions used to get/set canvas properties? |
|
|
Get_view_property, Set_view_property
|
|
8.
|
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.
|
|
9.
|
What are the different modals of windows? |
|
|
Modalless windows
Modal windows
|
|
10. |
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.
|
|
11. |
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.
|
|
12. |
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.
|
|
13. |
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.
|
|
14. |
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. |
|
15. |
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.
|
|
16. |
What is 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.
|
|
17. |
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 is 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
|
|
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
What is 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
What is 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
|
|
27. |
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.
|
|
28. |
What is the User-Named Editor? |
|
|
A user named editor has the same text editing
functionality as the default editor, but, becaue it is a
named object, you can specify editor attributes such as
windows display size, position, and title.
|
|
29. |
What are the Built-ins to display the user-named editor? |
|
|
A user named editor can be displayed programmatically
with the built in procedure SHOW-EDITOR, EDIT_TETITEM
independent of any particular text item. |
|
30. |
What is the difference between SHOW_EDITOR and
EDIT_TEXTITEM? |
|
|
Show editor is the generic built_in which accepts any
editor name and takes some input string and returns
modified output string. Whereas the edit_textitem
built_in needs the input focus to be in the text item
before the built_in is excuted.
|
|
31. |
What is an LOV? |
|
|
An LOV is a scrollable popup window that provides the
operator with either a single or multi column selection
list.
|
|
32. |
What is the basic data structure that is required for
creating an LOV? |
|
|
Record Group.
|
|
33. |
What is the "LOV of Validation" Property of an item?
What is the use of it? |
|
|
When LOV for Validation is set to True, Oracle Forms
compares the current value of the text item to the
values in the first column displayed in the LOV.
Whenever the validation event occurs.
If the value in the text item matches one of the values
in the first column of the LOV, validation succeeds, the
LOV is not displayed, and processing continues normally.
If the value in the text item does not match one of the
values in the first column of the LOV, Oracle Forms
displays the LOV and uses the text item value as the
search criteria to automatically reduce the list.
|
|
34. |
What are the built_ins used the display the LOV? |
|
|
Show_lov
List_values
|
|
35. |
What are the built-ins that are used to Attach an LOV
programatically to an item? |
|
|
set_item_property
get_item_property
(by setting the LOV_NAME property)
|
|
36. |
What are the built-ins that are used for setting the LOV
properties at runtime? |
|
|
get_lov_property
set_lov_property
|
|
37. |
What is a record group? |
|
|
A record group is an internal Oracle Forms that
structure that hs a column/row framework similar to a
database table. However, unlike database tables, record
groups are separate objects that belong to the form
module which they are defined.
|
|
38. |
How many numbers of columns a record group can have? |
|
|
A record group can have an unlimited number of columns
of type CHAR, LONG, NUMBER, or DATE provided that the
total number of column does not exceed 64K.
|
|
39. |
What is the Maximum allowed length of Record group
Column? |
|
|
Record group column names cannot exceed 30 characters.
|
|
40. |
What are the different types of Record Groups? |
|
|
Query Record Groups
NonQuery Record Groups
State Record Groups
|
|
41. |
What is a Query Record Group? |
|
|
A query record group is a record group that has an
associated SELECT statement. The columns in a query
record group derive their default names, data types, had
lengths from the database columns referenced in the
SELECT statement. The records in query record group are
the rows retrieved by the query associated with that
record group.
|
|
42. |
What is a Non Query Record Group? |
|
|
A non-query record group is a group that does not have
an associated query, but whose structure and values can
be modified programmatically at runtime.
|
|
43. |
What is a Static Record Group? |
|
|
A static record group is not associated with a query,
rather, you define its structure and row values at
design time, and they remain fixed at runtime.
|
|
44. |
What are the built-ins used for Creating and deleting
groups? |
|
|
CREATE-GROUP (function)
CREATE_GROUP_FROM_QUERY (function)
DELETE_GROUP (procedure)
|
|
45. |
What are the built -ins used for Modifying a group's
structure? |
|
|
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)
SET_GROUP_DATE_CELL (procedure)
SET_GROUP_NUMBER_CELL (procedure)
|
|
46. |
What are the built-ins used for getting cell values? |
|
|
GET_GROUP_CHAR_CELL (function)
GET_GROUP_DATE_CELL (function)
GET_GROUP_NUMBET_CELL (function)
|
|
47. |
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)
|
|
48. |
What are the built-ins used for finding Object ID
function? |
|
|
FIND_GROUP (function)
FIND_COLUMN (function)
|
|
49. |
Use the ADD_GROUP_COLUMN function to add a column to a
record group that was created at design time.
I) TRUE II)FALSE |
|
|
FALSE
|
|
50. |
Use the ADD_GROUP_ROW procedure to add a row to a static
record group
I) TRUE II)FALSE |
|
|
FALSE
|
|
51. |
What are the built-in used for getting cell values? |
|
|
Get_group_char_cell(function)
Get_group_date_cell(function)
Get_group_number_cell(function)
|
|
52. |
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)
|
|
53. |
What are the built-ins used for finding object ID
functions? |
|
|
Find_group(function)
Find_column(function)
|
|
54. |
Use the add_group_column function to add a column to
record group that was created at a design time? |
|
|
False.
|
|
55. |
Use the Add_group_row procedure to add a row to a static
record group 1. true or false? |
|
|
False.
|
|
56. |
What are parameters? |
|
|
Parameters provide a simple mechanism for defining and
setting the values of inputs that are required by a form
at startup. Form parameters are variables of type
char,number,date that you define at design time.
|
|
57. |
What are the Built-ins used for sending Parameters to
forms? |
|
|
You can pass parameter values to a form when an
application executes the call_form, New_form, Open_form
or Run_product.
|
|
58. |
What is the maximum no of chars the parameter can store? |
|
|
The maximum no of chars the parameter can store is only
valid for char parameters, which can be upto 64K. No
parameters default to 23Bytes and Date parameter default
to 7Bytes.
|
|
59. |
How do you call other Oracle Products from Oracle Forms? |
|
|
Run_product is a built-in, Used to invoke one of the
supported oracle tools products and specifies the name
of the document or module to be run. If the called
product is unavailable at the time of the call, Oracle
Forms returns a message to the opertor.
|
|
60. |
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
|
|
61. |
How do you reference a parameter indirectly? |
|
|
To indirectly reference a parameter use the NAME IN,
COPY 'built-ins to indirectly set and reference the
parameters value' Example name_in ('capital parameter my
param'), Copy ('SURESH','Parameter my_param')
|
|
62. |
What are the different Parameter types? |
|
|
Text Parameters
Data Parameters
|
|
63. |
When do you use data parameter type? |
|
|
When the value of a data parameter being passed to a
called product is always the name of the record group
defined in the current form. Data parameters are used to
pass data to produts invoked with the run_product
built-in subprogram.
|
|
64. |
Can you pass data parametrs to forms? |
|
|
No.
|
|
65. |
What are different types of images? |
|
|
Boiler plate images
Image Items
|
|
66. |
What is the difference between boiler plat images and
image items? |
|
|
Boiler plate Images are static images (Either vector or
bit map) that you import from the file system or
database to use a grapical elements in your form, such
as company logos and maps Image items are special types
of interface controls that store and display either
vector or bitmap images. Llike other items that store
values, image items can be either base table items(items
that relate directly to database columns) or control
items. The definition of an image item is stored as part
of the form module FMB and FMX files, but no image file
is actualy associated with an image item until the item
is populate at run time.
|
|
67. |
What are the trigger associated with image items? |
|
|
When-image-activated fires when the operators double
clicks on an image item when-image-pressed fires when an
operator clicks or double clicks on an image item
|
|
68. |
What is the use of image_zoom built-in? |
|
|
To manipulate images in image items.
|
|
69. |
How do you create a new session while open a new form? |
|
|
Using open_form built-in setting the session option Ex.
Open_form('Stocks ',active,session). when invoke the
mulitiple forms with open form and call_form in the same
application, state whether the following are true/False
|
|
70. |
Any attempt to navigate programatically to disabled form
in a call_form stack is allowed? |
|
|
False
|
|
71. |
An open form can not be execute the call_form procedure
if you chain of called forms has been initiated by
another open form? |
|
|
True
|
|
72. |
When a form is invoked with call_form, Does oracle forms
issues a save point? |
|
|
True
|
|
73. |
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.
|
|
74. |
State any three mouse events system variables? |
|
|
System.mouse_button_pressed
System.mouse_button_shift_state
system.mouse_item
system.mouse_canvas
system.mouse_record
|
|
75. |
What is an OLE? |
|
|
Object Linking & Embadding provides you with the
capability to integrate objects from many Ms-Windows
applications into a single compound document creating
integrated applications enables you to use the features
form .
|
|
76. |
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.
|
|
77. |
What is the difference between OLE Server & Ole
Container? |
|
|
An Ole server application creates ole Objects that are
embedded or linked in ole Containers ex. Ole servers are
ms_word & ms_excell. OLE containers provide a place to
store, display and manipulate objects that are created
by ole server applications. Ex. oracle forms are an
example of an ole Container.
|
|
78. |
What are the different styles of actvation of ole
Objects? |
|
|
In place activation
External activation |
