Management :: Peoplesoft  Job Interview Questions and Answers

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.

1 What are Menu types available?
2 Where do you need to install connectivity software?
3 What is the purpose of state records?
4 What is the most important Record in PS HRMS?
5 What is dynamic view?
6 What is the difference between SQL View and Query View?
7 What is section?
8 How do you create the Department security with navigations?
9 What is ERP and how it is related to SAP?
10 What is difference between Translate table and Prompt table?
11 What is Activity Type? What is Cost Center? What is GAP Analysis? Explain with real time scenario.
12 If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?
13 What are all the steps involved in Upgrade process?
14 Explain what are component buffer and data buffer.
15 What are the views available in App. Designer project workspace?
16 What are the statuses available in PeopleSoft Domain Status Menu?
17 What are the differences between RowClass and RowSet in PeopleSoft?
18 What is the default Crystal Report that PeopleSoft Query tool creates?
19 What Record Changes does not affect Database?
20 What views available in Application Designer project workspace?
21 With reference to the Component Interface Tester which of the following is NOT TRUE?
22 What are the main attributes of a Component Interface (CI)?
23 Which of the following is NOT TRUE in Component Interface (CI) Architecture?
24 Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
25 Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
26 IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
27 Are disconnected mobile applications supported in PeopleTools 8.1x?
28 Is web server load balancing supported with PeopleTools 8.4?
29 What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
30 Where the WorkItem is available?
31 Where is workflow work items found?
32 What BEA product is used for DB transaction in PS?
33 What is the status available in PeopleSoft Domain Status Menu?
34 What event is fired after DB Update?
35 Which process is used for running AE programs, which are to be run at a frequency of less than a day?
36 Which RDBMS uses Tablespace?
37 How do you login into BS mode?
38 Activate Event is Valid for following?
39 What are Menu types available?
40 What is the output when Query is split?
41 What are destructive statements in SQL?
42 What does ER Diagrams represent?
43 On which servers Tuning can be done.
44 What are the uses of process profile?
45 Where is Unicode used?
46 Which of the above record definitions is NOT stored on the database and therefore not required to build?
47 What are the Search Keys you use to find Patches and Fixes?
48 What are the People Tools available for Integration Broker?
49 SYSAUDIT finds for_______.
50 You want to update your password and enter a hint for forgotten password. What would you access?
51 Which of the following commands can be run in Bootstrap mode?
52 Which of the following fires after the database is updated?
53 What are the Record field events?
54 What Record Changes does not affect Database?
55 Which RDBMS uses Tablespace?
56 How do you set up table sharing in PeopleTools applications?
57 How will you get a single output by combining two or more queries?
58 What is the purpose of State Record?
59 Tell me your experience with CI?
60 How do you decide between appeng/Ci and SQR while conversion?
61 What is the performance tuning of SQR?
62 What is the difference between SaveEdit and FieldEdit?
63 What are the differences between AE and SQR?
64 What is record, row peoplecode?
65 How do you retrieve a value from scroll.scroll select?
66 What is the difference between sql statements and metasql statements?
67 What are the different ways to run AE, SQR? (Command, process scheduler)
68 How do you delete a file using sqr?
69 The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
70 Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the syntax__________.
71 The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233. What does the Source= 233 parameter in the above LOG file entry identify?
72 What the following command will do? (Psadmin -p start -d hrdmo)
73 Which of the Task cannot be done through PSADMIN?
74 What is the result of the search with the following criteria in PS Books?
75 What category of commands can be executed in data mover?
76 The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqr What do the above SQR flags signify to the SQR Report Writer upon execution?
77 The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
78 Where do you create the process security groups?
79 What is the event that fires after all database updates?
80 In which one of the following views would you see the fields, criteria, and other details associated with the current query?
81 From the following statements, which one is NOT true about Pub Broker?
82 PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
83 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.
84 Which is a record that PeopleTools adds to every level of the Message Structure during processing?
85 What is the configuration file that contains the entire collection configuration values for a given application server domain?
86 Which command shuts down an application server domain using a forced shutdown method?
87 Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
88 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?
89 Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
90 WhichTrace 255 command line options produces the trace file with the name?
91 Where can you see the status of the job report and details in secured way?
92 How can youset Non-Repudiation property?
93 If you delete a page from PSPT application, which all tables are affected?
94 If you change the long name of translate field what object is to be altered?
95 When do configuration changes made using the configuration Manager take effect?
96 Which one of the following is NOT a valid PeopleSoft query type?
97 Interlink data type can be declared as?
98 Which is the PeopleSofts hub to handle complex system-to-system interactions?
99 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?
100 In which PeopleCode event does ALL data validation take place?
101 Which of the following events can be associated with Peoplecode attached with Push Button?
102 Which one of the following are standard properties when a Component Interface (CI) is created?
103 Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
104 Which of the following can be mapped as Find Keys for a Component Interface?
105 What are the various steps that describe the peoplecode logic while implementing a Component Interface?
106 Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
107 How does the PeopleSoft Enterprise Portal work with 8.1x and 8.4 applications?
108 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?
109 Why did PeopleSoft bundle IBM WebSphere Advanced Single Server Edition rather than Advanced Edition?
110 Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with other corporate web servers and tools?
111 Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?
112 Is WebSphere certified on PeopleTools 8.1x?
113 Are there advantages or disadvantages to using BEA WebLogic over IBM WebSphere or vice versa?
114 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?
115 Does Application Messaging work between 8.1xand 8.4 applications?
116 Why is PeopleSoft no longer supporting Apache Jserv?
117 Where will the WorkItem is available?
118 In which platform does Crystal and Psnvision works?
119 Question based on changing prompt table, what happens when changing from NO EDIT-TO-EDIT option?
120 Customization has been done in Dev DB, which tool can be used to move it to Prod DB?
121 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?
122 What is DBA Purging Temporary Table?
123 How many Message nodes are possible for a database?
124 Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
125 What are the hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one?
126 The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C: PSHrmsSqr. What do the above SQR flags signify to the SQR Report Writer upon execution?
127 When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
128 Which of the following are parts of an AE program?
129 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?
130 You can specifically trace the activity of the PSAPPSRV server process by setting the?
131 Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin?
132 In the following URL, which one is the component definition? http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBL
133 You have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
134 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?
135 Is it possible to change Prompt Table with NO Edit to Prompt Table with Edit?
136 Which command is valid in both bootstrap and regular mode when operating the data mover?
137 What are the PeopleCode events pertaining to Record Field?
138 Which of the following are Record field events?
139 What commands are valid in BS mode?
140 You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it?
141 In which server, PS Query definition is stored?
142 If you want to log into DataMover in Bootstrap mode, how would you login?
143 What is added as new option in Build apart from Create Tables, Indexes, and Views?
144 Where will you configure for failover of Application Server (Scenario)?
145 Which one of the following is a transaction control statement?
146 Which one of the following steps is NOT part of performing an upgrade?
147 What does Update and Fixes: R-* files refer?
148 Which is not a part of AE Program, Options would be?
149 Which of the following are true with respect to validate sign in with database option enabled in psadmin?
150 Which of the Following are true for force Shutdown in PeopleSoft Domain Shutdown menu?
151 Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
152 Which Web Services is only used as a Proxy Server?
153 In PeopleCode Debugger what are the valid values?
154 List the components, which form the part of Integration Broker.
155 What are the views available in App. Designer project?
156 In which system, Database Connectivity Drivers should be installed?
157 If Customer wants to use a new Image in HRMS, where it is stored?
158 Can you access pia from mac OS?
159 Which language technology is used in app messaging?
160 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?
161 Where does set the web server cache?
162 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?
163 A business Process is used as a Navigator Home page. True or False
164 The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory. True or False
165 State Record can be Dynamic Record. True or False
166 In Call Section  Action it is possible to leave the Program ID with blank Value in certain cases. True or False
167 You can assign multiple databases and application servers to a single profile. However, each database and application server must be assigned to only one profile. True or False