Exam Code: 1Z0-242 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: PeopleSoft Application Developer II: App Engine & Integration
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-242 Exam.

2017 Feb 1Z0-242 practice test

Q1. - (Topic 0) 

You are expecting a flat file from a third-party system. The file contains information to populate a table on your HCM system. But the data being supplied will contain only a few of the record fields in the PERSON table defined in your HCM system. Further, the file has a control file field that will indicate whether to add, change, or update the information. 

The file format is: 

999 A /* Indicates the action to take */ 

001 1000 Smith,John 123 Easy Street Easy City CA /*Actual Data*/ 999 C 

001 1020 Jones, Tom 1024 Hard Life Street Hardknocks NJ 

Which are the two choices to define the file layout? (Choose two.) 

A. The file layout will contain two segments. One using the record field PSCAMA.AUDIT_ACTN and the other the record fields from PERSON - EMPLID, NAME, STREET, CITY, and STATE. 

B. The file layout will contain one segment for PSCAMA.AUDIT_ACTN and one child segment for PERSON. 

C. The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 001. 

D. The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 999 and for PERSON 001. 

E. The File Record ID in the File Layout Segment Properties for the PSCAMA segment will be 999 and no File Record ID is needed for PERSON. 

Answer: A,D 


Q2. - (Topic 0) 

You have been asked to import a CSV file. You create the file layout definition for the record structure and enter your default file name on the Preview tab. When you preview the file, only the first column of the preview grid is populated. What will you do to correct this problem? 

A. change the file layout format to match the input file 

B. specify file record IDs that match the input file records 

C. increase the field length to accommodate the input data 

D. change the definition delimiter to match the one that is used in the input file 

E. decrease the start position and adjust the field length to match the input data start position and length 

Answer:


Q3. - (Topic 0) 

You have been asked to create an application class to consume the asynchronous service operation ADD_COURSE. The requirements state that you should execute all the standard edits for COURSE_TBL and throw an exception if an error occurs. 

Complete the second line in this code:

 If &msg.IsEditError Then 

_______________________________

 Exit (1); 

A. %IntBroker.SetStatus(&msg,%Operation_New) 

B. %IntBroker.SetStatus(&msg,%Operation_Canceled) 

C. %IntBroker.SetStatus(&msg,%Operation_Error) 

D. &MyErrors = %IntBroker.GetMessageErrors(&TransactionId); 

Answer:


Q4. - (Topic 0) 

You created a component interface and now must implement it on an online component. 

The PeopleCode that triggers a component interface is placed on the SavePostChange event. Select the three reasons for placing the PeopleCode on the SavePostChange event? (Choose three.) 

A. SavePostChange event is not field dependent. 

B. SavePostChange is initiated after the Component Processor updates the database. 

C. SavePostChange is generally used to update tables that are not in the component. 

D. An error or warning that is generated in SavePostChange causes the component interface to be canceled, but the component data is saved. 

E. The system issues a SQL commit after the SavePostChange terminates successfully. 

Answer: B,C,E 


Q5. - (Topic 0) 

View the Exhibit. 

A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at level 1. 

Analyze this code snippet. 

Local Rowset &RS_Level0, &RS_Level1; 

Local Row &Row_Level0, &Row_Level1; 

Local Record &Rec_TaskRsrc; 

Local Field & Fld_PctAvail ; 

&RS_Level0 = GetLevel0(); 

&Row_Level0 = &RS_Level0.GetRow(1); 

&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC); 

&Row_Level1 = &RS_Level1.GetRow(1); 

&Rec_TaskRsrc = &Row_Level1.GetRecord(Record.PSU_Task_RSRC); 

&Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE); 

&Pct = &Fld_PctAvail.Value; 

Select the correct option. 

A. The program will produce the expected results. 

B. The program is missing a loop to process each row in the level 1 rowset. 

C. The program is missing a loop to process each rowset in the level 1 row. 

D. The program can be simplified to: 

&Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value; 

E. This line of code is not needed: 

&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC); 

F. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name. 

Answer:


Most up-to-date 1Z0-242 exam:

Q6. - (Topic 0) 

View the Exhibit. 

Which PeopleSoft Application Engine action is represented by the box labeled Test? 

A. Do Select 

B. Do While 

C. Do Until 

D. Do When 

E. Do If 

F. Do Loop 

Answer:


Q7. - (Topic 0) 

When you service-enable a component interface, the request message shape for the Get method contains _____. 

A. Get keys 

B. Find keys 

C. Object key 

D. CI buffer structure 

E. Find key collection 

Answer:

19. - (Topic 0) 

Examine the join in this Select statement: 

SELECT A.TASK , B.EFFORT_AMT

 FROM PS_PROJECT A , PS_EFFORT B

 WHERE A.TASK = B.TASK 

AND A.RESOURCE = B.RESOURCE 

Select the equivalent Select statement. 

A. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Join(A.TASK, B.RESOURCE) 

B. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Common(PROJECT A, EFFORT B) 

C. SELECT A.TASK , B.EFFORT_AMT 

FROM %Common(KEYS, PROJECT A, EFFORT B) 

D. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT 

B) 

E. SELECT A.TASK , B.EFFORT_AMT 

FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B) 

Answer:


Q8. - (Topic 0) 

Which three URLs must be defined before you can create messages and schemas? (Choose three.) 

A. Inquiry URL 

B. Publish URL 

C. Target location 

D. Service namespace 

E. Schema namespace 

Answer: C,D,E 


Q9. - (Topic 0) 

Your customer presents you with a requirement for an Application Engine program that performs massive updates to reporting tables based on each day transactions. The requirements are: The Application Engine program must complete all processing within a four-hour window. 

In the event of an abend, there must be a way for the program to resume processing where it stopped. 

What are your three design considerations? (Choose three.) 

A. Using a state record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend. 

B. Using a run control record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend. 

C. If the program commits frequently, less work will be lost if a restart is needed. However, each commit takes processing time. 

D. If the program commits frequently, fewer benchmarks are needed, which saves time. However, more work must be redone if a restart is needed. 

E. If the Disable Restart checkbox is selected for an Application program, processing time is reduced because Application Engine does not record checkpoints. However, the developer must build restart logic into the program. 

F. If the Disable Restart check box is not selected, derived/work state record field values are stored to PS_AERUNCONTROL before each commit. However, using a derived/work state record improves processing speed. 

Answer: A,C,E 


Q10. - (Topic 0) 

How do you configure Process Scheduler to initiate an Application Engine trace for SQL and Step? 

A. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type. 

B. On the Run Control page, select the SQL Trace and Step Trace check boxes. 

C. On the Process Monitor page, select the SQL Trace and Step Trace check boxes. 

D. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE 3. 

E. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE SQL STEP. 

F. On the Process Definition Override Options page, for Parameter List, select Append and enter %%TRACE%% %%SQL%% %%STEP%%. 

Answer: