1z0-241 | All About Certified 1z0-241 examcollection
Q11. Match each description with a PeopleCode data buffer access object.
a. A component scroll
b. Consists of one or more records of data
c. Can have zero, one, or more child rowsets
d. Consists of one or more fields
A. a - Rowset b – Row c – Row d - Record
B. a - Record b – Row c – Row d - Record
C. a - Rowset b – Rowset c - Row d – Field
D. a - Record b – Rowset c – Row d - Record
E. a - Rowset b – Row c - Record d - Field
Answer: A
Q12. Select three differences between derived/work fields and SQL table fields.(Choose three.)
A. Derived/work fields cannot contain PeopleCode.
B. Derived/work fields cannot have prompt table edits.
C. Users cannot change values in derived/work fields.
D. Derived/work field values are not stored in the database.
E. Standard system validations, such as data type, are not applied on derived/work fields.
F. Derived/work fields can be placed at any level of the page without violating page-order rules.
G. Only those derived/work fields that are on a page or that are referenced by PeopleCode are loaded into the component buffer.
Answer: DFG
Q13. Select the four configurable properties that are common to all PeopleSoft field definitions. (Choose four.)
A. Label ID
B. Type
C. Name
D. Length
E. Default label
F. Effective date
G. Translate values
Answer: ABCE
Q14. Select four PeopleSoft field definition types. (Choose four.)
A. VarChar
B. Integer
C. Number
D. Binary
E. Long Character
F. BLOB
G. Image
H. ImageReference
Answer: CEGH
Q15. Choose the four statements that are true about PSXLATITEM and its values. (Choose four.)
A. Translate values are numeric.
B. Translate values are effective-dated.
C. Translate values are linked to a field.
D. Fields can share values in PSXLATITEM. E. Translate values should be relatively static.
F. PSXLATITEM is the name of the PeopleTools translate table.
Answer: BCEF
Q16. Select the two true statements regarding search attributes. (Choose two.)
A. Search keys do not have to be part of the record definition primary key structure.
B. Alternate search keys generate the search page unless they are not list box items.
C. A field does not have to be a search key or an alternate search key to be a list box item.
D. Unlike search keys, alternate search keys do not appear on the search page in Basic Search mode.
Answer: CD
Q17. You are building an application for a global company with separate business units in Asia, North America, and Africa. Select the type of validation you should configure to enable the users in each of the three continents to use the same tables, but to see different data based on business unit.
A. Prompt validation
B. Effective dating
C. Tableset sharing
D. Security views
Answer: C
Q18. The Run Status column on the Process List page indicates the current state of a process.
Assume that the Process Scheduler server is running, which three statements are true regarding the Run Status column on the Process List page? (Choose three.)
A. Initiated status indicates that a PeopleSoft Process Scheduler Server has acknowledged the new request. At this time, PeopleSoft Process Scheduler validates the parameters that are associated with this request and submits the command line to start the process.
B. Queued status indicates that this process has successfully initiated the program and the program is running.
C. Pending status indicates that this item is waiting for a previous item in the job before PeopleSoft Process Scheduler releases this item. When the previous item has completed successfully, PeopleSoft Process Scheduler changes the status of the item to Queued.
D. Processing status indicates that PeopleSoft Process Scheduler has successfully initiated the program, and that the program is running.
E. No Success status is same as the Error status, which indicates that the program that is associated with the process request encountered an error while processing transactions within the program.
Answer: ACD
Q19. The Order table includes (among other fields) a customer ID and an amount for each item that was ordered. An existing query returns the same number of rows as are in the table. For example, if John ordered 10 items, you would see 10 rows with his ID in the customer ID column.You want to determine how much each customer has ordered, so you need a query that displays just one row for each customer ID and amount field. The value of the amount field in John row would be the sum of the values from the 10 rows.field. The value of the amount field in John? row would be the sum of the values from the 10 rows. How would you calculate how much each customer has ordered?
A. Apply the aggregate function Sum to the amount field.
B. Add a prompt query to further refine the query when it is run.
C. Define expressions to calculate how much each customer has ordered.
D. Define a HAVING criterion to display how much each customer has ordered.
Answer: A
Q20. Select the two field types that should be placed as the last field in the list of fields in a PeopleSoft record definition. (Choose two.)
A. Image
B. Prompt
C. Character
D. Attachment
E. Long character
F. ImageReference
Answer: AE