Name:
Duration - 60 Minutes Marks - 100 (Please Select All Appropriate Answers)
1. Where are are definitions definitions used used to create create fields fields on a page in in the user user interface interface and columns in application data tables stored? a. b. c. d. 2. Where a. b. c. d.
PSFIELD PSRE SRECFI CFIELD PS_D S_DBFIE BFIEL LD PSDB PSDBF FIELD IELD are are the definitio definitions ns that make make up a PeopleS PeopleSoft oft Application Application stored stored? ? SYST SYSTEM EM CAT CATALOG ALOG PEOP PEOPLE LETO TOOL OLS S TABL TABLES ES APPL AP PLIC ICA ATION TION TAB TABLE LES S PEOPL PEOPLET ETOO OOLS LS CAT CATALOG ALOG
3. PeopleSoft PeopleSoft has has its own naming naming conventio convention n for system and and non-system non-system tables. 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? a. PS PS_R _RE ECORD CORDNA NAME ME b. SYSR SYSREC ECOR ORDN DNAM AME E c. PS PS$R $RE ECORD CORDNA NAME ME d. PSRE PSRECO CORD RDNA NAME ME e. SYS_ SYS_PS PSRE RECO CORD RDNA NAME ME 4. Where Where a. b. c. d. e.
is the the Applic Applicatio ation n Data Data Cached? Cached? Appli Applica catio tion n serv server er Web se serve rver Battch se Ba server Brow Browse serr Cac Cach he None
5. What is the the record field field property property that that should should be set to validate validate dates dates for for < 30 days and > 30 30 days? a. Setti Setting ng %Da %Date te as as cons constan tantt b. Required c. Specifying Specifying Default Default using using Record Record and and Field Field values values d. Reas Reason onab able le date date e. Valid alidat ate e date date
6. Prompt Tables Tables always always validate validate against against the underlyin underlying g Record? Record? a. TRUE b. FALSE 7. What are are the requiremen requirements ts of an an effectiv effective e dated table? a. De Defi fin ne EFF EFFD DT b. De Defi fine ne EFF_S EFF_ST TATUS TUS c. Define Define EFFD EFFDT T as key key, in ascen ascendin ding g order order d. Define Define EFFD EFFDT T, EFF_ST EFF_STA ATUS e. Define EFFDT as key, key, in descendin descending g order order 8. EFFDT EFFDT a. b. c. d. e.
cannot cannot occur occur at what what occurs occurs levels levels? ? 0 1 2 3 4
9. What What type type of a field field can can have have Auto Auto Update Update? ? a. CHAR b. LONG CH CHAR c. DATE d. IMAGE e. NUMBER 10. PeopleSoft tracks object changes using a system table. Which PeopleT PeopleTools System table is used to track object changes? a. SYSR YSRELEAS ASE E b. SYSO YSOBJE BJECTS c. PSRELEASE d. PSOB SOBJECTS e. PSV SVE ERSIO SIONS 11. Which of the following are true for Default Century option: Specify the last
two digits of a year, which is typically what users enter in a Date field. If you enter 50 as your Default Century option a. When a number number 0 throug through h 50 is entere entered d as the the year in in a Date field, the century defaults to 2000 b. If a number number from 51 51 through through 99 is entered entered in a Date Date field, field, the century century defaults to 2000. c. If a number from 51 through 99 is entered in a Date field, the century defaults to 1900. 1900.
d. When a number number 0 through through 50 is is entered entered as the year year in a Date field, field, the century defaults to 1900. 12. Selecting Search Edit from from Record Field Properties? a. Validates Validates a field field for Data to be entered entered on save of search search dialog. b. Allows Allows to edit edit the the search search key key. c. Searche Searches s Edit Edit field fields s for for some some valu values. es. d. Option available available only for Alternate Alternate Search Search Keys 13. When a. b. c. d. e.
can a value be added in the underlying table? table? Promp Promptt Tab Table le wit with h Edit Edit Translat ranslate e Tabl Table e Edit Edit Yes/No /No Ed Edit Prompt Prompt Table Table with with No Edit Edit All All of of the the abov above e
14. Which of the following record definitions is NOT stored on the database and is therefore NOT required to be built? a. View b. SQL Tab Table le c. Deri Derive ved/ d/Wo Work rk Reco Record rd d. Sub Rec Record ord e. Query Vie View
15. Audits a. b. c. d. e.
can be implemented at the following levels FIELD PAGE COMPONENT RECORD FIEL FIELD D & RECO RECORD RD
16. What Fields are typically marked as required? a. EFFDT b. EFF_ EFF_ST STA ATUS TUS c. CHECK BO BOX d. RAD RADIO BU BUT TTON e. All All of of the the abov above e 17. How many indexes are built if a record has 3 Search keys and 2 Alternate Search Keys? a. 3 b. 2 c. 0 d. 5 e. 1 18. What type of Index is created when more than a Search Key Field exists in a Record? a. NonNon-Clu Cluste stere red d Inde Index x b. Unique c. Clu Cluste stered red Inde Index x d. b,c ?? e. b,a ?? 19. All related fields are display only? a. TRUE b. FALSE 20. All updateable fields at a scroll must be from the same record definition? definition? a. TRUE b. FALSE 21. What is the purpose of specifying search keys and alternate search key fields? a. For For Maint Maintain aining ing Data Integr Integrity ity b. Building Building the Basic Basic and Advanc Advanced ed Filters Filters for the the Search Search Page Page c. Buildi Building ng the the List List Box Box in the the searc search h page page d. All All of of the the abov above e e. None 22. What are the Component Parameters specified while creating the Content Reference? a. Menu b. Comp ompon onen entt c. Market d. Node Na Name e. All All of of the the Abov Above e
23. If a record in scroll are has no EFFDT field and a prompt in the scroll area has EFFDT then the rows are retrieved based on a. All rows rows are are retri retriev eved ed b. Rows categoriz categorized ed against against the system date. c. Rows categorized categorized by the the EFFDT EFFDT of the the table table writing writing to. to. retrievable . d. Current, active rows are retrievable. e. None 24. Parent Record property in the Record Record Properties is used for? a. To create create Parent/ Parent/Chil Child d Relatio Relationsh nship ip b. Ensures Ensures online online cross-refer cross-reference ence utilities utilities will will correctly correctly identify identify the relationships among records. c. Enfo Enforc rce e Dat Data a Int Integ egri rity ty d. Efficie Efficient nt buffer buffer perfor performan mance ce e. None 25. If a Page references a field from a record, the component processor will select every column and all rows of data subordinate to the search key for storage in the application server buffer except a. Level Level 0 with non search search keys, keys, Related Related Fields, Fields, Derieve Derieved/W d/Work ork Field b. Level Level 1 with search search keys, keys, Related Related Fields, Fields, Derieved/W Derieved/Work ork Field Field c. Level Level 2 with search search keys, keys, Related Related Fields, Fields, Derieved/W Derieved/Work ork Field Field d. Level Level 3 with search search keys, keys, Related Related Fields, Fields, Derieved/W Derieved/Work ork Field Field e. Level 0 with with search search keys, keys, Related Related Fields, Fields, Derieved/W Derieved/Work ork Field Field 26. What is the default port set for PeopleCode Debugger in Configuration Configuration Manager? a. 9500 b. 9000 c. 7000 d. 9010 e. 6100 27. Views a. b. c. d. e.
do not need? need? Defaults Au d i t s Desc De scen endi ding ng Key Key Alter Alternat nate e Searc Search h Key Keys s a, b
28. Secondary page inherits the buffer level of the control from where it was launched? a. TRUE b. FALSE 29. How do you set up table-sharing in PeopleTools PeopleTools applications? a. Add the the field, SETID, SETID, as a key key field to to each table table you you want to to share, and then define the set control field. b. Add the field, field, BUSINESS_ BUSINESS_UNIT UNIT,, as a key field field to each each table you you want to to share, and then define the set control field. c. Add the field, SETID, SETID, as a key key field field to each each table you want want to share share
d.
Add the fields, BUSINESS_UNIT and SETID, as key fields to each table you want to share. share . e. Add the field, field, BUSINESS_ BUSINESS_UNIT UNIT,, as a key field field to each each table you you want to to share.
30. You are asked to perform some security-related tasks. You determine the quickest method to do this is using the Data Mover utility and the GRANT_USER and ENCRYPT_PASSWORD commands. However, However, to perform these commands you must login to Data Mover in bootstrap mode. Referring to the above, how do you launch Data Mover in bootstrap mode? a. Login Login using using the the SYSAD SYSADM M user user ID and and passwor password. d. b. Login using the databas database e access access ID and password. password. c. Login Login using using your your regula regularr user ID witho without ut a passwo password. rd. d. Login using using your your regular regular user user ID and password, password, and execut execute e SET BOOTSTRAP. e. Login Login using using your your regula regularr user ID and and passwor password. d. 31. What are the different types of Configuration Templates Templates available while creating a Application Server Domain thru PSADMIN Utility? a. LARG LARGE, E, MEDI MEDIUM UM , SMA SMALL LL b. DEVELO DEVELOPER PER,, LARGE, LARGE, MEDIUM MEDIUM,, SMALL SMALL c. LARGE, LARGE, DEF DEFAUL AULT T, MEDIUM MEDIUM,, SMALL SMALL d. LARGE, LARGE, DEFAUL DEFAULT T, SMALL SMALL e. DEVEL VELOPER 32. What are the high-level keys available on many control tables? a. SETID b. BU BUSI SINE NESS SSUN UNIT IT c. RECORDID d. INST INSTAN ANCE CEID ID e. TRAN TRANSA SACT CTIO IONI NID D
33. If a component is set to Interactive Processing and One of the Page is set to deferred Processing then the Page performs a. De Defe ferre rred d Proces Processin sing g b. Intera Interacti ctive ve Proces Processin sing g c. Expert En Entry d. Error e. None 34. PeopleCode variables (global, component, local, and parameter), parameter), method, and property names can now be up to _______ characters long a. 1000 b. 2000 c . 500 d. 1500 35. PeopleCode attached with Push Button can be associated with which of the following events? a. Field ield Edit b. Fie Field Chan Change ge c. Save Edit d. Field Field Edit, Edit, Field Field Chan Change ge e. Field Field Edit, Edit, Fiel Field d Change Change,, Save Save Edit Edit 36. Activate Event is Valid Valid for following a. Standard b. Secon condary c. Standar Standard, d, Second Secondary ary &Sub &Sub Page Page d. Stan Standa dard rd & Seco Second ndar ary y
37. A PeopleCode program is automatically saved to a file while you’re you’re working on it. This checkpoint will NOT occur at which the following times: a. b. c. d.
Ever Every y 10 10 key keystr strok okes es.. Ever Every y 5 Min Minut utes es On a save save command, command, just prior prior to the save save being being execute executed d When anothe anotherr PeopleCode PeopleCode program program is selected selected to be edited edited
38. Interlink data type can be declared as a. b. c. d.
Global Local Glob Global al & Com Compo pone nent nt Comp Compon onen entt & Loc Local al
(SAME IS TRUE FOR JavaObject, TransformData,XmlNode) TransformData,XmlNode)
39. The following APIObject data type objects can’t be declared as Global:
a. b. c. d. e. f.
Session PSMes PSMessag sages es col colle lect ctio ion n PSMessage Que Query clas classe ses s All Tree Tree classes classes (trees, (trees, tree tree structur structures, es, nodes, nodes, levels, levels, and so on.) on.) JavaObject
All other ApiObject data type objects
must be
declared as Global
40. DoSave( ) can be called from one of the following events events a. b. c. d.
FieldEdit, FieldEdit, FieldChang FieldChange, e, MenuItemSe MenuItemSelecte lected d MenuItemSele MenuItemSelected, cted, SavePrechan SavePrechange ge & SavePostChan SavePostChange ge SaveEd SaveEdit it , SavePo SavePostC stChan hange, ge, Work Workflo flow w SaveEdit, SaveEdit, SavePreC SavePreChange, hange, SavePostCh SavePostChange, ange, and and Workfl Workflow ow
41. Display Characteristics are associated with which PeopleCode PeopleCode event a. b. c. d. e.
RowInit Fie Field Chan Change ge Field Ed Edit A&B A&C
42. What is the maximum length for any PeopleCode PeopleCode function name? a. 8 b. 10 c. 18 d . 32 (the correct option as per PeopleBook is 30) 43. In an Application Engine Program, Maximum number of Actions in a Step? a. b. c. d.
8 6 7 (SQL (SQL & Call Sect Section ion can’ can’tt be toget together her) ) 9
44. In an Application Engine Program Call Section – Action it is possible to leave the Program ID with blank Value in certain cases? a. True b. False 45. PeopleSoft allows multiple long fields per State Record? a. True b. False 46. Let us take a Temp Table Table TMP_TAO.
In People Tools Tools options the following instance settings are done Temp Table Table Instances Instance s (Total) (Total) : 5 Temp Table Instances (Online): 4 In AE1 App Engine Program the instance count to TMP_TAO is 3 In AE2 App Engine Program Program the instance count to TMP_TAO is 5. How many instances are created to TMP_TAO ? a. 8 b. 17 Temporary Table Table in App Engine (5+3+5) refer to Temporary c. 13 (5+3+5) d . 12 47. The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory? a. True b. False 48. PeopleSoft’s hub to handle complex system-to-system system-to-system interactions. a. Appli Applica catio tion n Serv Server er b. Web Se Serve rver c. Inte Integr grat atio ion n Brok Broker er d. Inte Integr grat atio ion n Engi Engine ne 49. From the following statements which one is NOT true about Pub Broker: a. Pub Broker Broker Dispatche Dispatcherr polls message message queue at 15-second 15-second interv intervals als (by default) b. Pub Broker Broker Handler Handler gets gets NEW publicat publications ions from from the the Dispatcher Dispatcher c. Pub Broker Broker is invoked invoked after after Pub Pub Contract Contractor or Handler Handler evaluate evaluates s routing rules and writes contract(s) d. Pub Br Broker e. Interacts Interacts with Pub Pub Message Message Queue, Queue, Routing Routing Rules, Rules, Pub Contra Contract ct Queue Queue 50. Non-Repudiation property can be set a. PIA-.Peopl PIA-.PeopleTools eTools->Int ->Integrat egration ion Broker->N Broker->Node ode Definition Definition b. Application Application Designer->Me Designer->Message ssage Channel->Pro Channel->Propertie perties s c. Applicatio Application n Designer-> Designer->Messag Message e ->Propert ->Properties ies d. PIA-.People PIA-.PeopleT Tools->Integr ools->Integration ation Broker->Monito Broker->Monitor->Mess r->Message age Details 51. Which is a record that PeopleT PeopleTools adds to every level of the Message Structure during processing a. PSCAMA b. PSCO SCODESET c. PSNO SNODEPROP d. PS PSGA GATE TEW WAY 52. The main attributes of a Component Component Interface (CI) are a. b. c. d.
Component Component Search Search Keys, Keys, People Peoplecode code Function Functions s and Fields Fields & Scrolls Scrolls Keys, Keys, Propertie Properties s & Collections Collections and Method Methods s only only Name, Name, Proper Propertie ties s & Collecti Collections ons and and Method Methods s only Keys, Prope Properties rties & Collections Collections,, Methods Methods and and Name
e. a an and b only 53. Which of the following are TRUE when a Component Interface (CI) is created on component that has “Add” action enabled a. b. c. d. e.
Get keys, keys, Create Create keys and and Find keys keys gets gets created created automatic automatically ally Get keys keys and and Find Find keys keys are are only only create created d Only Only the stan standard dard meth methods ods are are create created d for the the CI The Create Create method method alone alone gets gets created created for the the CI CI The Create Create method method is created created along along with with the other other Standard Standard methods for the CI
54. With reference to the Component Interface Tester Tester which of the following is NOT TRUE a. GetExistin GetExisting g option option is equivalen equivalentt to opening opening a record record in Update/Display Mode only b. Create New New option option is equiv equivalent alent to to creating creating a new new record in Add mode mode online c. GetExisting GetExisting option option is is equivale equivalent nt to openin opening g a record record in Update/Di Update/Display splay or Correction mode online d. Find option is equiva equivalent lent to searchin searching g a record e. When a record record is is saved saved a return return value value of 1 indicates indicates success success 55. In Configuration Manager, Manager, the Connect ID edit box must contain a value or the user can't sign on to the system in a two-tier environment a. True b. False 56. The DB User mentioned in Connect ID should have permission to which Three Three PeopleSoft Tables? a. b. c. d. e.
PSAC PSACCE CESP SPRF RFL L PSXL PS XLA ATITE TITEM M PSSTATUS PSAUDIT PSOPR OPRDEFN
57. What is the configuration file that contains the entire collection configuration configuration values for a given application server domain? a. b. c. d.
PSAP PSAPPS PSRV RV.C .CFG FG PSP SPR RCS.CFG PSNT PS NTSR SRV V.CFG .CFG PSAP PS APPD PDOM OM.C .CFG FG
58. PSWORKLIST record is used for workflow routing . It should contains minimum of a. 6 keys keys in in Asce Ascendi nding ng order orders s b. 6 keys keys in Descen Descending ding orders orders c. 5 key keys s in Ascen Ascendi ding ng orde orders rs d. 6 keys in descending descending can be Alternate Alternate search key
59. TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent TriggerBusinessEvent has the syntax a. TriggerBusines riggerBusinessEven sEvent(BusPro t(BusProcess, cess, BusActivity BusActivity,, BusStep ,BusEvent,); ,BusEvent,); b. TriggerBus TriggerBusiness inessEvent Event(BusP (BusProces rocess,Bus s,BusActi Activity, vity,BusEv BusEvent); ent); c. TriggerBusines riggerBusinessEven sEvent(BusPro t(BusProcess,B cess,BusActivi usActivity ty,BusEv ,BusEvent,Bus ent,BusStep); Step); d. TriggerBusines riggerBusinessEven sEvent(BusPro t(BusProcess,B cess,BusActivi usActivity ty,, BusStep ); 60. What the following command will do? psadmin -p start -d hrdmo a. b. c. d.
Starts Starts the Applica Applicatio tion n Serv Server er Starts Starts an AE Proc Proces ess s Starts Starts a Web Web Ser Serve verr Proc Proces ess s Starts Starts a Proce Process ss Sch Schedu eduler ler
Psadmin –p IS FOR PROCESS SCHEDULER AND Psadmin –c IS FOR APPS SERVER
