1. What are Menu types available?
Ans.
1. Standard
2. Pop-Up
2. Where do you need to install connectivity software?
Ans.
We need to install Connectivity Software on Appserver and scheduler server if they are not on the Database server
3. What is the purpose of state records?
Ans.
To store application data for life of the application Engine process
4. What is the most important Record in PS HRMS?
Ans.
JOB record
5. What is dynamic view?
Ans.
Dynamic View is similar to SQL View but we cannot build the dynamic view.
When we do not want store the database then us dynamic view.
6. What is the difference between SQL View and Query View?
Ans.
In Sql view manually write the SQL statement, Query view use the PS QUERY tool.
7. What is section?
Ans.
A section is a set of ordered steps that is executed as part of a program.
You can call sections (and other programs) from steps within other sections.
8. How do you create the Department security with navigations?
Ans.
To do this, after you have created your Departments Navigate to TreeManger->Tree Manager and select Appropriate Security Tree (In General in People soft this will be DEPT_SECURITY).Attach your newly created 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.
9. What is ERP and how it is related to SAP?
Ans.
ERP is generally referred to a class of business software that addresses a business firm in totality, rather than one or two functions
For example, there are accounting software, inventory software, etc. that addresses a specific function of a business. However, ERP class software addresses 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 software across various industries.
10. What is difference between Translate table and Prompt table?
Ans.
There are few differences between Translate tables and prompt tables1.
Translate tables have a max length of 4 char for each element.
However, 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.
11. What is Activity Type? What is Cost Center? What is GAP Analysis?
Ans.
Activity type is the nature of "action committed 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.
12. If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?
Ans.
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.
13. What are all the steps involved in Upgrade process?
Ans.
Plan the Upgrade :
1) Prepare Copy of Production Database
2) Install New Release
3) Upgrade People Tools
4) Run and Review Compare Reports
5) Apply Application Changes
6) Complete Production Copy
7) Test the Upgrade
8) Move into Production
14. Explain what are component buffer and data buffer.
Ans.
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 people code, Rowset, Row, Record, Field, Array, Sql, File, chart, Drid and so on.
15. What are the views available in App. Designer project workspace?
Ans.
Development and Upgrade Views
16. What are the statuses available in PeopleSoft Domain Status Menu?
Ans.
1) Server Status
2) Client Status
3) Queue Status
17. What are the differences between RowClass and RowSet in PeopleSoft?
Ans.
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 hierarchal data. It consists of a collection of rows.
18. What is the default Crystal Report that PeopleSoft Query tool creates?
Ans.
ACTQRY.RPT
19. What Record Changes does not affect Database?
Ans.
Derived work record
Subrecord
Dynamic view
These record changes do not affect the DB
20. What views available in Application Designer project workspace?
Ans.
1. Development View
2. Upgrade View
21. With reference to the Component Interface Tester which of the following is NOT TRUE?
Ans.
GetExisting option is equivalent to opening a record in Update/Display Mode only
22. What are the main attributes of a Component Interface (CI)?
Ans.
Keys, Properties & Collections, Methods, and Name
23. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
Ans.
A component interface can be mapped to multiple PeopleSoft components
24. Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
Ans.
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.
25. Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
Ans.
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.
26. IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
Ans.
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 IBMWebSphere 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 environments, 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.
27. Are disconnected mobile applications supported in PeopleTools 8.1x?
Ans.
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.
28. Is web server load balancing supported with PeopleTools 8.4?
Ans.
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.
29. What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
Ans.
All popular http servers (reverse proxies) are supported.
Please refer to the platforms database on Customer Connection for specific information on current certified platforms.
30. Where the WorkItem is available?
Ans.
WorkList Record
31. Where is workflow work items found?
Ans.
Worklist
32. What BEA product is used for DB transaction in PS?
Ans.
Tuxedo
33. What is the status available in PeopleSoft Domain Status Menu?
Ans.
Server, Client and Queue Status
34. What event is fired after DB Update?
Ans.
Save Post Change
35. Which process is used for running AE programs, which are to be run at a frequency of less than a day?
Ans.
PSDAEMON
36. Which RDBMS uses Tablespace?
Ans.
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
37. How do you login into BS mode?
Ans.
DB Access Id
38. Activate Event is Valid for following?
Ans.
Standard & Secondary
39. What are Menu types available?
Ans.
1. Component
2. PeopleCode
3. Separator
40. What is the output when Query is split?
Ans.
Component and Query view
41. What are destructive statements in SQL?
Ans.
Recreate a Tabled
Recreate a View
42. What does ER Diagrams represent?
Ans.
a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields
43. On which servers Tuning can be done?
Ans.
a) Database Server
b) App Server
c) Batch Server
d) Web Server
44. What are the uses of process profile?
Ans.
(Scenario based on process profile / process group) Server o/p path override, process he can access.
45. Where is Unicode used?
Ans.
1) IBM DB2/UDB
2) Oracle
3) SQL Server
46. Which of the above record definitions is NOT stored on the database and therefore not required to build?
Ans.
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
47. What are the Search Keys you use to find Patches and Fixes?
Ans.
Report id date release
48. What are the People Tools available for Integration Broker?
Ans.
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.
49. SYSAUDIT finds for?
Ans.
Orphaned Objects
50. You want to update your password and enter a hint for forgotten password. What would you access?
Ans.
Profile
51. Which of the following commands can be run in Bootstrap mode?
Ans.
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.
52. Which of the following fires after the database is updated?
Ans.
SavePostChange
53. What are the Record field events?
Ans.
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
54. What Record Changes does not affect Database?
Ans.
List Box item
55. Which RDBMS uses Tablespace?
Ans.
Oracle, db2, Informix
56. How do you set up table sharing in PeopleTools applications?
Ans.
SETID
57. How will you get a single output by combining two or more queries?
Ans.
Using UNION
58. What is the purpose of State Record?
Ans.
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.
59. Tell me your experience with CI?
Ans.
CI's can be used to upload data from legacy systems through excel to CI or create new data within PeopleSoft from another component.
60. How do you decide between appeng/Ci and SQR while conversion?
Ans.
When you want to validate data upfront before loading them into db, better plan to use appeng or ci, when you are thinking of huge data to be loaded SQR would be a better option
61. What is the performance tuning of SQR?
Ans.
1. Use Load-lookup and Arrays
2. Use SQT files.
3. Generate multiple reports.
4. Use correct sql joins.
62. What is the difference between SaveEdit and FieldEdit?
Ans.
Field Edit Validate particular field only, but Save Edit validates all the fields in that component.
63. What are the differences between AE and SQR?
Ans.
AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool.
64. What is record, row peoplecode?
Ans.
Record peoplecode is triggered whenever 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.
65. How do you retrieve a value from scroll.scroll select?
Ans.
Scrollselect (1, targetname, recordfiledname)
66. What is the difference between sql statements and metasql statements?
Ans.
SQL statements are Database specific whereas meta-SQL statements are Db independent.
67. What are the different ways to run AE, SQR? (Command, process scheduler)
Ans.
2-tier, 4-tier, process scheduler
68. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False?
Ans.
True
69. What the following command will do? (Psadmin -p start -d hrdmo)
Ans.
Starts a Process Scheduler
70. Which of the Task cannot be done through PSADMIN?
Ans.
Starting Web Server
71. What is the result of the search with the following criteria in PS Books?
Ans.
SQL Table OR Field
72. What category of commands can be executed in data mover?
Ans.
Sql, data mover commands
73. The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
Ans.
Spawning
74. Where do you create the process security groups?
Ans.
Security Administrator 20
75. What is the event that fires after all database updates?
Ans.
Save post change
76. From the following statements, which one is NOT true about Pub Broker?
Ans.
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
77. Which is a record that PeopleTools adds to every level of the Message Structure during processing?
Ans.
PSCAMA
78. Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Ans.
Process Scheduler, Use, Process Definitions
79. Where can you see the status of the job report and details in secured way?
Ans.
Process monitor
80. How can youset Non-Repudiation property?
Ans.
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties
81. If you delete a page from PSPT application, which all tables are affected?
Ans.
People Tools
82. Which one of the following is NOT a valid PeopleSoft query type?
Ans.
Message agent queries
83. Which of the following ApiObject data type objects cannot be declared as Global?
Ans.
Java Object
84. In which PeopleCode event does ALL data validation take place?
Ans.
FieldEdit
85. Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
Ans.
Get keys, Create keys, and Find keys are created automatically.
The Create method is created along with the other Standard methods for the CI.
86. What are the various steps that describe the peoplecode logic while implementing a Component Interface?
Ans.
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
87. Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
Ans.
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.
88. 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?
Ans.
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.
89. Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with other corporate web servers and tools?
Ans.
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-
1) Licensing another web server
2) Training developers and administrators
3) Building and deploying other web applications will not be compromised by this decision.
90. Is WebSphere certified on PeopleTools 8.1x?
Ans.
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.
The IBM WebSphere 8.1x Early Adopter Program.
91. Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
Ans.
TIMESTAMP
92. What commands are valid in BS mode?
Ans.
ENCRYPT_PASSWORD
93. Which of the following are true with respect to validate sign in with database option enabled in psadmin?
Ans.
1. The application server first attempts to connect to database using the user id and password.
2. User must be defined on either the operating system or the database and within the PeopleSoft.
94. Which of the Following are true for force Shutdown in PeopleSoft Domain Shutdown menu?
Ans.
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 available?
1. Report ID
2. Date / time
3. Release
95. Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
Ans.
1. Query trees
2. Combination trees
96. In PeopleCode Debugger what are the valid values?
Ans.
1. Go
2. Step Over
3. View Variable Value
97. List the components, which form the part of Integration Broker?
Ans.
1. File Layout
2. CI
3. app. Messaging
98. In which system, Database Connectivity Drivers should be installed?
Ans.
1. Client Workstation in two-tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)
0 comments:
Post a Comment