1Z0-242 | Renewal Oracle 1Z0-242 exam dumps
Q11. - (Topic 0)
You are testing a new asynchronous service operation to send employee job data to another system; however, no operation instance is created. Select three possible causes. (Choose three.)
A. The sending node is paused.
B. The sending domain is not active.
C. No Publication PeopleCode exists.
D. Publication PeopleCode is incorrect.
E. No outbound routings exist for the service operation.
F. The service operation is not active on the receiving system.
Answer: C,D,E
Q12. - (Topic 0)
You have recently installed PeopleSoft HCM system. To populate employee information into the PERSON, ADDRESSES, and NAMES tables, you will read in an XML flat file from a non-PeopleSoft system.
PERSON is the parent table and ADDRESSES and NAMES are the child tables of PERSON.
Which two steps will you need to perform to create the file layout on the HCM system? (Choose two.)
A. Write the application engine program to export the data.
B. Provide the import data in a correctly formatted flat file.
C. Create a file layout to match the record and field structure of the data.
D. Set the file layout properties to specify the file layout format of XML.
E. Preview and troubleshoot the input data format and content.
F. Enter file record IDs on the file layout segment properties.
G. Adjust the start position of all file fields after the start position of the file record.
Answer: C,D
Q13. - (Topic 0)
An Application Engine program section uses a SQL Select statement to select fields from the CUST_ORDERS table, and then calls a section that uses a SQL Insert statement to update the CUST_HISTORY table based on those fields. How are the field values passed between the SQL statements?
A. By using state variables
B. By using a state record
C. By using a SQL view
D. By using meta variables
E. By using a SQL cursor
Answer: B
Q14. - (Topic 0)
You are asked to create a new service operation that will enable a third-party system to inquire on an item price and receive the response in real time. Which operation type would you use when you create the service operation?
A. Synchronous
B. Asynchronous one-way
C. Asynchronous-to-synchronous
D. Asynchronous request/response
Answer: A
Q15. - (Topic 0)
The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL.
You used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record.
You added a SQL action to update PS_PSU_STOCK_TBL using the values in the state record.
Which code would you use in the SQL action?
A. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %1 - %2
WHERE ITEM_CD = %3
(QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
B. %UPDATE (QTY_ON_HAND)
SELECT QTY_ON_HAND - QTY_ORDERED
FROM PS_PSU_STOCK_TBL
WHERE ITEM_CD = %Bind(ITEM_CD)
C. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind(QTY_ORDERED)
WHERE ITEM_CD = %Bind(ITEM_CD)
D. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind(QTY_ORDERED)
WHERE ITEM_CD = Bind(ITEM_CD)
E. %UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED)
WHERE ITEM_CD = %ITEM_CD
Answer: C
Q16. - (Topic 0)
View the Exhibit. This PeopleCode program disables the CHARGE_BACK field: Local Row &Row; &Row = GetRow(); &Row.PSU_TASK_EFFORT.CHARGE_BACK.Enabled = False; For this program to work as shown, what is the highest level at which it could be placed?
A. PSU_TASK_TBL (Table)
B. PSU_TASK_RSRC (Table)
C. PSU_TASK_EFFORT (Table)
D. CHARGE_BACK (Record Field)
E. PSU_TASK_RESOURCES (Component)
F. PSU_TASK_TBL (Table) - Search Record
Answer: C
Q17. - (Topic 0)
Which type of message is most often used for PeopleSoft-to-PeopleSoft integrations?
A. Rowset-based message
B. Rowset-based message parts
C. Non-rowset-based message
D. Non-rowset-based message parts
Answer: A
Q18. - (Topic 0)
An Application Engine program inserts rows into PS_VENDOR.
The program encounters an error and abends (ends abnormally).
You correct the error, but now PS_VENDOR is in an unknown state.
Select the correct statement.
A. If Log File was enabled in Configuration Manager, a script file was created that you use to return the database to its original state. After you correct the error, you can run the program again.
B. If Recover was enabled for the program, the changes to PS_VENDOR are rolled back. After you correct the error, you can run the program again.
C. If Restart was enabled for the program, a checkpoint was saved with the last commit. After you correct the error, you can restart the program and processing will resume from the point of the last commit.
D. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes processing after the condition that caused the error is corrected.
E. If a state record was defined for the program, PS_VENDOR is restored based on parameters that were written to the state record. Then you can restart the program using the same run control parameters.
Answer: C
Q19. - (Topic 0)
You created a component interface based on a component that has a parent and one non-effective-dated child (Level 0 and 1). You have been asked to write the PeopleCode to insert a new row in the collection if the row does not exist. In order to determine whether the row already exists, which method will you use?
A. InsertItem()
B. ItembyKeys()
C. CurrentItem()
D. GetEffectiveItem()
E. GetEffectiveItemNum()
Answer: B
Q20. - (Topic 0)
View the Exhibit.
This is the state record for the PSU_CUST_CHG Application Engine program.
How will selecting a Record Type of Derived/Work for the state record affect the program
PSU_CUST_CHG at run time?
A. It will execute as expected only if it does not update database tables.
B. It will execute as expected unless the program needs to be restarted.
C. It will execute, but performance could be improved by using SQL View.
D. It will abend (abnormal end) because the Record Type for a state record must be SQL Table.
E. It will abend (abnormal end) because the Record Type for a state record must be Temporary Table.
Answer: B