Interview Questions.

Q1. What Is The Alter Audit?

It is used to record distinction among the PeopleTools statistics definition and the RDBMS System catalog.

Q2. Describe The Purge Process?

Updates statistics to all the system request tables before deleting content material.

Purges of all manner requests with a remaining replace date this is past the Days Before Purge cost for the desired run statuses.

Deletes all of the subdirectories within the Log_Output directory which can be associated with the system requests which might be purged from the procedure request desk if the Purge Process Files option become designated.

Purges the file repository tables with expired dates, based on the desired variety of retention days.

Deletes all directories from the report repository which might be related to techniques purged from the file repository tables. 

Q3. What Is Peoplesoft Vanilla Database?

A Vanilla implementation is one wherein no customization are made to the added application. 

Vanilla is PeopleSoft Application out of the container and carried out exactly as added. 

Vanilla implementation simplifies PeopleSoft environment in a number of ways. 

No improvement fees. 

Fast time to rollout 

Simplified enhancements.

Q4. Explain Where Are Workflow Work Items Found?

Worklist

Q5. Explain What Are The Differences Between Rowclass And Rowset In Peoplesoft?

Row elegance is the aspect object in which it binds all the row's in all degree can be in the buffer

Row set is the set of rows which can be in the degree one from there for each rowset you can get right of entry to the information inside the stage two

Q6. Name The Configuration File Of Application Server And Its Location?

Location: APPSRV/

Name : psappsrv.Cfg

Q7. Do You Know What Record Changes Does Not Affect Database?

Change in List container in Record Field homes.

Q8. What Is Sysaudit?

SYSAUDIT can provide a report on the integrity of the links in the PeopleTools Tables.

Q9. How Do We Start & Stop Peoplesoft Webserver In Single Server Domain?

Start: webserverstartpia

Stop: webserverstoppia

Q10. What Is Report Repository?

The Report Repository is virtually a Web Server with the file repository servlet and listing installed to it.

Report Repository Directory: Location on the Web server in which the system scheduler server trfers report and log documents.

Report Repository Servlet:  The Java sevlet program that manages the display of the file and log files in a browser.  If a user has been granted security get right of entry to, the servlet allow them to view the documents.  If the consumer doesn’t have the permission, the servlet will now not even show the document exits.

The Report Repository will constantly receive any file produced through procedures at the server in case you establish this hyperlink.

Q11. Which Are The External Objects In A Peoplesoft Environment?

TUXEDO

COBOL

CRYSTAL

WEB SHERE

WEB LOGIC

JAVA

DATABASE(ORACLE, SQL, DB2, SYBASE)

MS-OFFICE

Q12. What Is Dddaudit?

DDDAUDIT offers a report at the integrity of the hyperlinks between the System Catalog Table and PeopleTools Table.

Q13. Explain What Are The Search Keys You Use To Find Patches And Fixes?

Release

Updated date time

Report Id

Q14. What Are The Benefits Of The Shared Cache Mode?

The shared cache mode offers the subsequent advantages:

Server strategies percentage a not unusual cache report, which lessen the disk area consumed with the aid of more than one cache documents.

Improved initial traction load overall performance. Because all objects are already cached, the initial load overall performance is equivalent to next masses. This is the foremost difference from previous behavior.

Improved overall performance due to the fact the machine does no longer write new items to the cache. As such, the cache document in no way grows. This prevents the host going for walks out of disk area as every PSAPPSRV cache grows in size.

Simplifies file control with the aid of having fewer documents for the gadget to hold. 

Q15. What Is Peoplesoft File Server?

The File Server is used as a principal garage area for documents used by improvement clients.

This permits for a vital factor of report revision management. As well as saving significant disk area on each consumer.

Q16. How To Login Into Bs Mode?

DB Access Id

Q17. What Are The Three Logical Sets Of Tables That Make Up A Peoplesoft Database And What Is The Purpose Of Each?

System Catalog Tables–  This table include metadata about all item inside the database.

People Tools Tables—This table contain the metadata about PeopleSoft that is set up at the database. And additionally the structure that applications use to outline precise objects.  The shape of the tables is the identical for all applications.

Application Data Tables—  This  table include statistics entered to be used via your enterprise.  Any desk up to date advert a part of a factor is an software records table.