1. What are the interfaces you worked on?
2. What are the different validations you performed on the staging table?
3. Name some interface table?
4. What are the API’s you used?
5. Tell me about your role in your past projects.
6. What are the major customizations or achievements you got in previous projects?
7. How would you rate yourself in PLSQL?
8. What are varrays?
9. How table types are differ from database tables?
10. How will you load bulk data from a table type to a table?
11. What are the functions that are available for a table type?
12. How you delete a particular data in a table type?
13. What are the different exceptions that are available?
14. What if I define when others first in Exceptions block?
15. What are database triggers?
16. Name some database triggers.
17. Can we write triggers on a view?
18. Can we insert into two tables at a time using single insert statement?
19. How can we register a concurrent program?
20. Among xml publisher reports and RDF reports which is comfortable?
21. What is used in a concurrent program to pass as a parameter to a report?
22. What are the triggers available for reports?
23. How will you send a report as a mail?
24. What is bursting?
25. How comfortable are you with forms?
26. Name some triggers that are mandatory for a form?
27. What is process for RDF reports?
28. How to start the process of page personalization in OAF if you are given a base page?
29. How will you deploy a OAF page?
30. Why we are using Import after page deployment to server?
31. What are the tables that are related to OAF?
32. If I want the structure of the page how can I get and what are the different ways to achieve this?
33. What is substitution? Why we are doing it?
34. Tell the importer command? What are the different ways to import a page?
35. Why VO.xml files are not getting imported?
36. What is MDS data and how it is getting generated?
37. How will you extend a Controller for a page and what is the step by step process that needed to be followed?
38. How will you debug a Concurrent program?
39. Explain P2P cycle and O2C cycle with tables and different stages, tables involved in the process?
40. What are different value sets available?
41. What is ADF-DI?
42. How ADF-DI is different from forms? What are the advantages and disadvantages?
43. If I want to have headers and line details we are doing it by forms and ADF-DI which process is preferable and how much time will it take to complete?
44. What is Copy and No Copy?
45. What is the difference between View and Materialized View?
46. What is the hierarchy of tables for Purchase order?
No comments:
Post a Comment