Frequently Asked PS Administration Interview Questions
Q – 1 Explain What are the components which form the part of Integration Broker?
Ans-
1] Application Messaging
2] Component Interface
3] File Layout
Q – 2 Explain what are the views available in App. Designer project workspace?
Ans- development and upgrade views thats all
Q – 3 What are Menu types available in PeopleSoft?
Ans-
1. Standard
2. Pop-Up
Q – 4 Where do we need to install connectivity software?
Ans- We need to install Connectivity Software on Appserver and scheduler server if they are not on the Database server
Q – 5 A Customer wants to use a new Image in HRMS, where it is stored?
Ans- stored in the database
image – pt_portal_bug
Q – 6 What is One to Many Relationship?
Ans- 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.
example:
authors table
============
author_id (primary key)
lastname
firstname
book_id (foreign key – link to book_id of books table)
books table
===========
book_id (primary key)
title
Q – 7 Given ma a SQL Statement, if you have been asked to check the right syntax?
Ans- 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
Q – 8 Do you know What is the purpose of state records?
Ans- 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.
Q – 9 What are the AE program options?
Ans- 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.
Q – 10 Can we install two different peopletools version on same machine ie client, if yes , what oracle configuration should be installed?
Ans- Yes we can install 2 different client peopletools version on same machine and configuration for the version will be different
Q – 11 How to check processing consuming by peoplesoft applications?
Ans- 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.
Q – 12 What is sys audit?
Ans- 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
Q – 13 I want to update my password and enter a hint for forgotten password. What would I access?
Ans- My system Profile
Q – 14 Suppose I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
Ans- new menu – psmenudefn
– psmenuitem
page – panel defination
secuirty – psauthitem
assuming role and permission list tables are known.
Q – 15 What happens when changing from NO EDIT TO EDIT option?
Ans- 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
Q – 16 Customization done in Dev DB, Which tool you will use to move it to Prod DB?
Ans- Application Designer
Q – 17 How to get a single ouptut by combining two or more queries?
Ans- UNION ALL
Q – 18 When a business requirement in Fit or Gap Analysis does not meet by PeopleSoft then what to do?
Ans- You have to find alternatives. See if creating customized code by developers will fill the gap. If not, look for other products.
Q – 19 What are the status available in PeopleSoft Domain Status Menu?
Ans-
1) Server Status
2) Client Status
3) Queue Status
Q – 20 What event gets fired after DB Update?
Ans- SavePost Change
Q – 21 We can specifically trace the activity of the PSAPPSRV server process by setting which one?
Ans- By setting up LOGFENCE value in PSAPPSRV.CFG file we can trace the activity of PSAPPSRV process.
Q – 22 In the following url
http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHED
ULER.PRCSTYPEDEFN.GBL which one is the component definition?
Ans- PRCSTYPEDEFN.GBL
Q – 23 Suppose you have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?
Ans- PeopleTools tables generally..
But PS related tables also will be affected(Security, Access realted)…
Q – 24 You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this) Where would you look for the information?
Ans- I think It’s from the Customer Connection