1Z0-242 | What Precise 1Z0-242 braindumps Is?

Q31. - (Topic 0) 

View the Exhibit. 

You want to add trace parameters to an Application Engine command line. 

Which trace parameters will trace steps, SQL, and PeopleCode? 

A. TRACE 1 2 256 

B. TRACE 1,2,256 

C. TRACE (1,2,256) 

D. TRACE 1 -TRACE 2 -TRACE 256 

E. TRACE 259 

F. TRACE 512 

G. TRACE 12256 

Answer: E 

Q32. - (Topic 0) 

What steps would you take to debug an Application Engine program using the PeopleSoft Application Engine debugger? (Choose all that apply.) 

A. View the Debug log in Process Monitor. 

B. View the results in the Debugger window. 

C. View the file DBG1.tmp in the Temp directory. 

D. Execute the Application Engine program from Application Designer. 

E. In Application Designer, select Debug, Application Engine Debug Mode. 

F. Select the Debug check box on the Process Scheduler tab in Configuration Manager. 

G. On the sign-on page, select the debug settings for PeopleSoft Application Engine Debug. 

Answer: B,D,F 

Q33. - (Topic 0) 

You created a component interface based on a component that has a parent PSU_STUDENT_TBL and one non-effective-dated child record PSU_STUDENT_EXP. 

The component interface PeopleCode was created by a developer and a snippet of that PeopleCode is as follows: 

&oPsuStudentExpCollection = &oStuProfile2.PSU_STUDENT_EXP; &item = &oPsuStudentExpCollection.ItemByKeys("PT"); 

If &item <> Null Then 

&j = &item.ItemNum; 

&oPsuStudentExp = &oPsuStudentExpCollection.Item(&j);

 If &oPsuStudentExp.SKILL = "PT" And &oPsuStudentExp.PROFICIENCY = "L" 

Then 

&oPsuStudentExp.PROFICIENCY = "M"; 

End-If; 

Else 

&oPsuStudentExp = &oPsuStudentExpCollection.InsertItem(1); 

&oPsuStudentExp.SKILL = "PT"; 

&oPsuStudentExp.PROFICIENCY = "M"; 

&oPsuStudentExp.DATE_LAST_MAINT = PSU_CRS_SESSN.END_DATE; 

End-If; 

Which statement best describes what this snippet of PeopleCode is trying to accomplish? 

A. Inserts a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT values, if SKILL is not equal to T 

B. Insert a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT values, if SKILL is equal to T 

C. Inserts a child row and sets the SKILL, PROFICIENCY and DATE_LAST_MAINT values, if SKILL is equal to "PT" and PROFICENCY is equal to 

D. Modifies the PROFICIENCY of a child row if SKILL is T and PROFICIENCY is for that row 

E. Modifies the value of PROFICIENCY of the child row in which SKILL is T and PROFCIENCY is , else if SKILL is not T inserts a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT value 

Answer: E 

77. - (Topic 0) 

View the Exhibit that shows the PeopleCode used to publish the LOCATION_SYNC service operation. This code has been placed in the SavePostChange event in the SETID field in the LOCATION_TBL record. When a user updates the location in the PeopleSoft Pure Internet Architecture and saves the page, what data from the page will be copied into the message structure? 

A. The entire rowset 

B. Only the rows of data at level 0 

C. Only the rows of data at level 1 

D. Only the rows of data that have changed in the rowset 

E. The original values of the changed rows, as well as the rows of data that have changed 

Answer: D 

Q34. - (Topic 0) 

The Application Engine program PSU_PROC_CRSE has a Do Select action with the following code: 

%Select (COURSE, EFFDT, DESCR, TOOLS_REL) 

SELECT COURSE

 , EFFDT

 , DESCR

 , TOOLS_REL

FROM PS_PSU_COURSE_TBL A

 WHERE A.EFFDT <= (SELECT MAX(A1.EFFDT) 

FROM PS_PSU_COURSE_TBL A1 

WHERE A1.COURSE = A.COURSe 

AND A1.EFFDT <= GETDATE()) 

The program works fine in testing, but it fails when run on an Oracle database platform. 

