People-soft Certification Questions answers 2016

People-soft Certification Questions answers 2016.

1. Meta-SQL where is it stored.
a) Temp Table b) SQL Table c) Query Table d) Dynamic
2. Which of the following menu options allows you to modify the Last Process Instance
Number used within the system?
a) Process Scheduler, Use, Job Definitions
b) Process Scheduler, Use, Process Servers
c) Process Scheduler, Use, Process System
d) Process Scheduler, Use, Administration
e) Process Scheduler, Use, Process Definitions
Not in 8.4 …In 8.4 Process Scheduler-System Settings
3. In which one of the following views would you see the fields, criteria, and other details
associated with the current query?
a) Object view
b) Record view
c) Component view
d) Designer view
e) Query view

4. The Security Administrator is not available. You are in a hurry to grant a user the ability to
start an application server, and you decide to make the change in the actual application server
configuration file, rather than using the Security Administrator. (7.5 QUESTION)
Referring to the above information, how would you grant a user the ability to start an
application server using the application server configuration file, PSAPPSRV.CFG?
Choice 1
Add the OPERATOR ID to the PSAPPSRV.CFG file, and update the STARTAPPSVR
column of the PSOPRDEFN table to a value of 1.
Choice 2
Add the OPERATOR ID to the PSAPPSRV table, and update the STARTAPPSVR column
of the PSOPRDEFN table to a value of 1.
Choice 3
Add the OPERATOR ID to the PSOPRDEFN table, and update the STARTAPPSVR
parameter in the PSAPPSRV.CFG file to a value of 1.
Choice 4
Add the OPERATOR ID to the PSAPPSRV.CFG file, and update the STARTAPPSVR
parameter in the PSAPPSRV.CFG file to a value of 1.
Choice 5
Add the OPERATOR ID to the PSAPPSRV table, and update the STARTAPPSVR
parameter in the PSAPPSRV.CFG file to a value of 1.
5. What are the steps involved in joining PS_JOB and PS_POSITION_DATA and forcing a
row to be returned even when there is NOT a match between the records while still maintaining
PS Query security?
Choice 1
Create a view and include the outer join as required as part of the view. Add View
to Query Tree. Select View as part of Query.
Choice 2
Create a view and include the outer join as required as part of the view. Select View as
part of Query.
Choice 3
Write an SQR to perform the outer join. Write the data to a temp table. Query the temp
table using PS Query.
Choice 4
Create a new record and include the outer join as required. Add Record to Query Tree.
Select Record as part of Query.
Choice 5
Create an expression within PS Query joining the two records and including the
outer join on the correct field.———  (Possible only in Oracle)

.pdf FileDownload Click here

Need More? Click Here