PeopleSoft Administration Interview Preparation Guide
Download PDF

PeopleSoft Administration frequently Asked Questions by expert members with experience in PeopleSoft Administration. These interview questions and answers on PeopleSoft Administration will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. So get preparation for the PeopleSoft Administration job interview

24 PeopleSoft Administration Questions and Answers:

2 :: Suppose you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

PeopleTools tables generally..

But PS related tables also will be affected(Security,
Access realted)...

4 :: We can specifically trace the activity of the PSAPPSRV server process by setting which one?

By setting up LOGFENCE value in PSAPPSRV.CFG file we can
trace the activity of PSAPPSRV process.

6 :: What are the status available in PeopleSoft Domain Status Menu?

1) Server Status
2) Client Status
3) Queue Status

7 :: When a business requirement in Fit or Gap Analysis does not meet by PeopleSoft then what to do?

You have to find alternatives. See if creating customized
code by developers will fill the gap. If not, look for other

9 :: Customization done in Dev DB, Which tool you will use to move it to Prod DB?

Application Designer

10 :: What happens when changing from NO EDIT TO EDIT option?

Its like parent child relation.

No Edit -- it does allow to edit the data when the table
(Child table) have parent child relationship
Edit -- it does not allow to edit the data when the table
(Child table) have parent child relationship

11 :: Suppose I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

new menu - psmenudefn
- psmenuitem

page - panel defination

secuirty - psauthitem

assuming role and permission list tables are known.

13 :: What is sys audit?

Sys Audit is an SQR report that checks the integrity of the
peopletools tables. It checks the peopletools objects at
deeper levels and also it cross checks the references to
the peopletools tables.

Usually this report is used to check whether the database
is complete or not

14 :: How to check processing consuming by peoplesoft

In unix solaris, w ehave the top utility installed. I t
will show you the top most consuming processes on the
server. You can even see what is that exact process with
their PID.

15 :: Can we install two different peopletools version on same machine ie client, if yes , what oracle configuration should be installed?

Yes we can install 2 different client peopletools version
on same machine and configuration for the version will be

16 :: What are the AE program options?

Do When, Do While, De select, Peoplecode, SQL or call
section, log message, and Do until

SQL and CallSection are mutually exclusive and one can be
used at a time in a step.

17 :: Do you know What is the purpose of state records?

State record is used in AE program property to hold the
data in buffer and it passes the data one step to another
step or one action to another action.Most of the time
record type of the state record is derived/work but while
using with restart logic record type sd be SQL Table.

18 :: Given ma a SQL Statement, if you have been asked to check the right syntax?

Run in backend whether WinSQL or Toad and check if errors
out if it is the cursor will stop exactly where the syntax
is wrong

19 :: What is One to Many Relationship?

In a one-to-many relationship, each row in the related to
table can be related to many rows in the relating table.
This allows frequently used information to be saved only
once in a table and referenced many times in all other
tables. In a one-to-many relationship between Table A and
Table B, each row in Table A is linked to 0, 1 or many rows
in Table B. The number of rows in Table A is almost always
less than the number of rows in Table B.

authors table
author_id (primary key)
book_id (foreign key - link to book_id of books table)

books table
book_id (primary key)