Peoplesoft Interview Questions (Application Designer)
1. The main attributes of a Component Interface (CI) are?
Keys, Properties & Collections, Methods and Name
2. Which one of the following are standard properties when a Component Interface (CI) is created? Keys, Properties & Collections, Methods and Name
GetHistoryItems
3. 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
4. Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
Get keys, Create keys and Find keys gets created automatically. The Create method is created along with the other Standard methods for the CI
5. Which of the following can be mapped as Find Keys for a Component Interface ?
A OR b
6. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple PeopleSoft components
7. The following are various steps that describes the peoplecode logic while implementing a Component Interface?
1. Establish a user session
2. Get the Component Interface
3. Populate the Create Keys
4. Create an Instance of the CI
5. Populate the required fields
6. Save the CI
8. 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.
9. Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
Yes, databases can co-exist on the same physical machine. In most cases, the databases themselves can exist within the same RDBMS, however, it is important to verify that the database version required by PeopleTools 8.4 is the same as for the current PeopleTools 8.1x implementation.
10. 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.
11. How does the PeopleSoft Enterprise Portal work with 8.1x and 8.4 applications?
There are several scenarios that may exist when customers use the PeopleSoft Enterprise Portal with a mixture of 8.1x and 8.4 applications. Specific information on the use of the PeopleSoft Enterprise Portal in a blended environment will be available in a forthcoming white paper, which will be available on Customer Connection. In general, the recommendation is to use the PeopleSoft Enterprise Portal 8.4with 8.1x and 8.4 applications, rather than an older version.
12. For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft's Java Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architecture is supported only on the BEA WebLogic and WebSphere servlet engines.
13. 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 IBM WebSphere 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 environment, 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.
14. Why did PeopleSoft bundle IBM WebSphere Advanced Single Server Edition rather than Advanced Edition?
The Advanced Single Server Edition (AEs) of WebSphere provides the same core J2EE and Web Services programming model as the Advanced Edition (AE) with simplified administration. In the AE version WebSphere uses DB2 or other standard database to keep the configuration and runtime information to support very large farm of WebSphere servers. However, it is one more database to install, administer and maintain. The AEs version does not use the database and uses file based configuration in a way that is similar to BEA WebLogic. PeopleSoft and IBM WebSphere architects determined that AEs version would satisfy the deployment requirements of PeopleSoft customers and would make it easy for owning and administering PeopleSoft Applications based on WebSphere.
15. Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with my other corporate web servers and tools?
One of the core values of the PeopleTools development group is investment protection. The time, money and resources that you may have already invested in licensing another web server, training developers and administrators, building and deploying other web applications will not be compromised by this decision. How is this accomplished
16. Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?
No. The web server that was delivered on the Tuxedo CD has absolutely nothing to do with WebLogic. WebLogic is a web application server that is designed for large-scale production websites. The HTTP server on the Tuxedo CD was only there to provide a mechanism for launching the graphical Tuxedo administration console if the Tuxedo administrator didn't already have a web server in place. It was never intended for large-scale, production website use � only for a system administrator or two.
17. 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.
18. Is WebSphere certified on PeopleTools 8.1x?
No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere for early adopters program, created and managed by IBM. Further information about this program can be found in the whitepaper The IBM WebSphere 8.1x Early Adopter Program. Are there additional license requirements for IBM WebSphere
19. Are there advantages or disadvantages to using BEA WebLogic over IBM WebSphere or vice versa?
No. Both products are certified with PIA as of version 8.4 and work equally well. By offering both BEA WebLogic and IBM WebSphere, we give our customers more choices and flexibility to run PeopleSoft in their preferred environment.
20. 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.
21. Both BEA WebLogic and IBM WebSphere have the ability to plug into many different web servers. Does PeopleSoft support the web servers that they plug into?
BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer to use their own HTTP web server and WebLogic�s or WebSphere�s Java servlet engine. PeopleSoft uses this plug-in capability to support IIS. We have no reason to believe that there will be any issues with other web servers that WebLogic or WebSphere are able to work with through their plug-in architecture, but PeopleSoft GSC will not support these other web servers with PeopleTools 8.4
22. Does Application Messaging work between 8.1xand 8.4 applications?
Application Messaging is used by PeopleSoft applications to communicate with one another. This is true not just for 8.1x and 8.4 applications, but also between an 8.1x and an 8.4 application. For example, the HRMS 8.3 applications, which are based on PeopleTools 8.15, can communicate with Financials 8.4applications, which are based on PeopleTools 8.4, using Application Messaging. If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers.
23. Why is PeopleSoft no longer supporting Apache Jserv?
Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4 for several reasons: v JServ is no longer an active product and is in maintenance mode and there are no longer any new official releases. v Our customers have exhibited a desire to use commercial products for mission-critical enterprise web application servers rather than open source solutions. Therefore, moving to support Tomcat is not seen as a reasonable solution. v Apache can still be used as an HTTP server with BEA WebLogic .
24. 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. You may find this at http://www.peoplesoft.com/corp/en/iou/platforms/index.asp
25. WorkItem is available in?
WorkList Record
26. Where are workflow work items found ?
Worklist
27. In which platform does
Windows (Correct)
28. You want to update your password and enter a hint for forgotten password. What would you access?
User Profile
29. Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
user can type only prompt table values and the default values gets populated from the database.
30. Customization done in Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB
31. 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 ?
Update statistics on the table
32. (Some scenario) Question relating DBA Purging Temporary Table?
Update Statistics
33. How many Message nodes are possible for a database.?
Unlimited
34. How will you get a single output by combining two or more queries?
35. What BEA product is used for DB transaction in PS?
Tuxedo
36. Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
TIMESTAMP
37. 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.
38. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path
39. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
Some options:
1. Customize PS application (Yes)
2. Buy third party software (Yes)
3. Call PS
40. What are the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status
41. Which of the following are part of an AE program ?
Section ,Step and Action
42. Which of the following fires after the database is updated?
SavePostChange
43. What event gets fired after DB Update?
SavePostChange
44. 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 ?
Released
45. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view
46. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE
47. 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
48. Which process is used for running AE programs which are to be run at a frequency of less than a day ?
PSDAEMON
49. you can specifically trace the activity of the PSAPPSRV server process by setting the?
PSAPPSRV.tracesql
50. Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin.?
Psadmin �p start �d
51. In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBLwhich one is the component definition?
PRCSTYPEDEFN.GBL
52. 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
53. 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 ?
PeopleSoft Knowledge base SYSAUDIT finds for Orphaned Records
54. Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
55. Changing Prompt Table with NO Edit to Prompt Table with Edit?
Only selection of existing data is possible
56. Which command is valid in both bootstrap and regular mode when operating the data mover?
GRANT_USER
57. PeopleCode events pertaining to Record Field:?
FieldEdit, SaveEdit and RowDelete
58. Which of the following are Record field events ?
FieldChangeSearchSave and SavePreChange
59. Which of the following commands can be run in Bootstrap mode?
ENCRYPT_PASSWORD
60. What commands are valid in BS mode?
ENCRYPT_PASSWORD
61. What views available in Application Designer project workspace?
Development and Upgrade
62. Which of the above record definitions is NOT stored on the database and is therefore NOT required to be built?
Derived/Work Record
63. You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?
Demo
64. PS Query definition is stored on which server?
DB Server
65. How do you login into BS mode?
DB Access Id
66. If you want to log into DataMover in Bootstrap mode, you would login as..?
Database superuser
67. What is added as new option in Build apart from Create Tables, Indexes, Views?
Create Trigger
68. Where will you configure for failover of Application Server (Scenario)?
Configuration.properties
69. Which one of the following is a transaction control statement ?
Commit
70. What Record Changes does not affect Database?
Change in List box in Record Field properties (correct)
71. Which one of the following steps is NOT part of performing an upgrade?
Apply all outstanding patches, prior to upgrade
72. Update and Fixes: R-* files refers to?
Application Updates and Fixes
73. 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. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?
74. What is the default Crystal Report that PeopleSoft Query tool creates?
ACTQRY.RPT
75. (Some scenario) Find which is not part of AE Program, Options would be?
Action,Section,Step,Event
76. Which of the following are true with respect to validate signon with database option enabled in psadmin.?
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.
2. User must be defined on either the operating system or the database and within the PeopleSoft.
77. Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
1. shuts down the domain using the tmshutdown -k TERM -c command.
2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes
78. After logging into customer connection, you wish to search for fixes/patches. What are the search criteria's available ?
1. Report ID
2. Date / time
3. Release
79. What are the Search Keys you use to find Patches and Fixes?
1. Release
2. Updated date time
3. Report Id
80. Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
1. Query trees
2. Combination trees
81. Which Web Services is only used as a Proxy Server?
1. MS IIS
2. Apache
82. In PeopleCode Debugger what are the valid values?
1. Go
2. Step Over
3. View Variable Value
83. Select the components which form the part of Integration Broker?
1. File Layout
2. CI
3. app. Messaging
84. what are the views available in App. Designer project workspace (multiple answer)?
1. Development
2. Upgrade
85. What are Menu types available?
1. Component
2. PeopleCode
3. Separator
86. Database Connectivity Drivers should be installed in the following System?
1. Client Workstation in two tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)
87. Where do you need to install connectivity software?
1. batch server
2. App server
3. two tier client
88. What are the People Tools available for Integration Broker?
1. Appl. Messaging
2. Component Interface
3. File Layout
89. A Customer wants to use a new Image in HRMS, where it is stored?
DB Server
90. Can you access pia from mac OS?
Yes
91. Which language technology is used in app messaging?
XML
92. Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
WinMessage
93. PIA screens and recognize it?
Where are the work items presentWorkilist
94. Where do u set the web server cache?
webserver configuration.properties file
95. Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs). You need to decide how to compare the current versions of these COBOL programs with the versions delivered with the new PeopleSoft application release. Which would be the fastest method of comparing these different versions?
Use non-PeopleSoft comparison tools. 5.
96. True or False. A business Process be used as a Navigator Home page ?
true
97. True or False. The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory?
True
98. True or False. State Record can be Dynamic Record?
True
99. True or False. In Call Section � Action it is possible to leave the Program ID with blank Value in certain cases?
True
100. True or False. You can assign multiple databases and application servers to a single profile. But, each database and application server must be assigned to only one profile?
True
PeopleSoft Interview Questions - Answers Set - 4
Which Web Services is only used as a Proxy Server?
1. MS IIS 2. Apache
1. MS IIS 2. Apache
In PeopleCode Debugger what are the valid values?
1. Go 2. Step Over 3. View Variable Value
1. Go 2. Step Over 3. View Variable Value
Select the components which form the part of Integration Broker?
1. File Layout 2. CI 3. app. Messaging
1. File Layout 2. CI 3. app. Messaging
What are the views available in App. Designer project workspace(multiple answer)?
1. Development 2. Upgrade
1. Development 2. Upgrade
What are Menu types available?
1. Component 2. PeopleCode 3. Separator
1. Component 2. PeopleCode 3. Separator
Database Connectivity Drivers should be installed in the following System?
1. Client Workstation in two tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)
1. Client Workstation in two tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)
Where do you need to install connectivity software?
1. batch server 2. App server 3. two tier client
1. batch server 2. App server 3. two tier client
What are the People Tools available for Integration Broker?
1. Appl. Messaging 2. Component Interface 3. File Layout
1. Appl. Messaging 2. Component Interface 3. File Layout
A Customer wants to use a new Image in HRMS, where it is stored?
DB Server
DB Server
We access pia from mac OS?
Yes
Yes
Which of the following technology is used in app messaging?
XML
XML
Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
WinMessage
WinMessage
PIA screens and recognize it?
Where are the work items presentWorkilist
Where are the work items presentWorkilist
Where do u set the web server cache?
web server configuration.properties file
web server configuration.properties file
Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs). You need to decide how to compare the current versions of these COBOL programs with the versions delivered with the new PeopleSoft application release. Which would be the fastest method of comparing these different versions?
Use non-PeopleSoft comparison tools. 5.
Use non-PeopleSoft comparison tools. 5.
Can a business Process be used as a Navigator Home page ?
true
true
The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory?
True
True
State Record can be Dynamic Record?
True
True
In Call Section ? Action it is possible to leave the Program ID with blank Value in certain cases?
True
True
Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
Oracle, DB2, Other Options: SQL Server, Informix, Sybase
Changing Prompt Table with NO Edit to Prompt Table with Edit?
Only selection of existing data is possible
Only selection of existing data is possible
Which command is valid in both bootstrap and regular mode when operating the data mover?
GRANT_USER
GRANT_USER
PeopleCode events pertaining to Record Field:?
FieldEdit, SaveEdit and RowDelete
FieldEdit, SaveEdit and RowDelete
Which of the following are Record field events ?
FieldChangeSearchSave and SavePreChange
FieldChangeSearchSave and SavePreChange
Which of the following commands can be run in Bootstrap mode?
ENCRYPT_PASSWORD
ENCRYPT_PASSWORD
What commands are valid in BS mode?
ENCRYPT_PASSWORD
ENCRYPT_PASSWORD
What views available in Application Designer project workspace?
Development and Upgrade
Development and Upgrade
Which of the above record definitions is NOT stored on the database and is therefore NOT required to be built?
Derived/Work Record
Derived/Work Record
You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?
Demo
Demo
PS Query definition is stored on which server?
DB Server
DB Server
How do you login into BS mode?
DB Access Id
DB Access Id
If you want to log into DataMover in Bootstrap mode, you would login as..?
Database superuser
Database superuser
What is added as new option in Build apart from Create Tables, Indexes, Views?
Create Trigger
Create Trigger
Where will you configure for failover of Application Server (Scenario) -?
Configuration.properties
Configuration.properties
Which one of the following is a trasaction control statement ..?
Commit
Commit
What Record Changes does not affect Database?
Change in List box in Record Field properties (correct)
Change in List box in Record Field properties (correct)
Which one of the following steps is NOT part of performing an upgrade?
Apply all outstanding patches, prior to upgrade
Apply all outstanding patches, prior to upgrade
Update and Fixes: R-* files refers to?
Application Updates and Fixes
Application Updates and Fixes
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. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?
Add the field, SETID, as a key field to each table you want to share, and then define the set control field. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?
What is the default Crystal Report that PeopleSoft Query tool creates?
ACTQRY.RPT
ACTQRY.RPT
(Some scenario) Find which is not part of AE Program, Options would be?
Action,Section,Step,Event
Action,Section,Step,Event
Which of the following are true with respect to validate signon with database option enabled in psadmin.?
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.
2. User must be defined on either the operating system or the database and within the PeopleSoft.
1. The application server first attempts to connect to database using the user id and password as part of the database connection string.
2. User must be defined on either the operating system or the database and within the PeopleSoft.
Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
1. shuts down the domain using the tmshutdown -k TERM -c command.
2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes
1. shuts down the domain using the tmshutdown -k TERM -c command.
2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes
After logging into customer connection, you wish to search for fixes/patches. What are the search criteria's available ?
1. Report ID
2. Date / time
3. Release
1. Report ID
2. Date / time
3. Release
What are the Search Keys you use to find Patches and Fixes?
1. Release
2. Updated date time
3. Report Id
1. Release
2. Updated date time
3. Report Id
Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
1. Query trees
2. Combination trees
1. Query trees
2. Combination trees
Peoplesoft Interview questions and answers- SQR
1. What are the sections and paragraphs available?
There are five sections and three paragraphs available in SQR programming. The sections include
a. Begin-setup End-setup.
b. Begin-program End-program.
c. Begin-procedure End-procedure.
d. Begin-heading End-heading.
e. Begin-footing End-footing
And the paragraphs include
Begin-select paragraph.
Begin-SQL paragraph.
Begin-document paragraph
2. Is it possible to increase the array size once defined?
No, it is not possible to increase the Array size once defined
3. What is Load-lookup? Give the Syntax for Load-Lookup?
The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. With LOAD-LOOKUP, you can reduce the number of tables that are joined in one SELECT. Use this command in conjunction with one or more LOOKUP commands.
Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
end-setup
4. Can you Call a SQR from another SQR? How?
We can call one SQR program from another SQR program using Call.callsystem. But this is possible only in UNIX Operating system.
5. Briefly explain Most commonly used SQC’s in SQR programs?
: Some of the most commonly used SQC’s are
1.STDAPI.sqc : This Is Process Scheduler Interface which is used to initiate and terminate some field values such as Process_instance & Run_cntl_id
2.SETENV.sqc : This is used to set the Default Environment based on the Database such Printer Type, Paper Size,Date formats Etc….
3.NUMBER.sqc : This file contains generalized routines to format numbers.
4.DATETIME.sqc : This file contains generalized routines to format dates and times.
6.RESET.sqc : This is an important Footing SQc.
6. What are the commands used in filehandling of sqr?
Using File Handling we can Import. Steps are
1. Opening a File Using ‘OPEN FOR-READING’ command.
1. Reading Data From File Using ‘READ’ command.
Writing Data into Table Using ‘BEGIN-SQL’ paragraph & ‘INSERT’ command
7. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes. The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.
8. How can you Debug SQR programs?
We can Debug SQR using Debugging Commands such as
2. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW
9. What is the difference between sqr and sqc?
SQR SQC
1.This is nothing but the Actual 1.This is like a function in SQR.
Source program.
2.This consists of Program Section. 2.This does not consists of program Section.
3.This can be Compiled & Executed. 3.This cannot be Compiled and Executed.
4.We cannot call one SQR from 4.We can call one SQC from another SQC or another SQR
or SQC. SQR program.
10. What are different types of variables in sqr?
Types of variables in SQR are
1. Column Variables.
2. List Variables.
3. System Variables.
4. Document Variables.
5. Substitution Variables.
User Defined Variables
11. Is there any read-only variable in sqr?
Column Variables & System Variables are Read-Only Variables.
12. How to pass Inputs for sqr program while running from windows?
Using ASK & INPUT Commands.
13. How to pass Inputs to the SQR while running through the Process Scheduler?
Using Procedures & SQC’s to access data on Run Control Page (Run Control Fields).
14. What is the purpose of Stdapi.sqc
This is a Process Scheduler Interface sqc which is used to initiate and terminate some field
values such as Process_instance & Run_cntl_id
15. What is the SQT file? What are the advantages of SQT files?
SQT’ file is nothing but resultant file after the compilation (i.e.) Runtime File. By using this SQT file for Execution we can increase the Performance of the program by reduciong the Compilation Time.
16. What is the SQC used to read data from translate table?
‘READXLAT.sqc’ is the SQC used to read data from Translate Table.
17. Which section is mandatory in an SQR program?
‘BEGIN-PROGRAM’ Section is Mandatory for an SQR program.
18. How will you display an image in SQR?
Using ‘DECLARE-IMAGE , END-DECLARE’ command.
19. What is use of SETENV.SQC?
This is used to set the Default Environment based on the Database such Printer Type, Paper Size, Date formats Etc….
20. How will you perform ERROR handling in SQR?
We can do Error handling in SQR using some command line flags such as –O, -L,-ZMF,-XMB and using Error handling commands such as
ON-ERROR = Skip/Warn/Stop (for Compile time errors)
ON-ERROR = Procedure Name (for execution stage errors).
21. How many ways of performance tuning are there in SQR?
1. Using LOADF-LOOKUP & LOOKUP.
2. Using ARRAYS.
3. Using MULTIPE REPORTS.
4. Using SQT Files.
5. Using –Bnn Command line Flag.
6. Running on BATCH SERVER.
7. Using Proper Programming Logic in SQR such as Using BREAK statement in EVALUATE Command.
8. Proper SQL tuning such as using Sub queries instead of Joins.
22. Can you call procedure in oracle from Sqr? How?
To call a database procedure using Begin-select paragraph, the syntax is as follows:
Begin-select
[(report arguments)]
from Dual
End-select
To call from Begin-sql, the syntax will be
Begin-SQL
;;
End-SQL
23. Can you connect more than one database using one Sqr? How?
Yes.
24. What are the differences between Load lookup and Array
ARRAYS LOAD-LOOKUP
1. Arrays can be declared in any section. 1. Load-Lookup is declared in only in
SETUP section only.
2. Number of rows are not automatically 2. Numbers of rows are automatically added. gives a error if the number of added.
Exceeds the specified number.
3. We should insert data in to Array by 3. Rows are automatically inserted in to
programming. Load-Lookup.
4.We can retrive any number of fields. 4.We can retrive only Two fields from
from a table. a table.
5.We have Length & Data type. 5.We don’t have Length & Data type.
6.We cannot directly print from Array. 6.We can directly print from
Load-Lookup.
25. What are the steps required to run the SQR from peoplesoft environment?
Three steps we have to fallow to run the SQR program from the peoplesoft environment (Process Scheduler). These steps include
a. Making the SQR program API aware by calling two procedures (stdapi-init, stdapi-term) from the Begin-program section and including the Stdapi.sqc in the bottom of the program.
b. Create new run control table or using existing run control table and creating run control page, component and register the component. Creating new run control SQC if we create a new run control table.
c. Giving the permission to the user by giving process groups.
26. How to pass command line flags to a sqr report running through process scheduler?
Using override options in the process definition in the Process Scheduler in the People Tools.
27. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes . The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.
28 .How does peoplesoft Process monitor knows that the process (Say sqr report) is at what stage such as initiated, in process, completed etc
From the Field Value of ‘RUNSTATUSDESCR’field from ‘PS_PMN_PRCSLIST’ table.
29. How can u Debugging SQR programs?
We can Debug SQR using Debugging Commands such as
3. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW
30. How to refer a global variable in local procedure?
After special character (ex.#,&) we use underscore(_) after that variable name.
31. What is -Bnn flag?
This is used to specify the number of rows that are to be taken from Dbase to the Buffer because default the system takes 10 rows at a time.
32. What is -Tnn flag?
This is mainly used for testing purpose. We can restrict the system to generate only a specific number of pages instead of generating all pages for testing. This is used in Windows Environment.
33. What is -RS & -RT Flags?
RS is used to generate SPF file ie; stopping the program after the comilation. _RT is used to run the SPF file .This is also one kind of Performance increasing technique by saving the compilation time.
34. What are the sections in Sqr? Which one is necessary?
Setup, Heading, Footing, Program & Procedure Sections. Program section is the Mandatory section.
35. What is -debug command line flag?
This is used for Debugging in SQR.
1. What are the sections and paragraphs available?
There are five sections and three paragraphs available in SQR programming. The sections include
a. Begin-setup End-setup.
b. Begin-program End-program.
c. Begin-procedure End-procedure.
d. Begin-heading End-heading.
e. Begin-footing End-footing
And the paragraphs include
Begin-select paragraph.
Begin-SQL paragraph.
Begin-document paragraph
2. Is it possible to increase the array size once defined?
No, it is not possible to increase the Array size once defined
3. What is Load-lookup? Give the Syntax for Load-Lookup?
The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. With LOAD-LOOKUP, you can reduce the number of tables that are joined in one SELECT. Use this command in conjunction with one or more LOOKUP commands.
Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
end-setup
4. Can you Call a SQR from another SQR? How?
We can call one SQR program from another SQR program using Call.callsystem. But this is possible only in UNIX Operating system.
5. Briefly explain Most commonly used SQC’s in SQR programs?
: Some of the most commonly used SQC’s are
1.STDAPI.sqc : This Is Process Scheduler Interface which is used to initiate and terminate some field values such as Process_instance & Run_cntl_id
2.SETENV.sqc : This is used to set the Default Environment based on the Database such Printer Type, Paper Size,Date formats Etc….
3.NUMBER.sqc : This file contains generalized routines to format numbers.
4.DATETIME.sqc : This file contains generalized routines to format dates and times.
6.RESET.sqc : This is an important Footing SQc.
6. What are the commands used in filehandling of sqr?
Using File Handling we can Import. Steps are
1. Opening a File Using ‘OPEN FOR-READING’ command.
1. Reading Data From File Using ‘READ’ command.
Writing Data into Table Using ‘BEGIN-SQL’ paragraph & ‘INSERT’ command
7. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes. The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.
8. How can you Debug SQR programs?
We can Debug SQR using Debugging Commands such as
2. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW
9. What is the difference between sqr and sqc?
SQR SQC
1.This is nothing but the Actual 1.This is like a function in SQR.
Source program.
2.This consists of Program Section. 2.This does not consists of program Section.
3.This can be Compiled & Executed. 3.This cannot be Compiled and Executed.
4.We cannot call one SQR from 4.We can call one SQC from another SQC or another SQR
or SQC. SQR program.
10. What are different types of variables in sqr?
Types of variables in SQR are
1. Column Variables.
2. List Variables.
3. System Variables.
4. Document Variables.
5. Substitution Variables.
User Defined Variables
11. Is there any read-only variable in sqr?
Column Variables & System Variables are Read-Only Variables.
12. How to pass Inputs for sqr program while running from windows?
Using ASK & INPUT Commands.
13. How to pass Inputs to the SQR while running through the Process Scheduler?
Using Procedures & SQC’s to access data on Run Control Page (Run Control Fields).
14. What is the purpose of Stdapi.sqc
This is a Process Scheduler Interface sqc which is used to initiate and terminate some field
values such as Process_instance & Run_cntl_id
15. What is the SQT file? What are the advantages of SQT files?
SQT’ file is nothing but resultant file after the compilation (i.e.) Runtime File. By using this SQT file for Execution we can increase the Performance of the program by reduciong the Compilation Time.
16. What is the SQC used to read data from translate table?
‘READXLAT.sqc’ is the SQC used to read data from Translate Table.
17. Which section is mandatory in an SQR program?
‘BEGIN-PROGRAM’ Section is Mandatory for an SQR program.
18. How will you display an image in SQR?
Using ‘DECLARE-IMAGE , END-DECLARE’ command.
19. What is use of SETENV.SQC?
This is used to set the Default Environment based on the Database such Printer Type, Paper Size, Date formats Etc….
20. How will you perform ERROR handling in SQR?
We can do Error handling in SQR using some command line flags such as –O, -L,-ZMF,-XMB and using Error handling commands such as
ON-ERROR = Skip/Warn/Stop (for Compile time errors)
ON-ERROR = Procedure Name (for execution stage errors).
21. How many ways of performance tuning are there in SQR?
1. Using LOADF-LOOKUP & LOOKUP.
2. Using ARRAYS.
3. Using MULTIPE REPORTS.
4. Using SQT Files.
5. Using –Bnn Command line Flag.
6. Running on BATCH SERVER.
7. Using Proper Programming Logic in SQR such as Using BREAK statement in EVALUATE Command.
8. Proper SQL tuning such as using Sub queries instead of Joins.
22. Can you call procedure in oracle from Sqr? How?
To call a database procedure using Begin-select paragraph, the syntax is as follows:
Begin-select
[(report arguments)]
from Dual
End-select
To call from Begin-sql, the syntax will be
Begin-SQL
;;
End-SQL
23. Can you connect more than one database using one Sqr? How?
Yes.
24. What are the differences between Load lookup and Array
ARRAYS LOAD-LOOKUP
1. Arrays can be declared in any section. 1. Load-Lookup is declared in only in
SETUP section only.
2. Number of rows are not automatically 2. Numbers of rows are automatically added. gives a error if the number of added.
Exceeds the specified number.
3. We should insert data in to Array by 3. Rows are automatically inserted in to
programming. Load-Lookup.
4.We can retrive any number of fields. 4.We can retrive only Two fields from
from a table. a table.
5.We have Length & Data type. 5.We don’t have Length & Data type.
6.We cannot directly print from Array. 6.We can directly print from
Load-Lookup.
25. What are the steps required to run the SQR from peoplesoft environment?
Three steps we have to fallow to run the SQR program from the peoplesoft environment (Process Scheduler). These steps include
a. Making the SQR program API aware by calling two procedures (stdapi-init, stdapi-term) from the Begin-program section and including the Stdapi.sqc in the bottom of the program.
b. Create new run control table or using existing run control table and creating run control page, component and register the component. Creating new run control SQC if we create a new run control table.
c. Giving the permission to the user by giving process groups.
26. How to pass command line flags to a sqr report running through process scheduler?
Using override options in the process definition in the Process Scheduler in the People Tools.
27. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes . The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.
28 .How does peoplesoft Process monitor knows that the process (Say sqr report) is at what stage such as initiated, in process, completed etc
From the Field Value of ‘RUNSTATUSDESCR’field from ‘PS_PMN_PRCSLIST’ table.
29. How can u Debugging SQR programs?
We can Debug SQR using Debugging Commands such as
3. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW
30. How to refer a global variable in local procedure?
After special character (ex.#,&) we use underscore(_) after that variable name.
31. What is -Bnn flag?
This is used to specify the number of rows that are to be taken from Dbase to the Buffer because default the system takes 10 rows at a time.
32. What is -Tnn flag?
This is mainly used for testing purpose. We can restrict the system to generate only a specific number of pages instead of generating all pages for testing. This is used in Windows Environment.
33. What is -RS & -RT Flags?
RS is used to generate SPF file ie; stopping the program after the comilation. _RT is used to run the SPF file .This is also one kind of Performance increasing technique by saving the compilation time.
34. What are the sections in Sqr? Which one is necessary?
Setup, Heading, Footing, Program & Procedure Sections. Program section is the Mandatory section.
35. What is -debug command line flag?
This is used for Debugging in SQR.
36. How to place an corporate logo in sqr?
Using “Declare Image” command
Using “Declare Image” command
37. what are the debugging commands in sqr?
Show & Display are debugging commands
Show & Display are debugging commands
38. what is the difference between them on Show & Display?
Show is used to display more than one variable at a time.
Display is used to display only one variable at a time.
Show is used to display more than one variable at a time.
Display is used to display only one variable at a time.
PeopleSoft SQR Interview Questions,SQR Interview Questions asked in MNCs given below
What are the Important SQC are need to be attached?
How do you do Performance tuning of SQR?
Did you worked with functions, procedures in SQR?
Can we call two Procedures in On-Break? If yes Then How?
How can you send emails using SQR
What are the compulsory SQC's that should be used in SQR Program?
How do you generate two output files from one SQR.
What is hierarchy in Arrays in SQR?
What is the difference in using inner join and outer joins?
Did you worked with functions, procedures in SQR?
Can we include SETENV.SQC at the end of the SQR program? If "NO" then why?
How do you include SQCs in middle of the program? Is it possible ?
We wish to print the EMPLID in the BARCODE Format. What are the commands we have to be used in SQR?
What are the compulsary SQC's that should be used in SQR Program?
What is Calculated,Dependent and Conditional Marter Inspection Characteristic?
Explain Normalization in oracle?
What is difference between Load Look up and Array
What is search Record?
What is the program flow of SQR?
What are the validation is done in SQR program before loading in to the database?
How to create SQC?
How to connect other application in component interface?
What is the main difference between SQR and APP ENGINE?
How do you decide between appeng/Ci and SQR while conversion?
What is Outer join, inner join in sql?
Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?
What is the difference between BI,CI and IB?
Tell me your experience with CI?
What are the Important SQC are need to be attached?
How do you do Performance tuning of SQR?
Did you worked with functions, procedures in SQR?
Can we call two Procedures in On-Break? If yes Then How?
How can you send emails using SQR
What are the compulsory SQC's that should be used in SQR Program?
How do you generate two output files from one SQR.
What is hierarchy in Arrays in SQR?
What is the difference in using inner join and outer joins?
Did you worked with functions, procedures in SQR?
Can we include SETENV.SQC at the end of the SQR program? If "NO" then why?
How do you include SQCs in middle of the program? Is it possible ?
We wish to print the EMPLID in the BARCODE Format. What are the commands we have to be used in SQR?
What are the compulsary SQC's that should be used in SQR Program?
What is Calculated,Dependent and Conditional Marter Inspection Characteristic?
Explain Normalization in oracle?
What is difference between Load Look up and Array
What is search Record?
What is the program flow of SQR?
What are the validation is done in SQR program before loading in to the database?
How to create SQC?
How to connect other application in component interface?
What is the main difference between SQR and APP ENGINE?
How do you decide between appeng/Ci and SQR while conversion?
What is Outer join, inner join in sql?
Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?
What is the difference between BI,CI and IB?
Tell me your experience with CI?
Peoplesoft Interview Questions - Component Interface Builder
1) What are the main elements in the component Interface ?
Main elements of component Interface
• Component interface name
• Keys
• Properties and collections
• Methods
2) Difference between Get keys, find keys and Create Keys ?
Get keys: - These are mapped to the fields marked as scrh in the component’s search record. Automatically “Search key” fields in search record become Get keys.
We cannot change it.
Find keys: - These are mapped to fields marked as Alt or Srch in the component search record. You may remove Find keys that you do not wish to make available for searching.
Create Keys: - It is generated from the key fields for the search record. If Add search record is present then its key fields are taken. We cannot change it.
3) How do you provide security for the component interface?
• Open the Permission list
• On the Component Interface tab
• Add row and select the newly created Component Interface
• Edit the permissions to give permission for the standard methods
• Get, Create, Save, cancel, find.
4) What the steps that you need to do in people code to invoke Component Interface?
• Establish a user section
• Get the component interface definition
• Populate the create keys
• Create an instance of the component interface
• Populate the required fields
• Save the component Interface.
&Session = GetSession();
&CI = &Session.GetcompIntfc(CompIntfc.INTERFACE_NAME)
&CI.KEY_FILED_NAME = ‘NEW’
If not &CI.Create () Then
Else
Populate other fields
End-if;
Populate the other fields
If not &CI.Save () Then
Else
End-if;
5) How do you test Component Interface?
• Using the Component Interface tester
• Give values in the tester for options
• Get Existing, Create new, Find and perform the operation from the CI Tester
6) Catching error message in the component Interface? Or
Use of PSMessages in the CI ?
This function needs to be called when ever methods like Find, Save, Create methods return false.
Error text and Error type can be printed in the log message for any other action in to the log messge.
Function CheckErrorCodes()
&PSMessages = &Session.PSMessages;
&ErrorCount = &PSMessages.Count;
For &i = 1 To &ErrorCount
&ErrorText = &PSMessages.Item(&i).Text;
&ErrorType = &PSMessages.Item(&i).Type;
End-For;
End-Function;
7) What is method? What are the different types of method?
Methods: - A method is an object that performs a very specific function on a component interface at run-time.
Standard methods and user-defined methods.
Standard methods: - Automatically generated upon the creation of a new component Interface in Application.
Apart from the Standard methods there are Standard methods available for the use with any collection.
User-Defined methods: - User-defined methods are those that you can create to meet the requirements of an individual component interface.
8) What are properties?
The Fields in the level 0 in the component are the properties of the component.
Standard properties User-Defined properties
Createkeyinfocollection Developer can further control the exposed Getkeyinfocollection field properties.
Findkeyinfocollection
Property Info collection
GetHistoryItems (Update/Display mode or Correction mode)
EditHistory Items
InteractiveMode.
9) Traversing the Collections in the Component Interface?
COLL_JOB – Collection
Coll_JOBItm – Row in the collection.
&COLL_JOBCol = &CI_JOB_DATA.COLL_JOB;
For &i = 1 to &COLL_JOBCol.Count
&COLL_JOBItm = &COLL_JOBCol.Item (&i);
&COLL_JOB_JRCol = &COLL_JOBItm.COLL_JOB_JR;
For &J = 1 to &COLL_JOB_JRCol.Count
&COLL_JOB_JRItm = &COLL_JOB_JRCol.Item (&j);
&COLL_JOB_JRItm.KEYPROP_EFFDT =;
10) How do you login in correction mode in the Component Interface?
Get History Items and Edit History items property to should be set to true.
Get History Items alone: - Update display all - modes will be used.
1) What are the main elements in the component Interface ?
Main elements of component Interface
• Component interface name
• Keys
• Properties and collections
• Methods
2) Difference between Get keys, find keys and Create Keys ?
Get keys: - These are mapped to the fields marked as scrh in the component’s search record. Automatically “Search key” fields in search record become Get keys.
We cannot change it.
Find keys: - These are mapped to fields marked as Alt or Srch in the component search record. You may remove Find keys that you do not wish to make available for searching.
Create Keys: - It is generated from the key fields for the search record. If Add search record is present then its key fields are taken. We cannot change it.
3) How do you provide security for the component interface?
• Open the Permission list
• On the Component Interface tab
• Add row and select the newly created Component Interface
• Edit the permissions to give permission for the standard methods
• Get, Create, Save, cancel, find.
4) What the steps that you need to do in people code to invoke Component Interface?
• Establish a user section
• Get the component interface definition
• Populate the create keys
• Create an instance of the component interface
• Populate the required fields
• Save the component Interface.
&Session = GetSession();
&CI = &Session.GetcompIntfc(CompIntfc.INTERFACE_NAME)
&CI.KEY_FILED_NAME = ‘NEW’
If not &CI.Create () Then
Else
Populate other fields
End-if;
Populate the other fields
If not &CI.Save () Then
Else
End-if;
5) How do you test Component Interface?
• Using the Component Interface tester
• Give values in the tester for options
• Get Existing, Create new, Find and perform the operation from the CI Tester
6) Catching error message in the component Interface? Or
Use of PSMessages in the CI ?
This function needs to be called when ever methods like Find, Save, Create methods return false.
Error text and Error type can be printed in the log message for any other action in to the log messge.
Function CheckErrorCodes()
&PSMessages = &Session.PSMessages;
&ErrorCount = &PSMessages.Count;
For &i = 1 To &ErrorCount
&ErrorText = &PSMessages.Item(&i).Text;
&ErrorType = &PSMessages.Item(&i).Type;
End-For;
End-Function;
7) What is method? What are the different types of method?
Methods: - A method is an object that performs a very specific function on a component interface at run-time.
Standard methods and user-defined methods.
Standard methods: - Automatically generated upon the creation of a new component Interface in Application.
Apart from the Standard methods there are Standard methods available for the use with any collection.
User-Defined methods: - User-defined methods are those that you can create to meet the requirements of an individual component interface.
8) What are properties?
The Fields in the level 0 in the component are the properties of the component.
Standard properties User-Defined properties
Createkeyinfocollection Developer can further control the exposed Getkeyinfocollection field properties.
Findkeyinfocollection
Property Info collection
GetHistoryItems (Update/Display mode or Correction mode)
EditHistory Items
InteractiveMode.
9) Traversing the Collections in the Component Interface?
COLL_JOB – Collection
Coll_JOBItm – Row in the collection.
&COLL_JOBCol = &CI_JOB_DATA.COLL_JOB;
For &i = 1 to &COLL_JOBCol.Count
&COLL_JOBItm = &COLL_JOBCol.Item (&i);
&COLL_JOB_JRCol = &COLL_JOBItm.COLL_JOB_JR;
For &J = 1 to &COLL_JOB_JRCol.Count
&COLL_JOB_JRItm = &COLL_JOB_JRCol.Item (&j);
&COLL_JOB_JRItm.KEYPROP_EFFDT =;
10) How do you login in correction mode in the Component Interface?
Get History Items and Edit History items property to should be set to true.
Get History Items alone: - Update display all - modes will be used.
Posts
