PeopleSoft Interview Questions only

Interview Questions

PeopleSoft Interview Questions and Answers

(Continued from previous question...)

PeopleSoft Interview Questions only

Did u worked with functions, procedures in SQR?
Performance tuning of SQR?
How do u decide between appeng/Ci and SQR while conversion?
Tell me ur experience with CI?
Diff b/w BI,CI,IB?
Outer join, inner join in sql?
Exp in Object oriented prog?
Normalization in oracle?
Normalization in oracle?
Experience in UNix?
What is the APP engine event in peoplecode.?
what are the different actions in APP ENGINE.?
How many temp records are there in app engine.?
How do you debug your AE.?
Why temp records are needed?
Why state records are needed?
Differences between State and temp records.
Different ways to run AE, SQR.(Command, process scheduler)
Different sql statements and metasql statements.
How do you retrieve a value from scroll..scroll select?
What is scroll select, etc
what is record, row peoplecode.
Data Mover questions.....where did you use etc?
What are the new features in security in 8.0?
Differences between role and operator class?
Load look up in sqr, where did you use?
What are the diffences between AE and SQR?
What is component interface, where did you use?
What is the difference between SaveEdit and FieldEdit?
What is commitment control?
Explain the Process flow in Billing, AR, AM. GL, AP, PO etc.
What is App Reviewer, App Debugger. Differences between them.
Where do you set Peoplecode trace?
What are the Outputs of SQR?
What Chartfieds did you use?
Diff between chartfield and chart of accounts?
What are the parameters that you will give for crystal reports?
what is PSCAMA(Peoplesoft Application messaging attribute)?
What are the techniques for data transfer?
What are the various ways to run sqr?
Explain briefly about compare reports.
What is paycycle and pay cycle manager?
Whats customization did you made?
How do you delete a file using sqr?
How do you stop sqr, while running using a command in sqr(stop)?
What are rename, reporting and layout commands, break point etc in sqr?
What is paycycle and paycycle manager?
What are the Different types of matching in AP(2,3,4 amd receipt only matching)? Explain them.
What is the process of setting in peoplecode debugger?
what is group control in crystals?
Name some app engines u worked on?
What are different peoplecode events?
What are the various peoplecode events.
How did you apply bundles?
What is a bundle?
Diff between instances and servers?
How did you upgrade your PO?
How did you apply your patces and bundles?
How did you do your retrofitting for peoplecode, sql, etc?
How did you migrate from legacy?
How do you denote null in DB2?
What is left join, right join? (learn all joins)?
Diff between oracle and sql server 2000?
Do you know dts in SQLSERVER 2000?
How do you execute a SP from SQR or AE?
What is app messaging, where did you use?
what is component interface, where did you use?
A Simple Query involving Professor, Asst Professor and to find if both can be available before and at a mentioned date.?
DDDAudit what is it?
In the URL identify Portal and Component name?
What are the topics covered in People Books? (Bad options)?
Connect id?
Where do u maintain hierarchies & Create access groupsTree Manager?
Where do I find the doc /// in customer connection---freequently updated . thing like patches?
Customer Connection?
Fit gap analysis --- implementation and upgrade?
Leave went into LOP(scenarios based fit gap)Requirement phase?
The field property is changed from “Prompt with no edit ” to “Prompt with edit ” wht is the effect.No more data edit possible?
Where do one see the status of the process requested to be executedProcess monitor?
Upgrade Assistant Scenario?
SQL injection what is it?
Question on Connect Id, Shared Key used to connect to the DB?
Regarding One to Many Relationship?
Simple Select Statement and Find the Results?
Regarding UPGCONVERT Project used?
Optimizer values passed in Oracle?
Question relating to purpose of State Record?
Which one of the following is true about PIA?
Given a SQL Statement, we have been asked to check the right syntax ..?
Explain with an example, where you used peoplecode extensively?
Tell me about component Buffer?
What is the diff b/w component level peoplecode and record level peoplecode?
If there is same Component X in two different menus, menu1 and menu2 and if u want to assign a different search record for each menu, then which peoplecode function do u use and where do u write the code?
Tell me few peoplecode functions you worked with?
Where can you write the peoplecode?