Best collection of Peoplesoft technical interview questions

Questions from Application Engine

1. How can you make a dynamic call to an app engine program through call section?
2. What is the difference between %Select and %SelectInit?
3. What is the difference between having a work record and a physical table as state record?
4. What is the advantage of set based processing and how are temporary tables beneficial for this?
5. What are the different commit levels in an application engine program?
6. What is a restartable application engine? How can you make an AE restartable?
7. What is the difference between Application Engine and SQR?
8. What is the significance of %UpdateStats?
9. What are set processing and parallel processing?

Questions from SQR

1. What is the difference between ask and input?
2. What is the difference between show and display commands?
3. What are the different debugging techniques of SQR?
4. How will you make an SQR process to run from process schedular?
5. What is the program flow of SQR?
6. How can you return value from a SQL procedure?
7. Describe the local and global variables in SQR?
8. What is the significance of On-Error and On-Break?
9. What are different error handling techniques used in SQR?

Questions from Peoplecode/Application Package

1. What are the use of delivered get set methods in application class?
2. What are the private and protected methods and properties in application class?
3. How can we reference application class and instantiate constructor variable in peoplecode?
4. In which ways you can achieve dynamic prompt?
5. What is the difference between dosave() and dosavenow()?
6. How can you bypass search page in an component?
7. How can impose row level security on an component?
8. What are think time functions? Name different types of think time functions?
9. What are the DiscardRow() and StopFetching() functions?
10. What is the PreBuild event used for?
11. What are different logics/functionalities you can write on searchInit event?
12. Describe the component processor flow in add mode?
13. On which events we should not use think time functions and why?
14. Tell the syntax of navigationg to level 2 scroll on page.

Questions from Application Designer (Record/Pages/Component)

1. What is the search edit record field property and what is its significance?
2. Describe the field level audit and record level audits in PeopleSoft?
3. What are SubRecords and what are they used for?
4. What are the different types of records and which of them need to be built?
5. What is the difference between writing code on record level and that on component?
6. How do you implement row level security using security view of query security?
7. What is the significance of set control field on record properties?
8. How does a page behave in deferred and interactive mode?
9. What are the different action types (Modes) on component?
10. What is the meaning of Set Component changed checkbox on page field property?
11. What is the significance of Disable saving page checkbox on component property?
12. What are the different types of Menus? What is the use of PopUp Menu?

Questions from Workflow

1. What are the events mainly used for triggering workflow and why?
2. How do you create and use Role by user query for Workflow?
3. Which function is used to trigger the workflow? Describe the syntax.
4. What is the structure of worklist record?
5. What is a pooled worklist?
6. What are the different ways to mark a worklist item as worked?
7. What are the different assignment techniques used Email/Worklist field mapping?

Questions on Peoplesoft Query

1. What are the different types of Queries in PeopleSoft?
2. How can you create an outer join in PSQuery?
3. What are the different uses of PSQuery?
4. Where and how can we see the output of a scheduled query?
5. What is PSQuery and what are its advantages?
6. How can you implement distinct fetch in Query?
7. How can you create union in PSQuery?
8. What is the use of expressions in PeopleSoft Query?

Questions on Component Interface

1. What is the object type of Component Interface?
2. Describe collections and properties in Component Interface.
3. What are the different delivered methods of CI? Describe them.
4. How can you override or extend the delivered methods of CI?
5. Name the different standard properties of Component Interface.
6. What are get keys, create keys and find keys in CI?
7. What is the difference between Get and Find methods?

SHARE

peoplesoft

• 
• 
• 
• 
•