1. What is Connect id?

A Connect ID is a valid user ID that, when used during login, takes the place of PeopleSoft User IDs for the logon process. Using Connect ID means you don?t have to create a new database user for every PeopleSoft user you add to the system.

Connect id performs initial connection to the databse when the user tries to signon.

3. Where do you set People code trace?

In configuration manager trace tab.

4. Explain Where do we find the doc /// in customer connection---frequently updated. thing like patches?

log into Peoplesoft customer connect and navigate to Patches and fixes. To see future updates in plan - Click on Support -> Roadmaps and Schedules.

6. What is File formats for File Layout?

a) xml
b) csv
c) fixed length

7. Explain Which of the following are object definitions?

a) Mobile Page
b) File Layout
c) App Engine

8. Explain Why state records are needed?

A state record is a People Soft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one action to another.Think of the fields of the Application Engine state record as the working storage for your Application Engine program.
An Application Engine state record can be either a physical record or a work record, and any number of state records can be associated with a program. Physical state records must be keyed by process instance.

10. Explain SQL injection?

SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution.

Download Interview PDF

16. What is app messaging, where did we use?

It is used to transfer data to the third party systems.

17. Explain SQL Queries on PS_STAFF table?

3 Questions on this table with different queries and results

18. Explain Process Profile contains?

a) Sequence of processes
b) Sequence of jobs
c) batch processes

21. What is left join, right join?

Learn about the all joins

22. What are the new features in security in 8.0?

Learn about the new features in security in 8.0

25. Explain Load look up in sqr, where did you use?

load look up is a temporary storage where we can store data from multiple tables.we use it in setup section.