Peopesoft Interview Questions

1. What are 2-tire architecture, three-tire architecture and PIA structure? done
2. How you convert customized pages into portal page? In another word describes steps involved.
3. What are application server and web server?
4. What is application engine and process scheduler and how it works?
5. What are differences between 7.5 and 8.4 A.E programs?
A.
6. What is people code and how it is used in peoplesoft? What is major difference in 7.5 to 8.4?
7. What are fixes and patches? Describe step involved in applying fixes/patches while post-production?
8. What /when issues report to Peoplesoft customer help desk (Customer Connection site)?
9. What is tracing and debugging. How it differs in 2-Tier, 3-tier and PIA?
10. Describe basic steps in implementation of new Peoplesoft project?
11. Describe basic steps in upgradation of peopleSoft 7.5 to 8.4 project?
12. What is Compare report? What is use of it? How do you use to apply previous version customizations?
13. Describe Change Control process, object Lock, difference between development area/upgrade areas in Application designer, copying objects across databases?
14. What are major differences PS 7.5 and 8.4 security, workflow?
15. Describe what is difference in using role query and role user in workflow?
16. What is message Agent? Describe usage, configuration of Message Agent, Message agent server?
17. Describe what are Component Interface, Business Interlink, and Integration Broker? Describe how these differ in usage, development/configuration?
18. What is data conversion/ Data Migration? Describe steps involved?
19. Describe difference between SQR Process and Report?
20. Describe steps involved in giving SQR/Crystal access to user through portal menu?
21. Describe difference between SQL record, View record (Query, SQL), Derived record, Work Records, sub record?
22. Describe Tree Manager, adding objects to an existing tree definition, moving tree manager definition/queries to across databases?
23. What is SYSAUDIT, DDDAUDIT?
24. Describe steps in defining a job Process scheduler and how you run as batch processes.
25. Describe the difference between tools records, Control records and transactional records?
26. Describe what is difference between “Update display” and “Update display ALL”?
27. What are chart fields?
28. What is Archival, purging process and how you purge data based on cutoff date (say older than 3 yrs from certain date)?
29. Describe all peoplecode events and when those triggers? What peoplecode event always triggers? In other words if you want to define global variable or functions in which peoplecode even you right?
30. What is meaning of keys columns and alternate key columns in a record?
31. What is cluster index and non-cluster index?
32. Who is the owner of all PS objects in database?
33. Which are called temporary table, staging table?
34. What are different types of pages (Primary, secondary, run control, hidden page, sub page, etc)? Describe each property?
35. What is difference between Add and update search records?
36. What are key peoplecode functions we use in multi scroll level pages to find cursor position, value, to transfer page, date functions, Sqlexec() function, etc. also describe new functions in 8.4 tools.
37.