Question Paper with Answers

No of
Easy
Questions
PeopleSoft Internet Architecture
4
SQR Reports
11
Application Designer
18
PeopleCode
18
Process Scheduler
4
Applicaition Engine
19
Component Interface
8
File Layout
5
Cyrstal Reports
4
PS Query
4
Workflow
2
Security
3
Topic

Total

100

1. Which protocol does the web server use?

a) HTTP
b) FTP
c) SMTP
d) None

Medium Difficult
2
3
5
5
1
5
3
1
2
1
1
1

1
4
5
5
2
5
2
2
1
1
1
1

1
4
8
8
1
9
3
2
1
2
0
1

30

30

40

Complexity: Medium
Answer: HTTP
2. Application Server issues SQL statement to the database server.
a) True
b) False
Complexity: Difficult
Answer: True
3. PIA stands for
a) Peoplesoft Internet Architecture
b) Pure Internet Architecture
c) Pure Intel Architecture
d) There is no acronym
Complexity: Easy
Answer: Peoplesoft Internert Architecture
4. Peoplesoft servlets on the web server transmit requests and data through BEA Jolt
which runs on the application server.
a) True
b) False
Complexity: Difficult
Answer: True
5. Execution of a SQR begins with
a) begin-heading Section
b) begin-program Section
c) begin-footing Section
d) begin-procedure Section
Complexity: Easy
Answer: begin-program Section
6. In SQR, we can refer to database columns as variables. Column variables are
preceded with an ampersand (&).
a) True
b) False
Complexity: Difficult
Answer: True
7. Which of the following commands is a debug command in SQR
a) LET
b) MOVE
c) SHOW
d) DO
Complexity: Easy
Answer: SHOW
8. Difference between MOVE and LET command is
a) LET command can only be used to initialize values. It cant handle arithmetic
operations. MOVE command can be used initialize values and also to handle
arithmetic operations
b) Both LET and MOVE are the same and are used only to initialize values. Both
LET and MOVE cannot handle arithmetic operations.

c) Both LET and MOVE are the same and are used to initialize values and also to
handle arithmetic operations.
d) MOVE command can only be used to initialize values. It cant handle
arithmetic operations. LET command can be used initialize values and also to
handle arithmetic operations
Complexity: Difficult
Answer: d)
9. LOAD LOOKUP is a performance tuning method in SQR
a) True
b) False
Complexity: Easy
Answer: True
10. DISPLAY Command can display multiple values at a time
a) True
b) False
Complexity: Difficult
Answer: False
11. PRINT ON-BREAK performs special processing when a value changes, such as the
state column in a listing of customer addresses.
a) True
b) False
Complexity: Difficult
Answer: True
12. String variables in SQR are prefixed by
a) # b)$
c) &
d) @
Complexity: Medium
Answer: b) $
13. An SQR program can have HEADING and FOOTING sections which create the heading
and footing of a report page.
a) True
b) False
Complexity: Difficult
Answer: True
14. A procedure begins with OPEN-PROCEDURE and ends with CLOSE-PROCEDURE.
a) True
b) False
Complexity: Difficult
Answer: b) False
15. When you click a content reference in the navigation, what appears in the target area
of the screen?
1. A page.
2. A component.
3. A menu.
4. A search page.

Complexity: Difficult
Answer: 4 (a search page).
16. You enter rows of data at level one on a page by:
1. Clicking the Insert button.
2. Clicking the Add button.
3. Adding a new value from the search page.
4. Either 2 or 3.
Complexity: Medium
Answer: 1 (clicking the Insert button).
17. PeopleSoft tables are organized into fields and records.
a) True
b) False
Complexity: Easy
Answer: b) (false).
18. You are finished with the data design phase when you complete this step:
1. Define records
2. Build tables
3. Define components
4. Register components
Complexity: Easy
Answer: 2 (build tables).
19. To help organize definitions that you are developing and package them for export to
other databases, what type of definition do you use?
1. Page
2. Record
3. Project
4. Component
Complexity: Medium
Answer: 3 (project).
20. Translate values:
1. Are available only on character fields.
2. Are effective dated.
3. Are associated with one field.
4. Are stored in PSXLATITEM.
5. All of the above.
Complexity: Difficult
Answer: 5 (all of the above).
21. Which of the following edits is not a PeopleSoft edit?
1. Prompt table
2. On/Off table
3. Translate table
4. Required check box
Complexity: Difficult

Answer: 2 (On/Off table).

