Oracle Forms :Interview Questions
1.
Which
triggers are created when master -detail relation? master delete property
NON-ISOLATED (default): on check delete master, on clear details, on populate details
NON-ISOLATED (default): on check delete master, on clear details, on populate details
ISOLATED:
on clear details, on populate details
CASCADE: pre-delete,
on clear details, on populate details.
2.
Which
system variables can be set by users?
SYSTEM.MESSAGE_LEVEL
SYSTEM.DATE_THRESHOLD
SYSTEM.EFFECTIVE_DATE
SYSTEM.SUPPRESS_WORKING
3.
What
are object group?
An
object group is a container for a group of objects. You define an object group
when you want to package related objects so you can copy or reference them in
another module.
4.
What
are referenced objects?
Referencing allows you to create objects that inherit
their functionality and appearance from other objects. Referencing an object is similar to copying
an object, except that the resulting reference object maintains a link to its
source object. A reference object automatically inherits any changes that have
been made to the source object when you open or regenerate the module that
contains the reference object.
5.
Can
you store objects in library?
NO
.
6.
Can
you issue DDL in forms?
Yes,
but you have to use FORMS_DDL.
Referencing
allows you to create objects that inherit their functionality and appearance
from other objects. Referencing an object is similar to copying an object,
except that the resulting reference object maintains a link to its source
object. A reference object automatically inherits any changes that have been
made to the source object when you open or regenerate the module that contains
the reference object.
Any
string expression up to 32K:
· a literal
· an expression or a variable representing the
text of a block of dynamically created
PL/SQL code
· a DML statement or · a DDL statement
Restrictions:
The statement you pass to
FORMS_DDL may not contain bind variable references in the string, but the values of bind variables can be
concatenated into the string before passing the result to FORMS_DDL.
7.
What
is SECURE property?
Hides
characters that the operator types into the text item. This setting is typically used for password protection.
8.
What
are the types of triggers and how the sequence of firing in text item
Triggers can be classified as Key Triggers, Mouse
Triggers, Navigational Triggers.
Key Triggers:
Key Triggers are fired as a result of Key action.
e.g.
Key-next-field, Key-up, Key-Down
Mouse
Triggers: Mouse Triggers are fired
as a result of the mouse navigation.
e.g.
When-mouse-button-pressed, when-mouse-double clicked, etc
Navigational
Triggers: These Triggers are fired
as a result of Navigation.
E.g.
Post-Text-item, Pre-text-item.
We also have event
triggers like when–new-form-instance and when-new-block-instance.
We cannot
call restricted procedures like go_to(‘my_block.first_item’) in the
Navigational
triggers But
can use them in the Key-next-item.
The Difference between Key-next and
Post-Text is an very important question. The
key-next
is fired as a result of the key action
while the post text is fired as a result of the
mouse movement. Key next will not fire unless there is a key
event.
The
sequence of firing in a text item are as follows:
a) pre - text
b) when new item
c) key-next
d) when validate
e) post text
9.
What
are property classes? Can property classes have trigger?
Property class inheritance is a powerful feature that
allows you to quickly define objects that conform to your own interface and
functionality standards. Property classes also allow you to make global changes
to applications quickly. By simply
changing the definition of a property class, you can change the definition of
all objects that inherit properties from that class.
Yes, all type of triggers.
