PeopleSoft Interview Questions - Answers Set - 5 (Oracle)
When Auto-join check box is checked what does it mean?
Common key fields
What effect would making a change to the EMPLID field in the above project have?
Changes would occur globally; meaning the field is changed everywhere else in the database.
An employee is transferred where should he refer in this aspection?
What are destructive statements in SQL?
b) Recreate a Table
d) Recreate a View
A clients App was 3months behind, what should he do to update the app since it was not working?
b) Apply all Service packs
In Two Tier mode where does authentication happens?
Worklist for a particular user contains marked worked and reassigned buttons. The reassigned button is set from?
appdesigner -> worklist definition
ps application logic reside where?
Where do peopletools data is cached?
My Asst. Manager approves some document; She uses some screens which presents her with all the data. What she do to minimize the data?
You need not create separate DB for every user in PPSFT 8.4 onwards. This is possible because of?
File formats for File Layout?
c) fixed length
Prompt table with no edit to no edit?
a) user can enter values from prompt table
b) user can enter values from prompt table and default value will be populated
Meta-SQL where is it stored?
a) Temp Table
b) SQL Table
c) Query Table
d) Dynamic(Guess: Temp Table, check People books App Engine)
What are all stored in System Catalog?
a) SQL table
b) SQL View
Process Profile contains?
a) Sequence of processes
b) Sequence of jobs
c) batch processes
File format for SQR?
People Soft clients wants to get info about PSPT where to find it?
a) Partner Alliance
b) Partner Connection
c) People Soft Connect
d) Portal connect
e) PSU (check)
Which of the following are object definitions?
a) Mobile Page
b) File Layout
c) App Engine
How do you define the names of the application servers being used to access PeopleSoft?
a) In Configuration Manager, under the Application Servers tab.
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
When do u view Business process map?
a) Change in mapping of data
A System Manager must approve all the transactions what is this?
a) Business Event
b) A Rule
c) A Role
The field mapping button on worklist definition is used for for mapping the fields of worklist record that can be visible on worklist message. We can assign the following type of values to it?
A role name
Question Maximum number of Actions in a Step?
PSWORKLIST record is used for workflow routing . It should contains minimum of ?
6 keys in Ascending orders
SQL Queries on PS_STAFF table?
3 Questions on this table with different queries and results
Let us take a Temp Table TMP_TAO.
In People Tools options the following instance settings are done
Temp Table Instances (Total) : 5
Temp Table Instances (Online): 4
In AE1 App Engine Program the instance count to TMP_TAO is 3
In AE2 App Engine Program the instance count to TMP_TAO is 5.
How many instances are created to TMP_TAO ?
PeopleCode variables (global, component, local, and parameter), method, and property names can now be up to _______ characters long?
PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?
File format u can download query result?
1. XLS 2. CSV
Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
1. Query trees
2. Combination trees
Where is Unicode used?
1) IBM DB2/UDB
3) SQL Server
What is the minimum number of objects an object group can consist of?
Use of process profile?
(scenario based on process profile / process group)Server o/p path override , process he can access
3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.