22. Which of the following generate indexes in the PeopleSoft environment?
1. Custom fields
2. Alternate index fields
3. Search keys
4. Foreign keys
Complexity: Difficult
Answer: 3 (search keys).
23. Each content reference includes a reference to a menu and a component.
a) True
b) False
Complexity: Medium
Answer: a) (true).
24. Auditing is configured at the record definition level.
a) True
b) False
Complexity: Easy
Answer: a) (true).
25. A database view is a SQL statement that is stored in Application Designer that
retrieves
data from one or more SQL tables.
a) True
b) False
Complexity: Medium
Answer: b) (False).
26. Summary pages and interactive pages always refer to the tables where data is
stored.
a) True
b) False
Complexity: Medium
Answer: b) (False).
27. In a PeopleSoft view, you use key structure to search and sort.
a) True
b) False
Complexity: Difficult
Answer: a) (true).
28. For the search page to build correctly, the search record must contain at least one:
1. Key
2. Search key
3. Alternate search key
4. List box item
Complexity: Difficult
Answer: 2 (search key).

29. If you make a non-key field an alternate search key, you need to regenerate the
indexes.
a) True
b) False
Complexity: Difficult
Answer: a) (true).
30. You can set up a view as a prompt table to:
1. Provide additional search criteria.
2. Filter rows of data.
3. Rearrange columns to manipulate the key structure.
4. All of the above.
Complexity: Easy
Answer: 4 (All of the above).
31. Parent records have all of the keys of the child and one more key field.
a) True
b) False
Complexity: Difficult
Answer: a) (False).
32. You use occurs levels to enforce parent-child relationships on page definitions.
a) True
b) False
Complexity: Medium
Answer: a) (true).
33. You keep server trips to a minimum in interactive mode.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
34. The None function returns false only if there is:
1. No value in any of the fields listed.
2. No value in one of the fields listed.
3. A value in all of the fields listed.
4. A value in any of the fields listed.
Complexity: Easy
Answer: 4 (A value in any of the fields listed).
35. Where are default values defined for a field?
1. Field definition.
2. Record definition.
3. Page definition.
4. SQL table.
Complexity: Medium
Answer: 2 (record definition).
36. What is the advantage to putting PeopleCode on a component definition instead of a
record definition?
1. SearchInit and SearchSave PeopleCode can only be placed on a component.

2. Component PeopleCode is easier to access.

3. PeopleCode on a component will only execute in that component.
4. PeopleCode on a component is available for execution by other components.
Complexity: Difficult
Answer: 3 (PeopleCode on a component will only execute in that
component.)
37. SQLExec Insert, Update, and Delete statements will only affect one row.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
38. You would instantiate a standalone rowset using:
1. A CreateRowset function.
2. A CreateRowset method.
3. A GetRowset function.
4. A GetRowset method.
Complexity: Difficult
Answer: 1 (a CreateRowset function.)
39. Using a Where clause in a Select method allows you to restrict:
1. The columns that are returned.
2. The rows that are returned.
3. The locations that are returned.
Complexity: Difficult
Answer: 2 (The rows that are returned).
40. When an application class is instantiated, the classes constructor method executes
automatically.
a) True
b) False
Complexity: Difficult
Answer: a) (true).
41. You always traverse the data buffer starting with the level 0 rowset.
a) True
b) False
Complexity: Medium
Answer: b) (False).
42. Which of the following represents the data in the entire component?
1. The level 0 rowset.
2. The component buffer.
3. Both of the above.
4. Neither of the above.
Complexity: Difficult
Answer: 3 (both of the above.)
43. ActiveRowCount takes as its argument a:
1. Component name.

2. Page name.
3. Record (or scroll) name.
4. Row number.
Complexity: Easy
Answer: 3 (Record or scroll name).
44. A Return in a function returns control to the calling program.
a) True
b) False
Complexity: Easy
Answer: a) (true).
45. Input and output parameters are differentiated by:
1. The As input or As output keywords.
2. Order, input first then output.
3. Neither. All parameters are both input and output.
Complexity: Easy
Answer: 3 (neither. All parameters are both input and output.)
46. Which of the following is not a PeopleCode reserved word?
1. RECORD
2. PAGE
3. COMPONENT
4. VARIABLE
Complexity: Easy
Answer: 4 (VARIABLE).
47. If the function All is passed a list of values, it will return True if any of those fields or
Variables contain a value.
a) True
b) False
Complexity: Medium
Answer: b) (False).
48. Which of the following is not a benefit of using the Message Catalog?
1. Reuse and share messages among programs.
2. Provides one central place to create and maintain messages.
3. Facilitates translation.
4. Provides syntax checking.
Complexity: Medium
Answer: 4 (provides syntax checking.).
49. You can declare, instantiate, and populate an array in a single line of code.
a) True
b) False
Complexity: Difficult
Answer: a) (true).
50. What other PeopleCode event would you expect to find corresponding with a
FieldChange program?
1. FieldDefault

