1. How do you interact with functional people to understand the requirement?
2. How do you convert the functional requirements to technical requirement?
3. What are the different Optimizer techniques?
4. What is all the information available from PLAN TABLE? How you force your query to use any index?
5. If a procedure or report takes a long time, how do you get the necessary information before start tuning?
6. What is the use of any particular library in Template form? Mainly CUSTOM.PLL
7. What is a PL/SQL table?
8. What is bulk insert and what other operations you can perform using bulk feature?
9. If you have to write a query on 3 to 4 tables with lots of data what will be your steps for better performance?
10. If you want to insert billions of data from legacy system that is not in Oracle environment, what steps or processes you follow?
11. A SQL or PL/ SQL script is to be created and registered as a concurrent request in Oracle Apps. What feature is used to print the output / log in the SQL or PL/SQL Script?
12. When a report is run what are the triggers that fired. Name them in order of they firing.
13. When you open an apps form from a local machine and get lots of errors, what could be the reason?
14. If a procedure or report takes a long time, how do you get the necessary information before start tuning?
15. How do you convert the functional requirements to technical requirement?
Send your answers to sekhar.byna@gmail.com
Check for the Answers;
Answers with Explanation
Second set of questions you can find here
Oracle apps techno functional Quesitons
2. How do you convert the functional requirements to technical requirement?
3. What are the different Optimizer techniques?
4. What is all the information available from PLAN TABLE? How you force your query to use any index?
5. If a procedure or report takes a long time, how do you get the necessary information before start tuning?
6. What is the use of any particular library in Template form? Mainly CUSTOM.PLL
7. What is a PL/SQL table?
8. What is bulk insert and what other operations you can perform using bulk feature?
9. If you have to write a query on 3 to 4 tables with lots of data what will be your steps for better performance?
10. If you want to insert billions of data from legacy system that is not in Oracle environment, what steps or processes you follow?
11. A SQL or PL/ SQL script is to be created and registered as a concurrent request in Oracle Apps. What feature is used to print the output / log in the SQL or PL/SQL Script?
12. When a report is run what are the triggers that fired. Name them in order of they firing.
13. When you open an apps form from a local machine and get lots of errors, what could be the reason?
14. If a procedure or report takes a long time, how do you get the necessary information before start tuning?
15. How do you convert the functional requirements to technical requirement?
Send your answers to sekhar.byna@gmail.com
Check for the Answers;
Answers with Explanation
Second set of questions you can find here
Oracle apps techno functional Quesitons
