|
1. Which one of the following is true about PIA? 2. What BEA product is used for DB transaction in PS Tuxedo 3. How do you login into BS mode? DB Access Id 4. What commands are valid in BS mode? ENCRYPT_PASSWORD 5. What event gets fired after DB Update? SavePostChange 6. PeopleCode events pertaining to Record Field: FieldEdit, SaveEdit and RowDelete 7. Changing Prompt Table with NO Edit to Prompt Table with Edit? Only selection of existing data is possible 8. Question relating to purpose of State Record? 9. (Some scenario) Find which is not part of AE Program, Options would be 1. Action,Section,Step,Event 10. Which RDBMS uses Tablespace? Oracle DB2 Other Options: SQL Server, Informix, Sybase 11. (Some scenario) Question relating DBA Purging Temporary Table? – Update Statistics 12. Optimizer values passed in Oracle 13. Database Connectivity Drivers should be installed in the following System (choose four) Client Workstation in two tier mode (Yes) App Server (Yes) Batch Server (Yes) File Server Data Mover (Yes) Web Server 14. Regarding UPGCONVERT Project used? 15. Customization done in Dev DB, Which tool i will use to move it to Prod DB? Use App Designer -> Copy DB 16. Simple Select Statement and Find the Results 17. PS Query definition is stored on which server? – DB Server 18. Regarding One to Many Relationship 19. What are the People Tools available for Integration Broker? Appl. Messaging Component Interface File Layout Message Agent (Not an Integration Broker tool) 20. In which platform does Crystal and Psnvision works? Windows (Correct) Unix 21. Update and Fixes: R-* files refers to 22. What are the Search Keys you use to find Patches and Fixes Release Updated date time (Posted date is there) Platform Report Id 23. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then Some options: Customize PS application (Yes) Buy third party software (Yes) Change policies and procedures to meet the requirement Call PS Development Center for Enhancement (Yes) 24. A Customer wants to use a new Image in HRMS, where it is stored? - doubt File Server Web Server Batch Server DB Server 25. Where will you configure for failover of Application Server (Scenario) - doubt Configuration Manager PSAPPSRV.cfg Configuration.properties 26. What are Menu types available? Component PeopleCode Separator 27. WorkItem is available in WorkList Record 28. What is added as new option in Build apart from Create Tables, Indexes, Views? Create Trigger (Just Check) 29. What views available in Application Designer project workspace? Development and Upgrade 30. I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario) PeopleTools Tables 31. SYSAUDIT finds 32. What hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one Study all hyperlinks in the first page of people books. 33. What Record Changes does not affect Database? Change in List box in Record Field properties (correct) Deleting a field Removing the search key and alternate search key 34. Question on Connect Id, Shared Key used to connect to the DB 35. In PeopleCode Debugger what are the valid values (Just Check) Go Commit Step Over View Variable Value 36. Which Web Services is only used as a Proxy Server (Just Check) MS IIS Apache Web Logic Web Sphere 37. Which of the following are part of an AE program ? (choose 3) Section Procedure Step Function Action 38. Where are workflow work items found ? Email Worklist Forms File server 39. Where do you need to install connectivity software? (choose 3) file server web server batch server App server two tier client 40. Which process is used for running AE programs which are to be run at a frequency of less than a day ? PSAppsrv PSAESRV PSDAEMON PSQCKSRV 41. In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBL which one is the component definition? EMPLOYEE PSFT_HR c PROCESS_SCHEDULER PRCSTYPEDEFN.GBL 42. Which of the following are Record field events ? (choose 3) FieldChange SearchSave ScrollEdit RowSave SavePreChange 43. Which of the following fires after the database is updated? SavePreChange SavePostChange SaveEdit RowDelete 44. If you want to log into DataMover in Bootstrap mode, you would login as.. Database superuser Peoplesoft superuser Data Mover Superuser Security Administrator 45. Which of the following commands can be run in Bootstrap mode? EXPORT RENAME_VIEW ENCRYPT_PASSWORD 46. 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 ? Drop table Re-create table Update statistics on the table Refresh the table with yesterday’s data 47. You want to update your password and enter a hint for forgotten password. What would you access? Access Profile Permission Lists User Profile Primary Permission List 48. 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 ? Tools Released Required Application Resolved 49. After logging into customer connection, you wish to search for fixes/patches. What are the search criterias available ? (choose 3) Report ID Date / time Platform Release Developer ID 50. 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 ? Partner Alliance Alliance Partner PeopleSoft Knowledge base Partner knowledge base (there was one more choice) 59. 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? PS_RECORDNAME SYSRECORDNAME PS$RECORDNAME PSRECORDNAME SYS_PSRECORDNAME 60. Which one of the following tree types is NOT supported in the PeopleSoft tree manager? -
doubt Node-Oriented trees Query trees Detail trees Summary trees Combination trees 61. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes? SYSRELEASE SYSOBJECTS PSRELEASE PSOBJECTS PSVERSIONS 62. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:\PSHrms\Sqr\ What do the above SQR flags signify to the SQR Report Writer upon execution? Directs log messages to the specified file Specifies the output path Specifies the path to SQC include files Specifies the path to the ALLMAXES.MAX file Sets full path to and name of the SQR initialization file 63. Which of the above record definitions is NOT stored on the database and is therefore NOT required to be built? View SQL Table Derived/Work Record Sub Record Query View 64. The Application Reviewer is not working correctly, and you are in a hurry to find the problem with a piece of PeopleCode that's been causing problems. You need a quick method to find all the fields being referenced by the PeopleCode program without having to read through the entire program. Referring to the above, how do you determine ALL the fields referenced by the PeopleCode program without having to read every line of code? Run the delivered PeopleSoft report, XRFMNPC. Run the delivered PeopleSoft report, XRFPNPC. Run the delivered PeopleSoft report, XRFPCFL. Run the delivered PeopleSoft report, XRFPCMN. Run the delivered PeopleSoft report, XRFFLPC. 65. How do you set up table-sharing in PeopleTools applications? Add the field, SETID, as a key field to each table you want to share, and then define the set control field. Add the field, BUSINESS_UNIT, as a key field to each table you want to share, and then define the set control field. Add the field, SETID, as a key field to each table you want to share. Add the fields, BUSINESS_UNIT and SETID, as key fields to each table you want to share. Add the field, BUSINESS_UNIT, as a key field to each table you want to share. 66. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number? 10,000 19,999 30,000 40,000 50,000 67. In which one of the following views would you see the fields, criteria, and other details associated with the current query? Component view Object view Query view Designer view Record view 68. Which one of the following Data Types is NOT supported by the PeopleCode programming environment? OBJECT NUMBER TIMESTAMP DATE STRING 69. What is the default Crystal Report that PeopleSoft Query tool creates? DEFAULT.RPT ACTQRY.RPT CRYQRY.RPT QRYCRY.RPT QUERY.RPT 70. Which one of the following steps is NOT part of performing an upgrade? Apply all outstanding patches, prior to upgrade. Perform a comparison of objects between the source and target databases. Populate a project to be used for the upgrade. Stamp the target database. Copy the project to the database being upgraded. 71. Which command is valid in both bootstrap and regular mode when operating the data mover? REPLACE RENAME EXPORT REPLACE_VIEW GRANT_USER Source: Scribed
|
Training Manuals 