2. FieldFormula
3. RowInit
4. FieldEdit
Complexity: Medium
Answer: 3 (RowInit).
51. You can put SearchInit or SearchSave on any field, but only on a search record.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
52. Which loop will always execute at least once if it is invoked?
1. While
2. Repeat-Until
3. For
4. All of the above
Complexity: Easy
Answer: 2 (Repeat-Until).
53. A Run Control Id is used as a key for records that contain parameters that a process
needs at the runtime.
a) True
b) False
Complexity: Medium
Answer: a) (true).
54. Run Control Id are stored in a minimum of two tables: An Application run control table
and the Tools Run Control Table PSPRCSRQST
a) True
b) False
Complexity: Easy
Answer: a) (true).
55. The status Pending on process monitor means that your process is Queued.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
56. The output format of the process is set in Process Definition.
a) True
b) False
Complexity: Medium
Answer: a) (true).
57. Which of these statements is false?
1. Application Designer can be used to execute Application Engine Programs.
2. Application Engine Designer is a new independent PeopleSoft 8.4 tool.
3. Application Designer can be used to modify Application Engine programs
4. Application Engine Designer permits developers to view program structure.

Complexity: Medium
Answer: 2 (Application Engine Designer is a new, independent PeopleSoft
8.4 tool).
58. Which of these is not part of an Application Engine Programs structure?
1. Section
2. Step
3. Action
4. SQL
Complexity: Easy
Answer: 4 (SQL).
59. Where are Application Engine program properties specified?
1. In Application Designer.
2. In Application Engine Designer.
3. In PIA on the process definition.
4. On the Process Run Control when executed.
Complexity: Difficult
Answer: 2 (In Application Engine Designer).
60. The Run Request dialog is available only from Application Designer when running in
two-tier.
a) True
b) False
Complexity: Medium
Answer: a) (true).
61. Every Application Engine program must have a state record.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
62. %SELECT is used by an Application Engine program to retrieve a value from the state
record.
a) True
b) False
Complexity: Medium
Answer: b) (False).
63. The state record is associated with a program in
1. Application Designer.
2. The SQL contained by the Application Engine program.
3. In the Process Definition for the Program.
4. In the Program Properties.
Complexity: Difficult
Answer: 4 (In the Program Properties).
64. You can view the command line that was used to launch a process by clicking which
link?
1. Parameters.
2. Message Log.

3. Batch Timings.
4. View Log/Trace.
Complexity: Difficult
Answer: 1 (Parameters).
65. Which of these cannot be traced in an Application Engine trace file?
1. SQL statements.
2. Steps.
3. Statement Timings.
4. PeopleCode statements.
Complexity: Difficult
Answer: 4 (PeopleCode statements).
66. Where must a program be run from in order to use the interactive debugger?
1. PIA
2. Process Scheduler
3. Two-Tier
4. Application Engine Designer
Complexity: Medium
Answer: 3 (two-tier).
67. When does a Do Select loop stop?
1. When the cursor is closed.
2. When no row is returned.
3. When a row is returned.
4. After the SQL select is carried out.
Complexity: Easy
Answer: 2 (when no row is returned.)
68. Which of the following is not true about the Select/Fetch type of a Do Select loop?
1. It is a fast way to process in a loop.
2. It is the default type.
3. If restart is enabled, it can be restarted inside the loop.
4. Opens the cursor and runs the SQL only once.
Complexity: Easy
Answer: 3 (If restart is enabled, it can be restarted inside the loop.)
69. What record type should you use if you want to preserve your values when the
program abends?
1. Temporary Table
2. SQL View
3. Derived/Work Record
4. SQL Table
Complexity: Medium
Answer: 4 (SQL Table).
70. Which of the Do actions stops when a condition returns TRUE?
1. Do Select
2. Do While
3. Do Until

4. Do When
Complexity: Easy
Answer: 3 (Do Until).
71. What is the last Do action to execute?
1. Do Select
2. Do While
3. Do When
4. Do Until
Complexity: Easy
Answer: 4 (Do Until).
72. What is the Do When action the equivalent of in other programming languages?
1. For Loop.
2. If statement.
3. While Loop.
4. Break statement.
Complexity: Easy
Answer: 2 (If statement).
73. You should not use PeopleCode in an Application Engine program to accomplish which
of the following tasks?
1. Executing a SQL statement.
2. Mathematical computations.
3. Conditional logic and tests.
4. Building parts of a SQL statement (field lists, where clauses, etc.).
Complexity: Medium
Answer: 1 (Executing a SQL statement).
74. Which of the following ways can the AE_SECTION and AE_APPLID fields be
populated on the default state record?
1. A run control setting
2. PeopleCode
3. %Select()
4. All of the above
Complexity: Medium
Answer: 4 (All of the above)
75. Set processing can be described in which one of the following ways:
1. An Application Engine property you can set.
2. Something you have to configure.
3. A programming technique.
4. Looping through many rows in a temporary table.
Complexity: Easy
Answer: 3 (a programming technique).
76. Which of the following is true?
1. Temporary tables must always be used with set-processing.
2. Set-processing is unique to Application Engine.

