Are you looking for a PeopleSoft Job? The Below List of PeopleSoft Technical Interview Questions Prepared for Experts
1. What are Menu types available?
2. Where do you need to install connectivity software?
3. What is the purpose of state records?
4. What is the most important Record in PS HRMS?
5. What is dynamic view?
6. What is the difference between SQL View and Query View?
7. What is section?
8. How do you create the Department security with navigations?
9. What is ERP and how it is related to SAP?
10. What is difference between Translate table and Prompt table?
11. What is Activity Type? What is Cost Center? What is GAP Analysis? Explain with real time scenario.
12. If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?
13. What are all the steps involved in Upgrade process?
14. Explain what are component buffer and data buffer.
15. What are the views available in App. Designer project workspace?
16. What are the statuses available in PeopleSoft Domain Status Menu?
17. What are the differences between RowClass and RowSet in PeopleSoft?
18. What is the default Crystal Report that PeopleSoft Query tool creates?
19. What Record Changes does not affect Database?
20. What views available in Application Designer project workspace?
21. With reference to the Component Interface Tester which of the following is NOT TRUE?
22. What are the main attributes of a Component Interface (CI)?
23. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
24. Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
25. Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
26. IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
27. Are disconnected mobile applications supported in PeopleTools 8.1x?
28. Is web server load balancing supported with PeopleTools 8.4?
29. What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
30. Where the WorkItem is available?
31. Where is workflow work items found?
32. What BEA product is used for DB transaction in PS?
33. What is the status available in PeopleSoft Domain Status Menu?
34. What event is fired after DB Update?
35. Which process is used for running AE programs, which are to be run at a frequency of less than a day?
36. Which RDBMS uses Tablespace?
37. How do you login into BS mode?
38. Activate Event is Valid for following?
39. What are Menu types available?
40. What is the output when Query is split?
41. What are destructive statements in SQL?
42. What does ER Diagrams represent?
43. On which servers Tuning can be done.
44. What are the uses of process profile?
45. Where is Unicode used?
46. Which of the above record definitions is NOT stored on the database and therefore not required to build?
47. What are the Search Keys you use to find Patches and Fixes?
48. What are the People Tools available for Integration Broker?
49. SYSAUDIT finds for_______.
50. You want to update your password and enter a hint for forgotten password. What would you access?
51. Which of the following commands can be run in Bootstrap mode?
52. Which of the following fires after the database is updated?
53. What are the Record field events?
54. What Record Changes does not affect Database?
55. Which RDBMS uses Tablespace?
56. How do you set up table sharing in PeopleTools applications?
57. How will you get a single output by combining two or more queries?
58. What is the purpose of State Record?
59. Tell me your experience with CI?
60. How do you decide between appeng/Ci and SQR while conversion?
61. What is the performance tuning of SQR?
62. What is the difference between SaveEdit and FieldEdit?
63. What are the differences between AE and SQR?
64. What is record, row peoplecode?
65. How do you retrieve a value from scroll.scroll select?
66. What is the difference between sql statements and metasql statements?
67. What are the different ways to run AE, SQR? (Command, process scheduler)
68. How do you delete a file using sqr?
69. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
70. Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the
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?
72. What the following command will do? (Psadmin -p start -d hrdmo)
73. Which of the Task cannot be done through PSADMIN?
74. What is the result of the search with the following criteria in PS Books?
75. What category of commands can be executed in data mover?
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?
77. The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
78. Where do you create the process security groups?
79. What is the event that fires after all database updates?
80. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
81. From the following statements, which one is NOT true about Pub Broker?
82. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
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.
84. Which is a record that PeopleTools adds to every level of the Message Structure during processing?
85. What is the configuration file that contains the entire collection configuration values for a given application server domain?
86. Which command shuts down an application server domain using a “forced” shutdown method?
87. Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
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?
89. Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
90. Which Trace 255 command line options produces the trace file with the name?
91. Where can you see the status of the job report and details in secured way?
92. How can youset Non-Repudiation property?
93. If you delete a page from PSPT application, which all tables are affected?
94. If you change the long name of translate field what object is to be altered?
95. When do configuration changes made using the configuration Manager take effect?
96. Which one of the following is NOT a valid PeopleSoft query type?
97. Interlink data type can be declared as?
98. Which is the PeopleSoft’s hub to handle complex system-to-system interactions?
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?
100. In which PeopleCode event does ALL data validation take place?
1. What are Menu types available?
2. Where do you need to install connectivity software?
3. What is the purpose of state records?
4. What is the most important Record in PS HRMS?
5. What is dynamic view?
6. What is the difference between SQL View and Query View?
7. What is section?
8. How do you create the Department security with navigations?
9. What is ERP and how it is related to SAP?
10. What is difference between Translate table and Prompt table?
11. What is Activity Type? What is Cost Center? What is GAP Analysis? Explain with real time scenario.
12. If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?
13. What are all the steps involved in Upgrade process?
14. Explain what are component buffer and data buffer.
15. What are the views available in App. Designer project workspace?
16. What are the statuses available in PeopleSoft Domain Status Menu?
17. What are the differences between RowClass and RowSet in PeopleSoft?
18. What is the default Crystal Report that PeopleSoft Query tool creates?
19. What Record Changes does not affect Database?
20. What views available in Application Designer project workspace?
21. With reference to the Component Interface Tester which of the following is NOT TRUE?
22. What are the main attributes of a Component Interface (CI)?
23. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
24. Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
25. Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
26. IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
27. Are disconnected mobile applications supported in PeopleTools 8.1x?
28. Is web server load balancing supported with PeopleTools 8.4?
29. What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
30. Where the WorkItem is available?
31. Where is workflow work items found?
32. What BEA product is used for DB transaction in PS?
33. What is the status available in PeopleSoft Domain Status Menu?
34. What event is fired after DB Update?
35. Which process is used for running AE programs, which are to be run at a frequency of less than a day?
36. Which RDBMS uses Tablespace?
37. How do you login into BS mode?
38. Activate Event is Valid for following?
39. What are Menu types available?
40. What is the output when Query is split?
41. What are destructive statements in SQL?
42. What does ER Diagrams represent?
43. On which servers Tuning can be done.
44. What are the uses of process profile?
45. Where is Unicode used?
46. Which of the above record definitions is NOT stored on the database and therefore not required to build?
47. What are the Search Keys you use to find Patches and Fixes?
48. What are the People Tools available for Integration Broker?
49. SYSAUDIT finds for_______.
50. You want to update your password and enter a hint for forgotten password. What would you access?
51. Which of the following commands can be run in Bootstrap mode?
52. Which of the following fires after the database is updated?
53. What are the Record field events?
54. What Record Changes does not affect Database?
55. Which RDBMS uses Tablespace?
56. How do you set up table sharing in PeopleTools applications?
57. How will you get a single output by combining two or more queries?
58. What is the purpose of State Record?
59. Tell me your experience with CI?
60. How do you decide between appeng/Ci and SQR while conversion?
61. What is the performance tuning of SQR?
62. What is the difference between SaveEdit and FieldEdit?
63. What are the differences between AE and SQR?
64. What is record, row peoplecode?
65. How do you retrieve a value from scroll.scroll select?
66. What is the difference between sql statements and metasql statements?
67. What are the different ways to run AE, SQR? (Command, process scheduler)
68. How do you delete a file using sqr?
69. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions. True or False
70. Trigger Business Event is used for triggering the workflow and it is written on workflow event. Trigger Business Event has the
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?
72. What the following command will do? (Psadmin -p start -d hrdmo)
73. Which of the Task cannot be done through PSADMIN?
74. What is the result of the search with the following criteria in PS Books?
75. What category of commands can be executed in data mover?
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?
77. The application server dynamically scales server processes according to the volume of transaction requests, which is known as?
78. Where do you create the process security groups?
79. What is the event that fires after all database updates?
80. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
81. From the following statements, which one is NOT true about Pub Broker?
82. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
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.
84. Which is a record that PeopleTools adds to every level of the Message Structure during processing?
85. What is the configuration file that contains the entire collection configuration values for a given application server domain?
86. Which command shuts down an application server domain using a “forced” shutdown method?
87. Which Three PeopleSoft Tables the DB User mentioned in Connect ID should have permission?
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?
89. Which of the following menu options allows you to modify the Last Process Instance Number used within the system?
90. Which Trace 255 command line options produces the trace file with the name?
91. Where can you see the status of the job report and details in secured way?
92. How can youset Non-Repudiation property?
93. If you delete a page from PSPT application, which all tables are affected?
94. If you change the long name of translate field what object is to be altered?
95. When do configuration changes made using the configuration Manager take effect?
96. Which one of the following is NOT a valid PeopleSoft query type?
97. Interlink data type can be declared as?
98. Which is the PeopleSoft’s hub to handle complex system-to-system interactions?
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?
100. In which PeopleCode event does ALL data validation take place?
No comments:
Post a Comment