|
Oracle Interview Questions and Answers
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.
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.
What is system.coordination_operation?
It represents the coordination causing event that occur
on the master block in master-detail relation.
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.
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.
What is a Text_io Package?
It allows you to read and write information to a file in
the file system.
What is forms_DDL?
Issues dynamic Sql statements at run time, including
server side pl/SQl and DDL
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.
What are the different styles of activation of ole
Objects?
In place activationExternal activation
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
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.
Name of the functions used to get/set canvas properties?
Get_view_property, Set_view_property
What are the built-ins that are used for setting the LOV
properties at runtime?
get_lov_property
set_lov_property
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)
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)
What are the built-in used for getting cell values?
Get_group_char_cell(function)
Get_groupcell(function)
Get_group_number_cell(function)
What are the built-ins used for Getting cell values?
GET_GROUP_CHAR_CELL (function)
GET_GROUPCELL(function)
GET_GROUP_NUMBET_CELL(function)
Atleast how many set of data must a data model have
before a data model can be base on it?
Four
To execute row from being displayed that still use
column in the row which property can be used?
Format trigger.
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
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.
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.
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.
What are built-ins associated with timers?
find_timercreate_timerdelete_timer
What are the built-ins used for finding object ID
functions?
Find_group(function)
Find_column(function)
What are the built-ins used for finding Object ID
function?
FIND_GROUP(function)
FIND_COLUMN(function)
Any attempt to navigate programmatically to disabled
form in a call_form stack is allowed?
False
Use the Add_group_row procedure to add a row to a static
record group 1. true or false?
False
Page Numbers :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 35
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Job Interview Questions
for more Interview Questions with Answers
|
