Oracle APPs DBA Online Training

1
For Free Demo Ph1 [phone] For Details
Folkstrain.com
2
1.Explain custom top and its purpose? Custom
top are often outlined because the client prime
that is made completely for customers. In keeping
with the necessity of the shopper several variety
of client topnotch are often created. Custom top
is formed used for the aim of storing elements,
that are developed in addition as custom-made .
At the time once the oracle corporation applies
patches, each module apart from custom top are
overridden.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
3

• 2.Which are the styles of report triggers?
• There are chiefly 5 completely different styles
  of report triggers accessible. They are
• Before report
• After report
• Before parameter form
• After parameter form
• Between pages

For Free Demo Ph1 [phone] For Details
Folkstrain.com
4
3.What is the firing sequence connected with
report triggers? The sequence connected with
firing is as follows before parameter form, when
parameter form, before the report, between pages
and when report.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
5
4.Define record group? Record cluster are
often thought of as an inspiration used for the
aim of holding sql question that's related to
list connected with values. Record cluster
consists of static knowledge and can also access
knowledge within tables of info through sql
queries.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
6
5. Define application top? Application top
are found once we are connecting to server. There
are 2 varieties of application tops accessible
they're product prime and custom top. Product top
is that the reasonably prime that's in-built
default by manufacturer. Custom top are often
chosen by the client, and any variety of custom
topnotch are often created as per the necessity
of the client.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
7
6.Define SQL Loader? Sql loader may be a
utility resembling a bulk loader for the aim of
moving knowledge that are present in external
files towards the oracle DB.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
8
7.What is a value set? Value set is
employed for the aim of containing the values.
within the case of a worth set obtaining related
to report parameters, a listing containing values
are sent to the user for accepting one in every
of the values within the variety of parameter
values.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
9
8. Define Template? Template may be a
reasonably kind that's pretty much needed before
the creation of the other style of forms. it's a
kind of form that includes attachments that are
platform freelance and related to a selected
library.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
10

• 9.Which are the kinds of Triggers?
• Key triggers
• Error triggers
• Message triggers
• Navigational triggers
• Query primarily based triggers
• Transactional triggers

For Free Demo Ph1 [phone] For Details
Folkstrain.com
11
10.Define uses of Key Flex field? This is a
singular symbol for the aim of storing data
connected with key. It conjointly helps in
getting into in addition as displaying data
connected with key.
For Free Demo Ph1 [phone] For Details
Folkstrain.com
12
For Free Demo Ph1 [phone] For Details
Folkstrain.com