People Tools Certification Questions

1.) Which of the following is a valid PeopleTools PeopleBook ? a. b. c. d. e.

PeopleSoft 8.4 Asset Management PeopleBook PeopleSoft Upgrade Assistant, App Designer, People Tools PeopleSoft 8.4 General Ledger People Book PeopleSoft Enterprise Integration PeopleSoft 8.4 eProcurement PeopleBook

2.)

Which of the following is applicable for LDP? (Choose 2) a. Centralised security b. Streamline various people soft applications. c. Controls access to Peoplesoft application data 3.) Database Connectivity Drivers should be installed in the following System (choose four) a. Client Workstation in two tier mode b. App Server c. Batch Server d. File Server e. Data Mover f. Web Server 4.) Which of the following Web Services is only used as a Proxy Server (select two) a. MS IIS b. Apache c. Web Logic d. Web Sphere 5.) Where will you configure for failover of Application Server? a. Configuration Manager b. PSAPPSRV.cfg c. Configuration.properties 6.) When a business requirement in Fit/Gap Analysis is not meet by PeopleSoft then (choose 3) a. Customize PS application b. Buy third party software c. Change policies and procedures to meet the requirement d. Call PeopleSoft Development to submit enhancement request 7.) In which platform does Crystal and NVision work? a. Windows b. Unix c. OS/2 d. AIX

8.) On a particular record, for a field, the prompt table has been changed from NO EDIT to EDIT option. What is the effect of this? a. user can type own values

b. user can type only prompt table values c. user can type only prompt table values and the default values gets populated from the database d. user can type own values and the default values gets populated from the database 9.) How will you get a single ouptut by combining two or more queries a. Union b. Outer join c. Inner Join d. Sub query 10.)Where would the parameter values for a Process be stored? a. Run control table b. State record c. Temporary Table 11.) Which non key record field accepts null value? a. Date b. Binary c. Number d. Char 12.)You have done some customizations to PeopleSoft objects and wish to move them to the test database. Which tool would you use? a. Upgrade assistant b. Application designer c. Data mover d. SQR program 13.)Which of the following are parts of an AE program? (choose 3) a. Section b. Procedure c. Step d. Function e. Action 14.)In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPED EFN.GBL Which one is the component definition? a. EMPLOYEE b. PSFT_HR c. c d. PROCESS_SCHEDULER e. PRCSTYPEDEFN.GBL

15.)In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPED EFN.GBL Which one is the portal? a. EMPLOYEE b. PSFT_HR c. c d. PROCESS_SCHEDULER e. PRCSTYPEDEFN.GBL 16.)If you want to log into DataMover in Bootstrap mode, you would login as a. Database superuser b. Peoplesoft superuser c. Data Mover Superuser d. Security Administrator 17.)What are the Menu types available? (choose three) a. Node b. Component c. Hyperlink d. PeopleCode e. Separator 18. which of the following is application for UPGConvert? (a).Conversion of Data, consists of cobol programs (b). Conversion of Data, consists of SQR programs (c). Data conversion, constists of AE programs 19. Which BEA product is used in peoplesoft?? Tuxedo 20.

Select BIRTHDATE, orig_hr_date from PeopleSoft PERSON table for ‘KA0001’ = emplid a. SELECT BIRTHDATE, ORIG_HR_DATE FROM PS_PERSON WHERE EMPLID = KA0001 b. SELECT BIRTHDATE, ORIG_HR_DATE FROM PERSON WHERE EMPLID = 'KA0001' c. SELECT BIRTHDATE, ORIG_HR_DATE FROM PS_PERSON WHERE EMPLID = 'KA0001' d. SELECT BIRTHDATE, ORIG_HR_DATE FROM TABLE PS_PERSON WHERE EMPLID = 'KA0001' e. SELECT BIRTHDATE AND ORIG_HR_DATE FROM PS_PERSON WHERE EMPLID = 'KA0001'

21.

Which is true about PS Internet Architecture? a. PIA can be accessed from MAcintosh System. b. PIA can be accessed from browser PC & MAC. c. PIA is accessed from the Cell phone only if the web browser is internet enabled

22.

Regarding one-to-many-relationship a. Every row of the first record can have zero, one or more rows in the second record. Every row of the second recond can have one & only one row in the first record. b. Every row of the second record can have zero, one or more rows in the first record. Every row of the first record can have one & only one row in the first record.

23. How to address the fit/gap analysis a. system architecture b. implementation plan c. To map data elements with the requirement……. d. Idently the business processes that needs to be built additionally 24. You are a PeopleSoft Partner and wish to get information on database performance benchmark. Where would you look for the info? a) Partner Alliance b) Alliance Partner c) PeopleSoft Knowledge Center d) Partner knowledge base 25. You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it? a) Demo b) Production db c) development db d) Application upgrade 26. DDAAUDIT finds for : (Not sure regarding the answer – please Check) a. Orphaned object definitions b. Consistency between Peopletools tables and Database tables c. Check whether all tables and related indexes exist in db 27. Select the components which form the part of Integration Broker a. Msg. Agent b File Layout c. CI d app. messaging

28. What are the output formats of the file layout? a).csv b).pdf c).xml d).dhtm e).fixed length f).htm 29.How do u comment Peoplecode statements? a)/* */ b)comments c)<* *> d)// 30.PSRECDEFN what table is this?? Peopletools table

31. how many keys are required for dynamic view?? a)0 b)1 c)2 d)3 e)4 32) Where do u write meta-SQL ? 1.Dynamic View 2.Derived Work/Record 3.SQL View 4.Query View 33. What are process scheduler servers in the list below a. PSPRCSSRV b. PSDSTSRV c. PSAPPSRV d. PSAPPOSRV 34. Winexec cannot be executed from Application server 35. Process profile – Run & output location for batch processes

36. Which of the following are PeopleSoft Objects? Not sure – Check a. Report Node b. Portal servlet c. Application Engine pgm d. Mobile Page e. File Layout Object 37. When logging on in 2 tier mode, a user is not able to access workforce admn page in Peoplesoft. What’s the reason - Check a. Its not possible to logon to PS in 2 tier mode in 8X version b. Configuration manager is not set properly c. Access is not granted for the page 38. Which field accepts NULL values – Date

39. PeopleSoft support Unicode on the following databases a. Oracle b. db2 OS c. db2/udb d. Sql server e. Informix 40. Scope of variable declaration a. Global b. Local c. Component 41. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then a. Customize PS application b. Buy third party software c. Change policies and procedures to meet the requirement – first preference d. Call PS Development Center for Enhancement

42. Which one of the following components is NOT part of the PeopleSoft three-tier architecture? Choice 1 Application server Choice 2 Batch server Choice 3 Web server Choice 4 Client workstation Choice 5 Database server 43. If a Manger want’s to approve all request for employees, which process he will be do? a. Rules b. Roles c. Routings d. Steps 44. Where the peoplecode is automatically generated in drag & drop situation? a. activity, component, file layout b. activity, AE, file layout c. Business interlinks, component interface, file layout e. AE, component, component interface 45. U downloaded some patches. What are all the things that might come with those patches? a.SQR b. People Code c. Upgrade template d.Message Catalog 46. Performance tuning could be done on which of the following: (choose four) App Server Batch Server File Server Database Server