PeopleSoft Administrator Interview Questions with Answers
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.
What is shared cache and how you enable it?
The system assumes that a preloaded cache exists in the share directory. The
preloaded cache contains most instances of the managed object types that are
cached to file. While booting application server, if shared cache is enabled but
no cache files exist, the system reverts to unshared caching.
To set shared caching for the domain, set the Set ServerCacheMode to 1. With
this option enabled, the system stores the cache information in the following
directory:
appservcacheshare
What are the benefits of The Shared Cache Mode?
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. Simplifies file management by having fewer files for the
system to maintain.
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 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, 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.
What
is the function of an Application Server?
Application Server is the heart of PIA, all applications are available here.
Take more loads It stores the Business Logic.
Prepare the SQL statements and send to
Database. Combination of several process.
JSL, WSL, JSH, PSAPPSRV, PSSAMSRV,
PSQCKSRV, PSQRYSRV, PSOPTENG, PUBSUB & TUXEDO
What is Tuxedo?
a.
Tuxedo is a transaction-based Application Server
b. Tuxedo
Application Server is a collection of server process that communicate to
Database server.
c.
On the server-side WSL are listening to client. JSL are listening to JAVA CLIENT.
d. These
server process request individual service can handle jobs such Application
Server.
SQL
CALLS, PAGE BUILD & PAGE SERVE
What is JOLT?
a.
JOLT is a Java enabled subset of Tuxedo
b. JOLT
performs identical functions but handles connection to java applets/servlets
exclusively.
c.
JOLT provides the communication between WebServer and Application Server.
A PeopleSoft user ID is the ID you enter
at the PeopleSoft sign in page
Connect ID?
The connect ID performs the initial
connection to the database.
A connect ID is a valid user ID that,
when used during sign in, takes the place of PeopleSoft user IDs. Using a
connect ID means you do not have to create a new database user for every
PeopleSoft user that you add to the system.
Access ID?
When you create any user ID, you must
assign it an access profile, which specifies an access ID and password.
The PeopleSoft access ID is the RDBMS ID
with which PeopleSoft applications are ultimately connected to your database after
the PeopleSoft system connects using the connect ID and validates the user ID
and password. An access ID typically has all the RDBMS privileges necessary to
access and manipulate data for an entire PeopleSoft application
Symbolic IDs: The symbolic ID acts as an
intermediary entity between the user ID and the access ID
PeopleSoft encrypts the access ID when
it is stored in the People Tools security tables. Consequently, an encrypted
value cannot be readily referenced or accessed. So, when the access ID, which
is stored in PSACCESSPRFL, must be retrieved or referenced, the query selects
the appropriate access ID by using the symbolic ID as a search key.
All the user IDs are associated with a symbolic ID, which in turn is associated with an access ID. If you change the access ID, you need to update only the reference of the access ID to the symbolic ID in the PSACCESSPRFL table. You do not need to update every user profile in the PSOPRDEFN table.
SignON Process In Peoplesoft:
1-The application server starts and uses
the connect ID and user ID specified in its configuration file (PSAPPSRV.CFG)
to perform the initial connection to the database.
When the system verifies that the access
ID is valid, the application server begins the persistent connection to the
database that all PeopleSoft Pure Internet Architecture and Microsoft Windows
three-tier clients use to access the database. Typically, the users signing in
using a Microsoft Windows workstation are developers using PeopleSoft
Application Designer.
Post a Comment