2

PeopleSoft Technical Interview Questions

Are you looking for a PeopleSoft Job?  Check out these PeopleSoft Technical Interview Questions and test your knowledge.

1. What are the main attributes of a Component Interface (CI)?
   Keys, Properties & Collections, Methods and Name

2. Can a PeopleTools 8.4x and a PeopleTools 8.1x  database runs on the same machine?
   Yes, databases can co-exist on the same physical machine In most cases, the databases themselves can exist within the same RDBMS; however, it is important to verify that the database version required by PeopleTools  is the same as for the current PeopleTools x implementation.

3. Does Application Messaging work between 8.1x  and 8.4x applications?
   Application Messaging is used by PeopleSoft applications to communicate with one another This is true not just for x and  applications, but also between an x and an  application For example, the HRMS  applications, which are based on PeopleTools , can communicate with Financials  applications, which are based on PeopleTools , using Application Messaging If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers

4. You want to update your password and enter a hint for forgotten password What would you access?
   User Profile

5. Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
   User can type only prompt table values and the default values gets populated from the database

 

6. Customization done in Dev DB, Which tool I will use to move it to Prod DB?
   Use App Designer and Go Tools > Copy Project > To Database

7. How many Message nodes are possible for a database?
   Unlimited

8. How will you get a single output by combining two or more queries?
   UNION

9. Which Data Type is NOT supported by the PeopleCode programming environment?
   TIMESTAMP

10. What are the statuses available in PeopleSoft Domain Status Menu?
    Server, Client and Queue Status

11. What are parts of an AE program?
    Section, Step and Action

12. Which peoplecode event is fired after the database is updated?
    SavePostChange

14. For downloading patches and fixes, you have gone to the customer connection and see Report IDS like R-CCHEN-VPJM What does R stand for?
    Released
15. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
    Query view
16. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
    PSRELEASE

16. Which process is used for running AE programs which are to be run at a frequency of less than a day?
    PSDAEMON

17. You can specifically trace the activity of the PSAPPSRV server process by setting the?
    PSAPPSRV.tracesql

18. I have created a Menu and a Page and given user access to that page, which of the tables gets affected in this scenario?
    PeopleTools Tables

19. Which command is valid in both bootstrap and regular mode when operating the data mover?
    GRANT_USER

20. PeopleCode events pertaining to Record Field:
    FieldEdit, Save Edit and Row Delete

21. What views available in Application Designer project workspace?
    Development and Upgrade

22. Which of the record definitions in PeopleSoft is NOT stored on the database and is therefore NOT required to be built?
    Derived/Work Record

24. You have downloaded an Application fix as a project from the customer connection Where would you upgrade it to?
    Demo
25. PS Query definition is stored on which server?
    DB Server
26. How do you login into Boot strap mode?
    Using DB Access Id

26. Where will you configure failover of Application Server ?
    Configuration.Properties

27. What Record Changes does not affect Database?
    Change in List box in Record Field properties

28. Which Web Services is only used as a Proxy Server?

• MS IIS
• Apache

29. What are the components that form the part of Integration Broker?

30. A Customer wants to use a new Image in HRMS, where it is stored?
    DB Server

31. Which PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
    Win Message

32. Where does you set the web server cache?
    Webserver configuration.properties file

33. The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory?
    True

34. State Record can be Dynamic Record?
    True

35.  In Call Section – Action it is possible to leave the Program ID with blank Value in certain cases?
    True

36. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
    True

37. Which task cannot be done through PSADMIN?
    Starting Web Server

38. Where do you create the process security groups?
    Security Administrator

39. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
    PSRELEASE

40. What is the configuration file that contains the entire collection configuration values for a given application server domain?
    PSAPPSRV.CFG

41. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
    True

42. Does AE Parse SQL?
    False

43.  Which of the following record is not found in database?
    Derived /Work record

44.  Two Program views of AE Program?
    Definition, Program flow

45.  Query is split into what?
    Component and Query view

You might have observed that there are many lesser skilled people, who manage to find the jobs easily and you find yourself at the receiving end. The basic reason is that understanding of the subject is not enough. How you present yourself and answer in the interview is the key. You need to treat your career as as investment to reap benefits. You need an amazing resume with an amazing cover letter and you need to skillfully answer the interview questions.