Tuesday, September 23, 2008

Interesting Oracle Applications (EBS) Interview Questions

Below are some interesting interview questions that I have faced over the years.

  1. What is the difference between a concurrent manager and a cron job?

  2. Can one patch a CRS Oracle home with the CRS services up?

  3. Suppose, there are 2 nodes node1 and node2 with CRS cluster and one wants to patch node1. Can it be done with node2 being up?

  4. Suppose one fires a select statement and the data does not in the library cache, then the data, obviously, has to be fetched from the data files. Which background process is used for this purpose?

  5. What are the sizing requirements for say, a 100 concurrent users Oracle Apps Installation?

  6. What is the difference between a shared appl_top and a staged appl_top?