Read the most frequently asked 100 top Peoplesoft multiple choice questions and answers PDF for freshers and experienced. Peoplesoft objective questions and answers pdf download free..
Peoplesoft Multiple Choice Questions and Answers PDF Experienced Freshers
1. What are Menu types available?
1. Standard
2. Pop-Up
2. Where do you need to install connectivity software?
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?
To store application data for life of the application Engine process
4. What is the most important Record in PS HRMS?
JOB record
5. What is dynamic view?
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?
In Sql view manually write the SQL statement, Query view use the PS QUERY tool.
7. What is section?
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?
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?
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?
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? Explain with real time scenario.
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?
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?
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.
Component Buffer:
Component Buffer contains all the Data of active componentData 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?
Development and Upgrade Views
16. What are the statuses available in PeopleSoft Domain Status Menu?
1) Server Status
2) Client Status
3) Queue Status
17. What are the differences between RowClass and RowSet in PeopleSoft?
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?
ACTQRY.RPT
19. What Record Changes does not affect Database?
Derived work record
Subrecord
Dynamic view
These record changes do not affect the DB
20. What views available in Application Designer project workspace?
1. Development View
2. Upgrade View
21. With reference to the Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode only
22. What are the main attributes of a Component Interface (CI)?
Keys, Properties & Collections, Methods, and Name
23. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
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?
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?
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?
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?
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?
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?
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?
WorkList Record
31. Where is workflow work items found?
Worklist
32. What BEA product is used for DB transaction in PS?
Tuxedo
33. What is the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
34. What event is fired after DB Update?
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?
PSDAEMON
36. Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
37. How do you login into BS mode?
DB Access Id
38. Activate Event is Valid for following?
Standard & Secondary
39. What are Menu types available?
1. Component
2. PeopleCode
3. Separator
40. What is the output when Query is split?
Component and Query view
Select appropriate Question to view its more answers in this category of Peoplesoft . 41. What are destructive statements in SQL?
b) Recreate a Tabled) Recreate a View
42. What does ER Diagrams represent?
a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields
43. On which servers Tuning can be done.
a) Database Server
b) App Server
c) Batch Server
d) Web Server
44. What are the uses of process profile?
(Scenario based on process profile / process group) Server o/p path override, process he can access.
45. Where is Unicode used?
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?
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?
Report id date release
48. What are the People Tools available for Integration Broker?
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_______.
Orphaned Objects
50. You want to update your password and enter a hint for forgotten password. What would you access?
Profile
51. Which of the following commands can be run in Bootstrap mode?
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?
SavePostChange
53. What are the Record field events?
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?
List Box item
55. Which RDBMS uses Tablespace?
Oracle, db2, Informix
56. How do you set up table sharing in PeopleTools applications?
SETID
57. How will you get a single output by combining two or more queries?
Using UNION
58. What is the purpose of State Record?
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?
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?
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?
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?
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?
AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool.
64. What is record, row peoplecode?
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?
Scrollselect (1, targetname, recordfiledname)
66. What is the difference between sql statements and metasql statements?
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)
2-tier, 4-tier, process scheduler
68. How do you delete a file using sqr?
delete($filename)
69. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
True
70. Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the syntax¬¬¬¬__________.
Trigger Business Event (BusProcess, BusActivity, BusEvent);
71. The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233. What does the Source= 233 parameter in the above LOG file entry identify?
The statement being executed is line 233 of the PeopleCode program.
72. What the following command will do? (Psadmin -p start -d hrdmo)
Starts a Process Scheduler
73. Which of the Task cannot be done through PSADMIN?
Starting Web Server
74. What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
75. What category of commands can be executed in data mover?
Sql, data mover commands
76. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqr What do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
77. The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
Spawning
78. Where do you create the process security groups?
Security Administrator 20
79. What is the event that fires after all database updates?
Save post change
80. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view 9
81. From the following statements, which one is NOT true about Pub Broker?
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
82. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
83. 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.
PSRECORDNAME
84. Which is a record that PeopleTools adds to every level of the Message Structure during processing?
PSCAMA
85. What is the configuration file that contains the entire collection configuration values for a given application server domain?
PSAPPSRV.CFG
86. Which command shuts down an application server domain using a “forced” shutdown method?
psadmin -c shutdown! -d ps800dmo
87. Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
PSACCESPRFLPSSTATUS PSOPRDEFN
88. Assume that you just finished customization work that involved the creation of many new objects. You can move these objects from your development database (source) to a testing database (target) to conduct more elaborate testing. Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?
Projects provide the ability to migrate all objects at once or each object type individually.
89. Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
90. WhichTrace 255 command line options produces the trace file with the name?
PID.AET
91. Where can you see the status of the job report and details in secured way?
Process monitor
92. How can youset Non-Repudiation property?
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties
93. If you delete a page from PSPT application, which all tables are affected?
People Tools
94. If you change the long name of translate field what object is to be altered?
Page def
95. When do configuration changes made using the configuration Manager take effect?
Once you exit PeopleSoft and log back in.
96. Which one of the following is NOT a valid PeopleSoft query type?
Message agent queries
97. Interlink data type can be declared as?
Local
98. Which is the PeopleSoft’s hub to handle complex system-to-system interactions?
Integration Broker
99. Suppose the CEO wants a list of the departments, whose MINIMUM salary is greater than $100,000? Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
Having CRITERIA 18
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected, Save Prechange & SavePostChange
100. In which PeopleCode event does ALL data validation take place?
FieldEdit
Peoplesoft Multiple Choice Questions and Answers PDF Experienced Freshers
1. Standard
2. Pop-Up
2. Where do you need to install connectivity software?
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?
To store application data for life of the application Engine process
4. What is the most important Record in PS HRMS?
JOB record
5. What is dynamic view?
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?
In Sql view manually write the SQL statement, Query view use the PS QUERY tool.
7. What is section?
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?
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?
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?
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? Explain with real time scenario.
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?
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?
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.
Component Buffer:
Component Buffer contains all the Data of active componentData 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?
Development and Upgrade Views
16. What are the statuses available in PeopleSoft Domain Status Menu?
1) Server Status
2) Client Status
3) Queue Status
17. What are the differences between RowClass and RowSet in PeopleSoft?
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?
ACTQRY.RPT
19. What Record Changes does not affect Database?
Derived work record
Subrecord
Dynamic view
These record changes do not affect the DB
20. What views available in Application Designer project workspace?
1. Development View
2. Upgrade View
21. With reference to the Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode only
22. What are the main attributes of a Component Interface (CI)?
Keys, Properties & Collections, Methods, and Name
23. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
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?
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?
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?
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?
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?
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?
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?
WorkList Record
31. Where is workflow work items found?
Worklist
32. What BEA product is used for DB transaction in PS?
Tuxedo
33. What is the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
34. What event is fired after DB Update?
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?
PSDAEMON
36. Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
37. How do you login into BS mode?
DB Access Id
38. Activate Event is Valid for following?
Standard & Secondary
39. What are Menu types available?
1. Component
2. PeopleCode
3. Separator
40. What is the output when Query is split?
Component and Query view
Select appropriate Question to view its more answers in this category of Peoplesoft . 41. What are destructive statements in SQL?
b) Recreate a Tabled) Recreate a View
42. What does ER Diagrams represent?
a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields
43. On which servers Tuning can be done.
a) Database Server
b) App Server
c) Batch Server
d) Web Server
44. What are the uses of process profile?
(Scenario based on process profile / process group) Server o/p path override, process he can access.
45. Where is Unicode used?
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?
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?
Report id date release
48. What are the People Tools available for Integration Broker?
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_______.
Orphaned Objects
50. You want to update your password and enter a hint for forgotten password. What would you access?
Profile
51. Which of the following commands can be run in Bootstrap mode?
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?
SavePostChange
53. What are the Record field events?
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?
List Box item
55. Which RDBMS uses Tablespace?
Oracle, db2, Informix
56. How do you set up table sharing in PeopleTools applications?
SETID
57. How will you get a single output by combining two or more queries?
Using UNION
58. What is the purpose of State Record?
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?
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?
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?
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?
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?
AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool.
64. What is record, row peoplecode?
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?
Scrollselect (1, targetname, recordfiledname)
66. What is the difference between sql statements and metasql statements?
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)
2-tier, 4-tier, process scheduler
68. How do you delete a file using sqr?
delete($filename)
69. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
True
70. Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the syntax¬¬¬¬__________.
Trigger Business Event (BusProcess, BusActivity, BusEvent);
71. The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233. What does the Source= 233 parameter in the above LOG file entry identify?
The statement being executed is line 233 of the PeopleCode program.
72. What the following command will do? (Psadmin -p start -d hrdmo)
Starts a Process Scheduler
73. Which of the Task cannot be done through PSADMIN?
Starting Web Server
74. What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
75. What category of commands can be executed in data mover?
Sql, data mover commands
76. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqr What do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
77. The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
Spawning
78. Where do you create the process security groups?
Security Administrator 20
79. What is the event that fires after all database updates?
Save post change
80. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view 9
81. From the following statements, which one is NOT true about Pub Broker?
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
82. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
83. 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.
PSRECORDNAME
84. Which is a record that PeopleTools adds to every level of the Message Structure during processing?
PSCAMA
85. What is the configuration file that contains the entire collection configuration values for a given application server domain?
PSAPPSRV.CFG
86. Which command shuts down an application server domain using a “forced” shutdown method?
psadmin -c shutdown! -d ps800dmo
87. Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
PSACCESPRFLPSSTATUS PSOPRDEFN
88. Assume that you just finished customization work that involved the creation of many new objects. You can move these objects from your development database (source) to a testing database (target) to conduct more elaborate testing. Referring to the above information, why would adding your objects to a Project streamline the migration to a new database?
Projects provide the ability to migrate all objects at once or each object type individually.
89. Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
Process Scheduler, Use, Process Definitions
90. WhichTrace 255 command line options produces the trace file with the name?
PID.AET
91. Where can you see the status of the job report and details in secured way?
Process monitor
92. How can youset Non-Repudiation property?
PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties
93. If you delete a page from PSPT application, which all tables are affected?
People Tools
94. If you change the long name of translate field what object is to be altered?
Page def
95. When do configuration changes made using the configuration Manager take effect?
Once you exit PeopleSoft and log back in.
96. Which one of the following is NOT a valid PeopleSoft query type?
Message agent queries
97. Interlink data type can be declared as?
Local
98. Which is the PeopleSoft’s hub to handle complex system-to-system interactions?
Integration Broker
99. Suppose the CEO wants a list of the departments, whose MINIMUM salary is greater than $100,000? Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to use PeopleSoft query. Referring to the above, what function would you use, in combination with the aggregate function "Minimum" to produce the result set required?
Having CRITERIA 18
DoSave( ) can be called from one of the following events?
FieldEdit, FieldChange, MenuItemSelected, Save Prechange & SavePostChange
100. In which PeopleCode event does ALL data validation take place?
FieldEdit
0 comments:
Post a Comment