1. Where can u write the peoplecode?
Ans: PeopleCode may be placed on Record Field,Page,Componet,Menu Item,Component Interface,Meassage and Message Channel and Application Engine.
2. What is the difference between SQl Object and SQl Exec?
Ans: SQL Object is a peopletool definition which can be created using app designer as well as using peoplecode command CREATESQL( ) , it is mainly used for reuseablility of the sql statements. so whenever this statement is required no need to hard code, just create an sql object of the same and use where ever it is required.
sqlexec is a peoplesoft delivered function used to retrive only one row and u can update multiple rows of data. It directly interacts with the database.
3. What is Component Processor?
Ans: The Component Processor is the People Tools runtime engine that controls processing of an application from the time that a user requests a component from an application menu until the database is updated and processing of the component is complete.
4. Tell me about component Buffer?
Ans: Component Buffer is the area in memory that stores data for the currently active component.
5. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
Ans: A component interface can be mapped to multiple PeopleSoft components.
A component interface can be mapped to one and only one Component. But multiple CI can be mapped to a single component.
6. How to do object security?How to connect report through process scheduler?
Ans: To connect a report first we have to know about run control page. So that we can add the required fields over there and then passing those oprid and runctlid through the stdapi.sqc we can run an an SQR by including this SQC. This can be runned through the process sheduler. If directly we can go to the process sheduler request and made a request for the SQR. This happens only when the report repositry and distubution has been set properly. After making request we can run the process scheduler
7. 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.
8. Where can you write the peoplecode?
Ans: you can write people code in 7 objects
1. record field level
2.component field level
3.page
4.menu
5.application engine
6.component interface
7.messages.
9. What are the differences between RowClass and RowSet in PeopleSoft?
Ans: Row class is the component object where it binds all the row's in all level will be in the buffer
row set is the set of rows that are in the level one from there for every rowset you can access the data in the level two
All three are parts of an AE program. Actions are grouped into Steps and Sections consists of one or more Steps.
10. How many Message nodes are possible for a database?
Ans: Unlimited.
11. How will you get a single ouptut by combining two or more queries…
Ans: UNION
12. How do you set up table-sharing in PeopleTools applications?
Ans: Add the field, SETID, as a key field to each table you want to share, and then define the set control field. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?
13. What is the default Crystal Report that PeopleSoft Query tool creates?
Ans: ACTQRY.RPT
14. What are the People Tools available for Integration Broker?
Ans: 1.Appl. Messaging 2. Component Interface3. File Layout
15. What are the Search Keys you use to find Patches and Fixes?
Ans: 1.Release 2. Updated date time3. Report Id
16. What are Menu types available?
Ans: 1.Component 2. PeopleCode3. Separator
17. What views available in Application Designer project workspace?
Ans: Development and Upgrade.
18. What Record Changes does not affect Database?
Ans: Change in List box in Record Field properties (correct)
19. Which one of the following is a trasaction control statement ..
Ans: Commit
20. What are the status available in PeopleSoft Domain Status Menu
Ans: Server, Client and Queue Status.
