41⟩ What are the uses of process profile?
(Scenario based on process profile / process group) Server o/p path override, process he can access.
Peoplesoft
Home Management Peoplesoft
“Peoplesoft Interview Questions and Answers will guide us now that PeopleSoft Inc. was a company that provided human resource management systems (HRMS) and customer relationship management (CRM) and manufacturing, financials, enterprise performance management, and student administration software solutions to large corporations, governments, and organizations. The Oracle Corporation acquired PeopleSoft,Inc. Learn basic and advance concepts of PeopleSoft with our Interview Questions and Answers.”
167 Peoplesoft Questions And Answers
42⟩ Where is Unicode used?
1) IBM DB2/UDB
2) Oracle
3) SQL Server
43⟩ What does ER Diagrams represent?
a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields
44⟩ Where is workflow work items found?
Worklist
45⟩ What is the output when Query is split?
Component and Query view
46⟩ What are destructive statements in SQL?
b) Recreate a Tabled) Recreate a View
47⟩ 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.
48⟩ SYSAUDIT finds for_______.
Orphaned Objects
49⟩ You want to update your password and enter a hint for forgotten password. What would you access?
Profile
50⟩ What are the People Tools available for Integration Broker?
The tools available are Application designer and Integration Broker Setup on the Portal. In peopleSoft, 8.48 messages and Queues can be created from the Setup itself.
51⟩ Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
PSACCESPRFLPSSTATUS PSOPRDEFN
52⟩ Assume that you just finished customization work that involved the creation of many new objects. You can move 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.
53⟩ Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
54⟩ What are the Search Keys you use to find Patches and Fixes?
Report id date release
55⟩ Which of the following fires after the database is updated?
SavePostChange
56⟩ What are the Record field events?
1. FieldChange
2. FieldDefault
3. FieldEdit
4. FieldFormula
5. PrePopup
6. RowDelete
7. RowInit
8. RowInsert
9. RowSelect
10. SaveEdit
11. SavePostChg
12. SavePreChg
13. SearchInit
14. SearchSave
15. Workflow
57⟩ What Record Changes does not affect Database?
List Box item
58⟩ Which RDBMS uses Tablespace?
Oracle, db2, Informix
59⟩ What is the 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 either can be an SQL table or derived Work record. Process_instance field is mandatory in the State Record.
60⟩ How will you get a single output by combining two or more queries?
Using UNION