3. Set-processing uses the RDBMS ability to process multiple rows.

4. Set-processing techniques always generate more SQL to execute.
Complexity: Medium
Answer: 3 (Set-processing uses the RDBMS ability to process multiple
rows).
77. A Select and Fetch Do Select loop does not work well with dynamic SQL because:
1. It is not technically possible to do.
2. The SQL is never re-compiled by the database.
3. You will get an error when you run.
4. Application Engine does not allow it.
Complexity: Medium
Answer: 2 (The SQL is never re-compiled by the database).
78. A component interface enables exposure of a PeopleSoft component (a set of pages
grouped together for a business purpose) for synchronous access from another
application.
a) True
b) False
Complexity: Medium
Answer : a) (True).
79. A component interface maps to multiple PeopleSoft component.
a) True
b) False
Complexity: Easy
Answer: a) (True).
80. A method is a function that performs a specific task on a component interface at
runtime.
a) True
b) False
Complexity: Difficult
Answer: a) (True).
81. Every component interface has the following main attributes:

Name

Keys (get keys, create keys, and find keys)

Properties and collections (fields and records)

Methods
a) True

b) False

Complexity: Easy
Answer: a) (True).
82. The component interface architecture does not comprise three fundamental elements
components, component interfaces, and the component interface API.
a) True

b) False

Complexity: Difficult
Answer: b) (False).
83. Because each component interface refers to a single component, you must know the
structure of the component for which youre constructing a component interface.
a) True
b) False
Complexity: Easy
Answer: a) (True).
84. A file layout is a definition that represents the data structure of a flat (text) file to be
processed.
a) True

b) False

Complexity: Difficult
Answer: a) (True).
85. When reading from or writing to a flat file, SQL can use a file layout as a template to
identify and correctly process the files records and fields.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
86. In File Layout, which of the below file format is not supported
a) CSV
b) TXT
c) XML
d) XLS
Complexity: Medium
Answer: XLS
87. Using a file layout greatly simplifies reading, writing, and manipulating hierarchical
transaction data with PeopleCode.
a) True
b) False
Complexity: Medium
Answer: a) (True).
88. The Format toolbar enables you to format fields with the click of a button.
a) True
b) False
Complexity: Difficult
Answer: a) (True).
89. Summary Info allows you to enter a report title, which you can drag into the report
header from the field explorer.
a) True
b) False
Complexity: Easy
Answer: a) (True).

90. Both the format toolbar and format editor allow you to bold a fields text.
a) True
b) False
Complexity: Medium
Answer: a) (True).
91. Crystal provides unlimited methods to edit text objects.
a) True
b) False
Complexity: Easy
Answer: b) (False).
92. Before a query can be saved, at least one record and one field from that record must
be
Associated with the query.
a) True
b) False
Complexity: Easy
Answer: a) (True).
93. The Distinct feature is located on the Preferences page in Query Manager.
a) True
b) False
Complexity: Difficult
Answer: a) (True).
94. You can add criteria from the Records page.
a) True
b) False
Complexity: Difficult
Answer: b) (False).
95. Use the like condition if you want to retrieve 10 specific employee IDs.
a) True
b) False
Complexity: Medium
Answer: b) (False).
96. Activity maps contain steps, events and routing.
a) True
b) False
Complexity: Easy
Answer: a) (True).
97. Getting the information to the right person is an example of:
1. Rule
2. Role
3. Routing
Complexity: Medium
Answer: 2 (role).
98. The heart of a workflow definition is:
1. Business process definition
2. Input Agent

3. Component Processor (PeopleCode)

4. Routing
Complexity: Difficult
Answer: 3 (component processor (PeopleCode)).
99. Which of the following statements is false?
1. A user profile can consist of many roles.
2. A role can consist of many permission lists.
3. A user profile contains a password.
4. A permission list is a user.
Complexity: Easy
Answer: 4 (a permission list is a user).
100. A
1.
2.
3.
3.

user profile consists of:

One or more roles
A password.
An email address.
All of the above.

Complexity: Medium
Answer: The answer is 4 (all of the above).