Select the two approaches that will resolve the problem and give the expected results. (Choose two.) 

A. Delete the Where clause. 

B. Change the WHERE clause to WHERE A.EFFDT = MAX(EFFDT). 

C. Change the SELECT clause to SELECT DISTINCT. 

D. Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn). 

E. Replace the GETDATE() function with the %CurrentDateIn system variable. 

F. Select the Active check box on the step so that the PeopleSoft Application Engine automatically selects the current row. 

Answer: D,E 

Q35. - (Topic 0) 

You add a dynamic call to an Application Engine program following these steps: 

1. 

Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present. 

2. 

Build the state record. 

3. 

Verify that the state record is the default state record for the Application Engine 

program. 

4. 

In a PeopleCode action, use a conditional test to populate the fields AE_APPLID and AE_SECTION with an Application Engine program name and section name, respectively. 

5. 

Following the PeopleCode action, add a Call Section action. 

Select the correct statement. 

A. The Application Engine program will execute as expected. 

B. Step 2 is not needed for dynamic call. 

C. Step 3 is not needed. 

D. Add a step after step 5 to insert a SQL action that will use the values in the state record to populate the Program and Section fields of the Application Engine Call Section action. 

E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action. 

F. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call. 

Answer: E 

Q36. - (Topic 0) 

View the Exhibit. 

You want to reuse the code in this Application Engine program by making it available to other Application Engine programs. 

What must you do to use the program as a repository for PeopleSoft Application Engine sections? 

A. Delete the MAIN section. 

B. Rename the MAIN section. 

C. Use the suffix LIB in the program name. 

D. Include at least one Call Section action. 

E. Set Access to Public for at least one section. 

F. Select the Application Library check box on the Advanced tabbed page of the PeopleSoft Application Engine Properties dialog. 

Answer: E 

Q37. - (Topic 0) 

An Application Engine batch program processes one million credit card transactions. The program takes four hours to complete. You have been tasked with reducing that time to two hours. You decide to use parallel processing because with parallel processing _________. 

A. you effectively double your network bandwidth 

B. you can distribute processing to multiple database servers 

C. you reduce network traffic by transferring SQL processing to the database engine 

D. you can run the program asynchronously instead of synchronously and reduce database table contention 

E. you can divide the job into several sets of transactions, and process each set using different temporary tables 

Answer: E 

Q38. - (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 tested the following SQL Select statement in your database query tool and it returned the expected results. (Line numbers have been added for clarity.) 

1.

 SELECT a.ORDER_LINE_NBR 

2.

 , a.ITEM_CD 

3.

 , a.QTY_ORDERED 

4.

 , b.QTY_ON_HAND 

5.

 FROM PS_PSU_ORDER_DTL a 

6.

 , PS_PSU_STOCK_TBL b 

7.

 WHERE a.ITEM_CD = b.ITEM_CD 

You copy and paste the SQL statement to a Do Select action, but it needs to be modified so that it populates the PSU_ORDERS_AET state record. 

What do you need to do? 

A. Change line 1 to: 

%SELECT a.ORDER_LINE_NBR 

B. Add this line before line 1: 

INSERT INTO PS_PSU_ORDERS_AET 

C. Add this line before line 1: 

%SELECT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

D. Add this line before line 1: 

%UPDATE (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

E. Add this line after line 7: 

%INSERT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

Answer: C 

Q39. - (Topic 0) 

View the Exhibit, which shows Code Set Values. You will be using these code set values for the ORDER_STATUS field between System A (sender) and System B (recipient). 

Which code set group, based on the data displayed in the exhibit, needs to be associated with System A? 

A. TRAINING 

B. PO_STATUS 

C. PARTICIPANT 

D. RTN_STATUS 

Answer: A 

Q40. - (Topic 0) 

View the Exhibit. 

You run an Application Engine program through Process Scheduler with Trace configured as shown in the Exhibit. 

What will the trace show? (Choose all that apply.) 

A. SQL statements 

B. Statement Timings 

C. PeopleCode Detail Timings 

D. Trace Each Statement in Program 

E. Nothing. The program has to be run in two-tier mode. 

F. Nothing. A PeopleTools Trace File must be specified. 

Answer: E