PeopleSoft Questions



 SQR Questions
Java Certification Material
Java Certification Material
Java Certification Material

Java Certification Material
Testing Questions
J2ee Questions
PLC Questions
SOA Questions
HR Questions
General Questions
WebServices Questions
Typical Questions
Intelligent Questions


Best CV's
How to prepare a CV 

CV writing links


Hot Jobs
Jobs links

 Contact Us




About Us


  1. PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?< xml="true" ns="urn:schemas-microsoft-com:office:office" prefix="o" namespace="">

a)    10,000,000

b)    12,000,000

c)     14,000,000

d)    16,000,000

e)    18,000,000


  1. You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.

Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?

a)    Projects do not copy the actual objects, but only the Project Definition. You must still migrate the objects individually.

b)    Projects automatically overwrite the same objects in the target database and, thus, reduce the need for consistency checks.

c)     Migrating projects automatically produces a comparison report of the objects in the Project and those same objects in the target database.

d)    Projects enable migration of individual objects only which ensures you do not overwrite objects in the target database unknowingly.

e)    Projects provide the ability to migrate all objects at once or each object type individually.


  1. PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.

Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?







4. Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs).

You need to decide how to compare the current versions of these COBOL programs

       with the versions delivered with the new PeopleSoft application release. Which would be    

       the fastest method of comparing these different versions?


a)    Find Object References.

b)    Application Designer, Compare Batch Programs.

c)     Application Designer, Upgrade View.

d)    Use non-PeopleSoft comparison tools.

e)    Application Designer, Tools, Upgrade, Compare & Report.


5.       Which one of the following tree types is NOT supported in the PeopleSoft tree manager?

a)    Node-Oriented trees

b)    Query trees

c)     Detail trees

d)    Summary trees

e)    Combination trees


6.       Which of the following menu options allows you to modify the Last Process Instance Number used within the system?

a)    Process Scheduler, Use, Job Definitions

b)    Process Scheduler, Use, Process Servers

c)     Process Scheduler, Use, Process System Settings

d)    Process Scheduler, Use, Administration

e)    Process Scheduler, Use, Process Definitions


7.       Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?

a)    MsgGetText

b)    MsgGet

c)     MessageBox

d)    WinMessage

e)    ExpandBindVar







Inline bind variables can be included in any PeopleCode string. An inline bind variable is a field reference (in the form recordname.fieldname), preceded by a colon. The inline bind variable references the value in the field.

ExpandBindVar expands any inline bind variables that it finds in str into strings (converting the data type of non-character fields) and returns the resulting string. This works with inline bind variables representing fields containing any data type except Object. It also expands bind variables specified using additional parameters.

Unlike MsgGet, MsgGetText returns the message without a message set and message number appended to the message.


8.       In which one of the following views would you see the fields, criteria, and other details associated with the current query?

a)    Object view

b)    Record view

c)     Component view

d)    Designer view

e)    Query view


9.   In which PeopleCode event does ALL data validation take place?

a)    SavePostChange

b)    FieldFormula

c)     SavePreChange

d)    FieldEdit

e)    FieldChange

10. Which one of the following is NOT a valid PeopleSoft query type?

a)    Message agent queries

b)    Reporting queries

c)     Role queries

d)    Ad-hoc queries

e)    View queries


11. The following is an entry from the application reviewer LOG File:
start  Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233

What does the Source=233 parameter in the above LOG file entry identify?

a)    The statement being executed is line 233 of the PeopleCode program.

b)    The number of references to the PERSONAL_DATA.EMPLID field

c)     The log file line number 233

d)    The value contained in the PERSONAL_DATA.EMPLID field

e)    The length of the PeopleCode program


12. Which one of the following is the primary purpose of the application designer's SQL Alter function?

a)    To update the database table to be in sync with the PeopleTools object definition of that table

b)    To alter the definition of a PeopleTools object without affecting the actual object within the database

c)     To drop and recreate a table that must be changed as the result of a customization

d)    To modify a table that needs changes as part of a customization

e)    To update the PeopleTools object definition to be in sync with the definition of that table in the database


13. Which one of the following PeopleSoft Objects CANNOT be locked by developers as part of Change Control Locking as displayed above?

a)    Process Definitions

b)    Business Process Maps

c)     Panel Groups

d)    Fields

e)    Records


14. How do you define the names of the application servers being used to access PeopleSoft?

a)    In Configuration Manager, under the Application Servers tab.

b)    In Application Designer, under the Tools menu.

c)     In Application Designer, using the Create New Object option.

d)    In Security Administrator, under the Define Profiles option.

e)    In the Application Servers parameters of the configuration file, PSAPPSRV.CFG.


15. PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.

Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for non-system(application) tables?







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







The information that a trigger records could include the user that made a change, the type of change made, when the change was made, and so on. Because the trigger records the user ID of the user modifying the base table, it is essential that you have the Enable DB Monitoring parameter set in PSADMIN. (This feature is not supported for Informix or DB2 UDB.). All of this information—Record Name, Audit Record Name, Trigger Name, and Create Trigger Statement—get saved to the PeopleSoft table, PSTRIGGERDEFN.



17. Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query.

Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?

a)    JOIN


c)     UNION




18. What is the minimum number of objects an object group can consist of?


a)    0

b)    1

c)     2

d)    3

e)    4

19. Where do you create the process security groups?


a)    Application Designer

b)    Process Scheduler

c)     Define Business Rules, Define General Options

d)    Security Administrator

e)    Process System


20. What effect would making a change to the EMPLID field in the above project have?

a)    No effect on the field itself, but only on the field's definition.

b)    Changes would occur globally; meaning the field is changed everywhere else in the database.

c)     Changes to the field cannot be made unless you rename the field.

d)    Changes to the field do not take effect until you build or rebuild the entire project.