Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

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

Answer»

2.

Do You Know What Record Changes Does Not Affect Database?

Answer»

CHANGE in LIST BOX in RECORD FIELD properties.

Change in List box in Record Field properties.

3.

How To Login Into Bs Mode?

Answer»

DB ACCESS ID

DB Access Id

4.

Explain Where Are Workflow Work Items Found?

Answer»

Worklist

Worklist

5.

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

Answer»

Row class is the component object where it binds all the row's in all level will be in the BUFFER

Row set is the set of ROWS that are in the level ONE from there for EVERY rowset you can access the data in the level TWO

Row class is the component object where it binds all the row's in all level will be in the buffer

Row set is the set of rows that are in the level one from there for every rowset you can access the data in the level two

6.

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

Answer»

System Catalog Tables–  This table contain metadata about all object in the database.

People TOOLS Tables—This table contain the metadata about PEOPLESOFT that is installed on the database. And also the structure that applications use to define specific objects. The structure of the tables is the same for all applications.

Application DATA Tables—  This table contain data entered for use by your organization. Any table updated ad PART of a component is an application data table.

System Catalog Tables–  This table contain metadata about all object in the database.

People Tools Tables—This table contain the metadata about PeopleSoft that is installed on the database. And also the structure that applications use to define specific objects. The structure of the tables is the same for all applications.

Application Data Tables—  This table contain data entered for use by your organization. Any table updated ad part of a component is an application data table.

7.

What Are The Benefits Of The Shared Cache Mode?

Answer»

The shared cache mode offers the following BENEFITS:

  • SERVER processes share a common cache file, which REDUCE the disk space consumed by multiple cache files.
  • Improved initial transaction load performance. Because all objects are already cached, the initial load performance is equivalent to SUBSEQUENT loads. This is the major DIFFERENCE from previous behavior.
  • Improved performance because the system does not write new items to the cache. As such, the cache file never grows. This prevents the host running out of disk space as each PSAPPSRV cache grows in size.
  • Simplifies file management by having fewer files for the system to maintain. 

The shared cache mode offers the following benefits:

8.

Describe The Purge Process?

Answer»

Updates statistics to all of the process request tables before deleting content.

Purges of all process requests with a last UPDATE date that is past the Days Before PURGE value for the specified run statuses.

Deletes all of the SUBDIRECTORIES in the Log_Output directory that are associated with the process requests that are purged from the process request table if the Purge Process Files option was specified.

Purges the report repository tables with EXPIRED DATES, based on the specified number of retention days.

Deletes all directories from the report repository that are associated with processes purged from the report repository tables. 

Updates statistics to all of the process request tables before deleting content.

Purges of all process requests with a last update date that is past the Days Before Purge value for the specified run statuses.

Deletes all of the subdirectories in the Log_Output directory that are associated with the process requests that are purged from the process request table if the Purge Process Files option was specified.

Purges the report repository tables with expired dates, based on the specified number of retention days.

Deletes all directories from the report repository that are associated with processes purged from the report repository tables. 

9.

Name The Configuration File Of Process Scheduler And It’s Location?

Answer»

10.

Name The Configuration File Of Application Server And Its Location?

Answer»

11.

What Is The Alter Audit?

Answer»

It is USED to report DIFFERENCE between the PEOPLETOOLS records DEFINITION and the RDBMS System catalog.

It is used to report difference between the PeopleTools records definition and the RDBMS System catalog.

12.

What Is Sysaudit?

Answer»

SYSAUDIT DELIVERS a report on the integrity of the LINKS WITHIN the PeopleTools Tables.

SYSAUDIT delivers a report on the integrity of the links within the PeopleTools Tables.

13.

What Is Dddaudit?

Answer»

DDDAUDIT DELIVERS a report on the integrity of the LINKS between the System CATALOG Table and PeopleTools Table.

DDDAUDIT delivers a report on the integrity of the links between the System Catalog Table and PeopleTools Table.

14.

What Is Report Repository?

Answer»
  • The Report Repository is simply a Web Server with the report repository SERVLET and directory installed to it.
  • Report Repository Directory: Location on the Web server where the PROCESS scheduler server transfers report and log FILES.
  • Report Repository Servlet: The Java sevlet program that manages the DISPLAY of the report and log files in a BROWSER. If a user has been granted security access, the servlet allow them to view the files. If the user doesn’t have the permission, the servlet will not even show the file exits.
  • The Report Repository will always receive any report produced by processes on the server if you establish this link.

15.

What Is Peoplesoft File Server?

Answer»

The File Server is USED as a CENTRAL STORAGE AREA for files used by development clients.

This allows for a central point of file revision administration. as well as SAVING significant disk space on each client.

The File Server is used as a central storage area for files used by development clients.

This allows for a central point of file revision administration. as well as saving significant disk space on each client.

16.

Which Are The External Objects In A Peoplesoft Environment?

Answer»

17.

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

Answer»
  1. START: webserverstartpia
  2. STOP: webserverstoppia

18.

What Is Peoplesoft Vanilla Database?

Answer»
  1. A Vanilla IMPLEMENTATION is one where no customization are made to the delivered application. 
  2. Vanilla is PEOPLESOFT Application out of the box and implemented exactly as delivered. 
  3. Vanilla implementation simplifies PeopleSoft environment in a number of ways. 
  4. No development costs. 
  5. Fast TIME to rollout 
  6. SIMPLIFIED upgrades.