Explain what are componentbuffer and
databuffer?
Component Buffer:
Component Buffer contains all the Data of active component
Data Buffer: Data Buffer contains Data other then
the Data in the Component Buffer
Data Buffer classes are available in peopleocode,
Rowset,Row,Record,Field,Array,Sql,File,chart,Drid and so on.
What are all the steps invloved in Upgrade
process?
Plan the Upgrade
• Prepare Copy of Production Database
• Install New Release
• Upgrade PeopleTools
• Run and Review Compare Reports
• Apply Application Changes
• Complete Production Copy
• Test the Upgrade
• Move into Production
If we use SQL and Callsection at same time
then Database deadlock will occur.
Why does this Dead lock Occur?
When a SQL is run, there is a
lock on the table
by the database until that section is completed. If during that time there runs
some other process which will use the same table locked by our section using
call section, this process will fail.
What is Activity Type?
What is Cost Center? What is GAP Analysis? Explain
with real time scenario.
Activity type is the nature
of "action comitted or happened" and nature depends on the
environment.
The all value paid or bear is located in small center is
called Cost Center.
GAP Analysis is finding out the "Deficiency or
gap" between ideal system or standard system and existing or current
system.
What is difference between Translate table and Prompt table?
There are few differences
between Translate tables and prompt tables
1. Translate tables have a max lenght of 4 char for each element. But
prompt table elements have no such limitation.
2. There can be only 30 entries in a translate table.
Where as prompt table can have n number of entries.
What is ERP and how it
is related to SAP?
ERP is generally referred to a class of business softwares that addresses a business
firm in totality, rather than one or two functions.
For example, there are accounting softwares, inventory softwares, etc. that
addresses a specific function of a business. But an ERP class software
adrresses all the functions of the business and provides an integrated view of
the business to the management.
SAP is a German company and is the world
leader in ERP softwares across various industries.
How to create the Department
sequrity with navigations?
After You created your Depatments.Navigate to
TreeManger->Tree Manager.Select Appropriate Security Tree (In General in Peoplesoft this will be
DEPT_SECURITY).Attach your newly cretaed Department in the tree in the required node. Then
after run HR_FASTVIEW Application engine
by Navigati through SetupHRMS->Security->Department Security->Update
dept Security.
What is section?
A section is a set of ordered steps that gets
executed as part of a program. You can call sections (and other programs) from
steps within other sections.
What isthe difference between SQL View and Query View?
In Sql view manually write the SQL statement, Query
view use the PS QUERY tool.
What is dynamic view?
Dynamic View is similar to SQL View but we can not
build the dynamic view. When we dont want store the data base then us dynamic
view.
What is the most important Record in PS HRMS?
JOB record
What is the purpose of state records?
To store application data for life of the apllication
Engine process.
Where do you need to install connectivity software?
We need to install Connectivity Software on
Appserver and scheduler server if they are not on the Database server
What are Menu types available?
1. Standard
2. Pop-Up
What are the views available in App. Designer project
workspace?
Development and Upgrade Views
What are the statuses available in PeopleSoft Domain Status
Menu?
1) Server Status
2) Client Status
3) Queue Status
What are the differences between RowClass and RowSet in PeopleSoft?
Rowclass is a single row of data that consists of 1
to n records of data.Rowset object is a data structure used to describe
hirarchel data. It consists of a collection of rows.
What is the default Crystal Report that PeopleSoft Query
tool creates?
ACTQRY.RPT
What Record Changes does not affect Database?
Derived work record
Subrecord
Dynamic view
These record changes doesnot affect the DB
What views available in Application Designer project
workspace?
1. DEVLOPMENT VIEW
2. UPGRADE VIEW
With reference to the
Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a
record in Update/Display Mode only
The main attributes of
a Component Interface (CI) are?
Keys, Properties & Collections, Methods and
Name
Which of the following
is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple
PeopleSoft components
Will Tuxedo continue to
be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
Yes. WebSphere or WebLogic are used as the HTTP
server and servlet engine. They are not used as middleware with the PeopleSoft
Application Server. Tuxedo is always used with PIA, regardless of the HTTP
server or Java servlet engine.
Can a PeopleTools 8.4
and a PeopleTools 8.1xapplication server run on the same machine?
Yes, both PeopleTools 8.4 and PeopleTools 8.1x
application servers can run ona single machine. It is important to ensure that
there are no port clashes between the installations.
IBM How should Web
Application Servers be usedwith PeopleTools 8.1x and PeopleTools 8.4?
The PeopleSoft Internet Architecture uses a web
application server and anHTTP server. PeopleTools 8.12 and above include both
BEA WebLogic andApache with Jserv. With PeopleTools 8.4, both BEA WebLogic and
IBMWebSphere are bundled. Apache with Jserv is no longer a supported
webapplication server combination. Customers can choose which web
applicationserver to run during installation time.In a mixed PeopleTools 8.1x
and 8.4 environment, each PeopleTools installationshould have their own chain
of web application server and application server,PeopleSoft Proprietary and
Confidential Page 5and these can be on the same machine. For example, a
PeopleTools 8.1xinstallation using Apache and Jserv could reside on the same
machine as aPeopleTools 8.4 installation using IBM WebSphere. Care should be
taken toensure that unique port numbers are assigned to each server chain.
Are disconnected mobile
applications supportedin PeopleTools 8.1x?
No. The PeopleSoft Mobile Agent architecture, which
is used to supportdisconnected mobile applications, is only available in
PeopleTools 8.4. ThePeopleSoft Mobile Agent is dependent upon certain core
technologies that werespecifically developed for PeopleTools 8.4.
Is web server load
balancing supported with PeopleTools 8.4?
Customers can set up clusters of BEA WebLogic or
IBM WebSphere servers to do web server load balancing. In such scenarios, if an
instance is down, requests are automatically routed to another instance. For
more information on high availability and clustering with WebLogic, WebSphere
and other web servers.
What HTTP servers and
Java servlet engine combinations are supported with PeopleTools 8.4?
All popular http servers (reverse proxies) are
supported. Please refer to the platforms database on Customer Connection for
specific information on current certified platforms. You may find this at
http://www.peoplesoft.com/corp/en/iou/platforms/index.asp
WorkItem is available
in?
WorkList Record
Where are workflow work
items found ?
Worklist
What BEA product is
used for DB transaction in PS?
Tuxedo
What are the status
available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
What event gets fired
after DB Update?
Save Post Change
Which process is used
for running AE programs which are to be run at a frequency of less than a day?
PSDAEMON
Which RDBMS uses
Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix,
Sybase
How do you login into
BS mode?
DB Access Id
What are Menu types
available?
1. Component
2. PeopleCode
3. Separator
Activate Event is Valid
for following?
Standard & Secondary
Query is split into
what?
Component and Query view
What are destructive
statements in SQL?
b) Recreate a Table
d) Recreate a View
ER Diagrams represent?
a) Graphical Representation of Business process and
Relationsb) Flowchart of tables and Fields
Tuning can be done on
which servers?
a) Database Server
b) App Server
c) Batch Server
e) Web Server
Use of process profile?
(scenario based on process profile / process
group)Server o/p path override , process he can access
Where is Unicode used?
1) IBM DB2/UDB
2) Oracle
3) SQL Server
Which of the above record definitions is NOT stored on the
database and is therefore NOT required to be built?
Drived Work Record definitions not stored in the
database and not require for build
When a business requirement in Fit/Gap Analysis
does not meet by PeopleSoft then
Go for customizations through Consultants
What are the Search Keys you use to find Patches and Fixes?
Report id date release
What are the People Tools available for Integration Broker?
Application designer and Integration Broker Setup
on the Portal. In peoplSoft 8.48 messages and Queues can be created from the
Setup itself
SYSAUDIT finds for
Orphaned Objects
You want to update your password and enter a hint for
forgotten password. What would you access?
Profile
Which of the following commands can be run in Bootstrap
mode?
Bootstrap mode is actually logging into the App designer
in 3-tier mode i.e. Logon to the App server. Data mover scripts are run on
3-tier mode.
Which of the following fires after the database is updated?
SavePostChange
Which of the following are Record field events?
FieldChange • FieldDefault • FieldEdit •
FieldFormula • PrePopup • RowDelete • RowInit • RowInsert • RowSelect •
SaveEdit • SavePostChg • SavePreChg • SearchInit • SearchSave • Workflow
What Record Changes does not affect Database?
List Box item
Which RDBMS uses Tablespace?
oracle,db2,Informix
How do you set up table-sharing in PeopleTools applications?
SETID
How will you get a single ouptut by combining two or more
queries?
Using UNION
Question relating to purpose of State Record?
State Records are used in AE to Pass values from
action and section to the other. It also allows you to restart the App engine.
For this, the State record has to be a SQL table. A state record can either be
an SQL table or derived Work record. Process_instance field is mandatory in the
State Record.
What event gets fired after DB Update?
Savepostchange
Tell me ur
experience with CI?
CI's can be used to upload data from legacy systems
through excel to CI or create new data within PeopleSoft from another
component.
How do u decide between appeng/Ci and SQR while conversion?
When u want to validate data upfront before loading
them into db, better plan to use appeng or ci, when you are think of huge data
to be loaded SQR would be a better option
Performance tuning of SQR?
1)Use Load-lookup and Arrays 2)Use SQT files.
3)Generate multiful reports. 4)Use correct sql joins.
What is the difference between SaveEdit and FieldEdit?
Field Edit Validate particular field only. Save
Edit validate all the fields in that component.
What are the diffences between AE and SQR?
AE is built on PeopleSoft proprietery language
called PeopleCode, where as SQR is a third party tool.
What is record, row peoplecode.
Record peoplecode is triggered whenver you deal
with the record. EX when u right a piece of code on Record Field change that
code is fired whenever the Field is changed in any page. There is nothing
called Row PeopleCode.
How do you retrieve a value from scroll..scroll select?
scrollselect(1,targetname,recordfiledname)
Different sql statements and metasql statements.
SQL statements are Database specific whereas
meta-SQL statements are Db independent.
Different ways to run AE, SQR.(Command, process scheduler)
2-tier,4-tier,process scheduler
How do you delete a file using sqr?
delete($filename)
The Trace tab in
Configuration Manager only traces Windows client (two-tier) interactions?
True
TriggerBusinessEvent is used for triggering the
workflow and its written on workflow event. TriggerBusinessEvent has the
syntax?
TriggerBusinessEvent(BusProcess,BusActivity,BusEvent);
The following is an entry from the application
reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4
Source=233What does the Source=233 parameter in the above LOG file entry
identify?
The statement being executed is line 233 of the PeopleCode program.
One-to-Many?
Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as
one and only one table.
What the following command will do? psadmin -p
start -d hrdmo?
Starts a Process Scheduler
Which of the Task cannot be done through PSADMIN?
Starting Web Server
Activate Event is Valid for following?
Standard & Secondary
What is the result of the search with the following
criteria in PS Books?
SQL Table OR Field
What category of commands can be executed in data
mover?
Sql , data mover commands
The example below demonstrates the use of SQR flags
in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the
above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
The application server dynamically scales server
processes according to the volume of transaction requests which is known as?
Spawning
Where do you create the process security groups?
Security Administrator 20
What is the event that fires after all database
updates are over?
Save post change
In which one of the following views would you see
the fields, criteria, and other details associated with the current query?
Query view 9
From the following statements which one is NOT true
about Pub Broker?
Pub Broker is invoked after Pub Contractor Handler evaluates routing
rules and writes contract(s)
From the following statements which one is NOT true
about Pub Broker?
psserver in configuration properties
PeopleSoft tracks object changes using a system
table. Which PeopleTools System table is used to track object changes?
PSRELEASE
PeopleSoft has its own naming convention for system
and non-system (application) tables. In the list below, RECORDNAME refers to
the name of any table or record.Referring to the above information, which one
of the following identifies the naming convention PeopleSoft uses for system
tables?
PSRECORDNAME
Which is a record that PeopleTools adds to every
level of the Message Structure during processing?
PSCAMA
What is the configuration file that contains the
entire collection configuration values for a given application server domain?
PSAPPSRV.CFG
Which command shuts down an application server
domain using a “forced” shutdown method?
psadmin -c shutdown! -d ps800dmo
The DB User mentioned in Connect ID should have
permission to which Three PeopleSoft Tables?
PSACCESPRFLPSSTATUS PSOPRDEFN
PeopleSoft has its own naming convention for system
and non-system (application) tables. In the list below, RECORDNAME refers to
the name of any table or record.Referring to the above information, which one
of the following identifies the naming convention PeopleSoft uses for
non-system(application) tables?
PS_RECORDNAME
The initial values that you see in PSADMIN are
derived from the configuration template that you select when you create your
domain. Where these templates reside in the system?
PS_HOME/appserv in the Application Server
You just finished customization work that involved
the creation of many new objects. You must now migrate these objects from your
development database (source) to a testing database (target) to conduct more
elaborate testing.Referring to the above information, why would adding your
objects to a Project streamline the migration to a new database?
Projects provide the ability to migrate all objects at once or each
object type individually. *
Which of the following menu options allows you to
modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
Trace 255 command line option produces the trace
file with the name?
PID.AET
Where can u see the status of the job report and
details in secured way?
Process monitor
Non Repudiation property can be set?
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication
Designer->Message ->Properties
If you delete a page from PSPT application which
all tables are affected –?
People Tools
If u change the long name of translate field what
object to be altered?
Page def
When do configuration changes made using the
configuration Manager take effect?
Once you exit PeopleSoft and log back in.
Which one of the following is NOT a valid
PeopleSoft query type?
Message agent queries
Interlink data type can be declared as?
Local
The following ApiObject data type objects can’t be
declared as Global:?
JavaObject
PeopleSoft’s hub to handle complex system-to-system
interactions.?
Integration Broker
Suppose the CEO wants a list of the departments
whose MINIMUM salary is greater than $100,000. Your manager asks you to
determine the quickest method to deliver this data to the CEO. Since writing an
SQR will take too much time, you decide to use PeopleSoft query. Referring to
the above, what function would you use, in combination with the aggregate
function "Minimum" to produce the result set required?
HAVING CRITERIA 18.
DoSave( ) can be called from one of the following
events?
FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save
Prechange & SavePostChange
In which PeopleCode event does ALL data validation
take place?
FieldEdit
Peoplecode attached with Push Button can be
associated with which of the following events?
Field Edit, Field Change
The main attributes of
a Component Interface (CI) are?
Keys, Properties & Collections, Methods and Name
Which one of the
following are standard properties when a Component Interface (CI) is created?
GetHistoryItems
With reference to the
Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode
only
Which of the following
are TRUE when a Component Interface (CI) is created on component that has Add
action enabled?
Get keys, Create keys and Find keys gets created automatically. The Create
method is created along with the other Standard methods for the CI
Which of the following
can be mapped as Find Keys for a Component Interface ?
A OR b
Which of the following
is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple PeopleSoft components
The following are various
steps that describes the peoplecode logic while implementing a Component
Interface?
1. Establish a user session
2. Get the Component Interface
3. Populate the Create Keys
4. Create an Instance of the CI
5. Populate the required fields
6. Save the CI
Will Tuxedo continue to
be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine.
They are not used as middleware with the PeopleSoft Application Server. Tuxedo
is always used with PIA, regardless of the HTTP server or Java servlet engine.
Can a PeopleTools 8.4
and a PeopleTools 8.1x database run on the same machine?
Yes, databases can co-exist on the same physical machine. In most cases,
the databases themselves can exist within the same RDBMS, however, it is
important to verify that the database version required by PeopleTools 8.4 is
the same as for the current PeopleTools 8.1x implementation.
Can a PeopleTools 8.4
and a PeopleTools 8.1xapplication server run on the same machine?
Yes, both PeopleTools 8.4 and PeopleTools 8.1x application servers can run
on a single machine. It is important to ensure that there are no port clashes
between the installations.
How does the PeopleSoft
Enterprise Portal work with 8.1x and 8.4 applications?
There are several scenarios that may exist when customers use the
PeopleSoft Enterprise Portal with a mixture of 8.1x and 8.4 applications.
Specific information on the use of the PeopleSoft Enterprise Portal in a
blended environment will be available in a forthcoming white paper, which will
be available on Customer Connection. In general, the recommendation is to use
the PeopleSoft Enterprise Portal 8.4with 8.1x and 8.4 applications, rather than
an older version.
For the servlet layer
on the web server, what version of the Java Servlet API are the PIA Java
Servlets coded to with PeopleTools 8.4?
The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft's Java
Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be
noted that the PeopleSoft Internet Architecture is supported only on the BEA
WebLogic and WebSphere servlet engines.
IBM How should Web
Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
The PeopleSoft Internet Architecture uses a web application server and an
HTTP server. PeopleTools 8.12 and above include both BEA WebLogic and Apache
with Jserv. With PeopleTools 8.4, both BEA WebLogic and IBM WebSphere are
bundled. Apache with Jserv is no longer a supported web application server
combination. Customers can choose which web application server to run during
installation time. In a mixed PeopleTools 8.1x and 8.4 environment, each
PeopleTools installation should have their own chain of web application server
and application server, PeopleSoft Proprietary and Confidential Page 5and these
can be on the same machine. For example, a PeopleTools 8.1xinstallation using
Apache and Jserv could reside on the same machine as a PeopleTools 8.4
installation using IBM WebSphere. Care should be taken to ensure that unique
port numbers are assigned to each server chain.
Why did PeopleSoft
bundle IBM WebSphere Advanced Single Server Edition rather than Advanced
Edition?
The Advanced Single Server Edition (AEs) of WebSphere provides the same core
J2EE and Web Services programming model as the Advanced Edition (AE) with
simplified administration. In the AE version WebSphere uses DB2 or other
standard database to keep the configuration and runtime information to support
very large farm of WebSphere servers. However, it is one more database to
install, administer and maintain. The AEs version does not use the database and
uses file based configuration in a way that is similar to BEA WebLogic.
PeopleSoft and IBM WebSphere architects determined that AEs version would
satisfy the deployment requirements of PeopleSoft customers and would make it
easy for owning and administering PeopleSoft Applications based on WebSphere.
Will the PeopleSoft
Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work
with my other corporate web servers and tools?
One of the core values of the PeopleTools development group is investment
protection. The time, money and resources that you may have already invested in
licensing another web server, training developers and administrators, building
and deploying other web applications will not be compromised by this decision.
How is this accomplished
Is BEA WebLogic the
same thing as the web server that was previously on the Tuxedo CD?
No. The web server that was delivered on the Tuxedo CD has absolutely
nothing to do with WebLogic. WebLogic is a web application server that is
designed for large-scale production websites. The HTTP server on the Tuxedo CD
was only there to provide a mechanism for launching the graphical Tuxedo
administration console if the Tuxedo administrator didn't already have a web
server in place. It was never intended for large-scale, production website use
— only for a system administrator or two.
Are disconnected mobile
applications supported in PeopleTools 8.1x?
No. The PeopleSoft Mobile Agent architecture, which is used to support
disconnected mobile applications, is only available in PeopleTools 8.4. The
PeopleSoft Mobile Agent is dependent upon certain core technologies that were
specifically developed for PeopleTools 8.4.
Is WebSphere certified
on PeopleTools 8.1x?
No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to
use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere
for early adopters program, created and managed by IBM. Further information
about this program can be found in the whitepaper The IBM WebSphere 8.1x Early
Adopter Program. Are there additional license requirements for IBM WebSphere
Are there advantages or
disadvantages to using BEA WebLogic over IBM WebSphere or vice versa?
No. Both products are certified with PIA as of version 8.4 and work equally
well. By offering both BEA WebLogic and IBM WebSphere, we give our customers
more choices and flexibility to run PeopleSoft in their preferred environment.
Is web server load
balancing supported with PeopleTools 8.4?
Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to
do web server load balancing. In such scenarios, if an instance is down, requests
are automatically routed to another instance. For more information on high
availability and clustering with WebLogic, WebSphere and other web servers.
Both BEA WebLogic and
IBM WebSphere have the ability to plug into many different web servers. Does
PeopleSoft support the web servers that they plug into?
BEA and IBM provide plug-ins for many of the
leading web servers. This allows the customer to use their own HTTP web server
and WebLogic’s or WebSphere’s Java servlet engine. PeopleSoft uses this plug-in
capability to support IIS. We have no reason to believe that there will be any
issues with other web servers that WebLogic or WebSphere are able to work with
through their plug-in architecture, but PeopleSoft GSC will not support these
other web servers with PeopleTools 8.4
Does Application
Messaging work between 8.1xand 8.4 applications?
Application Messaging is used by PeopleSoft
applications to communicate with one another. This is true not just for 8.1x
and 8.4 applications, but also between an 8.1x and an 8.4 application. For
example, the HRMS 8.3 applications, which are based on PeopleTools 8.15, can
communicate with Financials 8.4applications, which are based on PeopleTools
8.4, using Application Messaging. If specific issues materialize relating to
the Application Messages published by certain applications, these new messages
will be made available to customers.
Why is PeopleSoft no
longer supporting Apache Jserv?
Apache JServ was a servlet engine that was
supported in PeopleTools 8.1x. This support has been removed from PeopleTools
8.4 for several reasons: v JServ is no longer an active product and is in
maintenance mode and there are no longer any new official releases. v Our
customers have exhibited a desire to use commercial products for
mission-critical enterprise web application servers rather than open source
solutions. Therefore, moving to support Tomcat is not seen as a reasonable
solution. v Apache can still be used as an HTTP server with BEA WebLogic .
What HTTP servers and
Java servlet engine combinations are supported with PeopleTools 8.4?
All popular http servers (reverse proxies) are
supported. Please refer to the platforms database on Customer Connection for
specific information on current certified platforms. You may find this at http://www.peoplesoft.com/corp/en/iou/platforms/index.asp
WorkItem is available
in?
WorkList Record
Where are workflow work
items found ?
Worklist
In which platform does Crystal and Psnvision
works?
Windows (Correct)
You want to update your
password and enter a hint for forgotten password. What would you access?
User Profile
Question based on
changing prompt table, what happens when changing from NO EDIT TO EDIT option?
user can type only prompt table values and the
default values gets populated from the database.
Customization done in
Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB
Your Onsite DBA has
called you up and told you that one of the tables PS_ABC_TAO has grown very big
in size. Based on the standard naming convention, you have determined that the
record is a temporary record since it ends with _TAO You look into the database
and decide that that the data is not required any more. You ask the DBA to
delete the data in the table. Next day you get a call from an irritated user
who says that a daily process that took only 1 minute to run is taking about 2
hours today. You look into his process and find that it uses PS_ABC_TAO as a
temporary table. What would you suggest the DBA to do ?
Update statistics on the table
(Some scenario) Question relating DBA Purging
Temporary Table?
Update Statistics
How many Message nodes
are possible for a database.?
Unlimited
How will you get a
single output by combining two or more queries?
UNION
What BEA product is
used for DB transaction in PS?
uxedo
Which one of the
following Data Types is NOT supported by the PeopleCode programming
environment?
TIMESTAMP
What hyperlinks
available in PeopleBooks? Some options with different hyperlinks not available
in peoplebooks, select the correct one?
Study all hyperlinks in the first page of people
books.
The example below
demonstrates the use of SQR flags in the configuration manager directories
folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report
Writer upon execution?
Specifies the output path
When a business
requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
Some options:
1. Customize PS application (Yes)
2. Buy third party software (Yes)
3. Call PS Development
Center for Enhancement
(Yes)
What are the status
available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
Which of the following
are part of an AE program ?
Section ,Step and Action
Which of the following
fires after the database is updated?
SavePostChange
What event gets fired
after DB Update?
SavePostChange
For downloading patches
and fixes , you have gone to the customer connection and looking under 8 april,
2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?
Released
In which one of the
following views would you see the fields, criteria, and other details
associated with the current query?
Query view
PeopleSoft tracks object
changes using a system table. Which PeopleTools System table is used to track
object changes?
PSRELEASE
PeopleSoft has its own
naming convention for system and non-system (application) tables. In the list
below, RECORDNAME refers to the name of any table or record. Referring to the
above information, which one of the following identifies the naming convention
PeopleSoft uses for system tables?
PSRECORDNAME
Which process is used
for running AE programs which are to be run at a frequency of less than a day ?
PSDAEMON
you can specifically
trace the activity of the PSAPPSRV server process by setting the?
PSAPPSRV.tracesql
Which of the following
is correct in order to start the Process Scheduler Server from the command line
using psadmin.?
Psadmin –p start –d
In the following url
http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBLwhich
one is the component definition?
PRCSTYPEDEFN.GBL
I have created a Menu
and a Page and given user access to that page, which of the tables gets
affected on this (Scenario)?
PeopleTools Tables
You are a PeopleSoft
Partner and wish to get information on database performance benchmark ( or
something like this) Where would you look for the info ?
PeopleSoft Knowledge base SYSAUDIT finds for
Orphaned Records
Which RDBMS uses
Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix,
Sybase
Changing Prompt Table
with NO Edit to Prompt Table with Edit?
Only selection of existing data is possible
Which command is valid
in both bootstrap and regular mode when operating the data mover?
GRANT_USER
PeopleCode events
pertaining to Record Field:?
FieldEdit, SaveEdit and RowDelete
Which of the following
are Record field events ?
FieldChangeSearchSave and SavePreChange
Which of the following
commands can be run in Bootstrap mode?
ENCRYPT_PASSWORD
What commands are valid
in BS mode?
ENCRYPT_PASSWORD
What views available in
Application Designer project workspace?
Development and Upgrade
Which of the above
record definitions is NOT stored on the database and is therefore NOT required
to be built?
Derived/Work Record
You have downloaded an
Application fix as a project from the customer connection. Where would you
upgrade it to ?
Demo
PS Query definition is
stored on which server?
DB Server
How do you login into
BS mode?
DB Access Id
If you want to log into
DataMover in Bootstrap mode, you would login as..?
Database superuser
What is added as new
option in Build apart from Create Tables, Indexes, Views?
Create Trigger
Where will you
configure for failover of Application Server (Scenario)?
Configuration.properties
Which one of the
following is a transaction control statement ?
Commit
What Record Changes
does not affect Database?
Change in List box in Record Field properties
(correct)
Which one of the
following steps is NOT part of performing an upgrade?
Apply all outstanding patches, prior to upgrade
Update and Fixes: R-*
files refers to?
Application Updates and Fixes
How do you set up
table-sharing in PeopleTools applications?
Add the field, SETID, as a key field to each table
you want to share, and then define the set control field. PeopleSoft reserves
ALL Message Sets (in Utilities, Message Catalog) up to which number?
What is the default Crystal
Report that PeopleSoft Query tool creates?
ACTQRY.RPT
(Some scenario) Find which is not part of AE
Program, Options would be?
Action,Section,Step,Event
Which of the following
are true with respect to validate signon with database option enabled in
psadmin.?
1. The application server first attempts to connect
to database using the user id and password as part of the database connection
string.
2. User must be defined on either the operating system or the database and
within the PeopleSoft.
Which of the Following
are true for force Shutdown In PeopleSoft Domain Shutdown menu?
1. shuts down the domain using the tmshutdown -k
TERM -c command.
2. A forced shutdown is a non-quiescent shutdown that immediately terminates
all the processes
After logging into
customer connection, you wish to search for fixes/patches. What are the search
criteria's available ?
1. Report ID
2. Date / time
3. Release
What are the Search
Keys you use to find Patches and Fixes?
1. Release
2. Updated date time
3. Report Id
Which one of the
following tree types is NOT supported in the PeopleSoft tree manager?
1. Query trees
2. Combination trees
Which Web Services is
only used as a Proxy Server?
1. MS IIS
2. Apache
In PeopleCode Debugger
what are the valid values?
1. Go
2. Step Over
3. View Variable Value
Select the components
which form the part of Integration Broker?
1. File Layout
2. CI
3. app. Messaging
what are the views
available in App. Designer project workspace (multiple answer)?
1. Development
2. Upgrade
What are Menu types
available?
1. Component
2. PeopleCode
3. Separator
Database Connectivity
Drivers should be installed in the following System?
1. Client Workstation in two tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)
Where do you need to
install connectivity software?
1. batch server
2. App server
3. two tier client
What are the People
Tools available for Integration Broker?
1. Appl. Messaging
2. Component Interface
3. File Layout
A Customer wants to use
a new Image in HRMS, where it is stored?
DB Server
Can you access pia from
mac OS?
Yes
Which language
technology is used in app messaging?
XML
Which one of the
following PeopleCode debugging tools automatically converts values of any data
type other than object into string values for viewing during debugging?
WinMessage
PIA screens and
recognize it?
Where are the work items presentWorkilist
Where do u set the web
server cache?
webserver configuration.properties file
Your company obtained
the newest Application Release of PeopleSoft, and you need to prepare for the
upgrade. Upon reading the new Release Notes, you notice that changes were made
to two COBOL modules (batch programs). You need to decide how to compare the
current versions of these COBOL programs with the versions delivered with the
new PeopleSoft application release. Which would be the fastest method of
comparing these different versions?
Use non-PeopleSoft comparison tools. 5.
True or False. A
business Process be used as a Navigator Home page ?
true
True or False. The
physical, dedicated tables are locked at the time the Application Engine
program is loaded into memory?
True
True or False. State
Record can be Dynamic Record?
True
True or False. In Call
Section – Action it is possible to leave the Program ID with blank Value in
certain cases?
True
True or False. You can
assign multiple databases and application servers to a single profile. But,
each database and application server must be assigned to only one profile?
True
Please wait