Oracle APPs DBA Online Training

Page 1

For Free Demo Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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

For Free Demo Ph:+1 (646) 880-9474 For Details : Folkstrain.com


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 Ph:+1 (646) 880-9474 For Details : Folkstrain.com


For Free Demo Ph:+1 (646) 880-9474 For Details : Folkstrain.com


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.