Oracle HRMS Interview Questions

1) Tell me abt urself and ur work experience?How many oracle projects did u handle?
(HRMS Related)
2) What is the difference between a Plan and an Option?
3) What is Coverage?Is it different from an Option?
4) Can there be a Plan without any Option attached to it?
5) How do u set coverage for the Options of a plan like 1 X annualbasepay, 2 X annualbasepay ?
6) What is a fast formula? Why do we need a fast formula? Explain a situation demanding the usage of fast formula?
7) What is a Derived Factor?
8) What is an Eligibility Profile?How is it different from a Derived Factor?
9) What is a Business Group?
10) What is a Data Pump? (Technical)
11) How many reports did u develop in Apps.?
12) How do you register a PL/SQL procedure as a Concurrent Program in Apps.?
13) List the mandatory arguments that need to be included in the procedure definition for the procedure to be registered as a Concurrent Program ? Give the sequence?Do we need to define the as parameters in the concurrent program also?
14) Can the TOKEN name be different from the Parameter name we specify in the Report?
15) Can the Parameter name in Concurrent program be different from that of the Report parameter name?
16) How do we perform a COMMIT operation in a Database Trigger?
17) What are Autonomous Transactions and What are they called as in the database?
18) Does the changes we commited in an Autonomous Transaction rolled back if the main transaction fails?
19) List any other PRAGMAS that u know and explain them? (I discussed about RESTRICT REFERENCES andEXCEPTION INIT)
19) How do I give a user defined error message from a Trigger(written on a data base table) in Apps?
19) How do we set a parameter of the Concurrent Program dependent on another parameter?
20) How do we default a value to the third parammeter based on the values of the first two parameters?
21) Explain about Interfaces?
22) List the types of triggers used in Oracle Reports and Explain about Format Trigger?
23) How do you register an Oracle Report as a concurrent program in Apps?

Related Articles to Read