• 首頁
• 考題分類
• 如何購買

PeopleSoft Application Developer II: App Engine & Integration

Other Oracle Certification 1Z0-242考試題庫由KillTest認證題庫網資深IT認證講師和Other Oracle Certification產品專家結合PROMETRIC或VUE的真實1Z0-242考試環境最新原題傾心打造。

題庫覆蓋了當前最新的真實考題，並且全部附有正確答案，我們承諾題庫對1Z0-242 Exam考試原題完整覆蓋。1Z0-242題庫助您輕鬆通過認證考試，一次不過全額退款。

Other Oracle Certification 1Z0-242(PeopleSoft Application Developer II: App Engine & Integration)考題由我們的資深IT認證講師和Other Oracle Certification產品專家精心打造，包括了當前最新的全套全真1Z0-242考題，全部附有正確答案。

所有購買KillTest 1Z0-242 題庫的客戶都將得到90天的免費升級服務，保證了對真實考試環境考題的完整覆蓋。KillTest IT認證題庫網助您一次通過Other Oracle Certification 1Z0-242 Exam考試。

1、本題庫源自合作考試中心的真實考試原題，截屏后由我們的專業團隊匯總整理，再經過合作培訓中心資深IT認證講師對考題校對，保證了 Killtest 題庫的專業品質，題庫試題正確率100%，對1Z0-242認證考試考題覆蓋率96％以上。您只需在參加Other Oracle Certification 1Z0-242 Exam前整體學習下本題庫，必定可以輕鬆完成考試，一次通過認證。

2、KillTest 實行“一次不過全額退款”承諾。如果您購買了我們的《1Z0-242 Exam》考題，只要不是首次通過，憑蓋有PROMETRIC或VUE考試中心鋼印的考試成績單，我們將退還您購買1Z0-242題庫的全部費用，絕對保證您的利益不受到任何的損失。(全額退款詳情)

3、作為台灣地區最專業的IT認證試題題庫提供商，我們提供完善的售後服務，我們對所有購買題庫的客戶提供跟蹤服務，在您購買考題后的90天內，享受免費升級考題服務，如果在這期間，考試中心對1Z0-242考題做出修改或變題，我們會在第一時間更新相關題庫，并免費提供給您更新下載。

PeopleSoft Application Developer II: App Engine & Integration(1Z0-242 Exam)屬於Other Oracle Certification認證考試中的一門，如果需要取得Other Oracle Certification證書，您可能還需要參加其他相關考試，詳情可訪問Other Oracle Certification認證專題，在那裡，你將看到所有Other Oracle Certification認證相關考試科目。

下载1Z0-242考试题库演示部分（PDF格式）

1Z0-242题库部分演示（DEMO）

1. Evaluate this PeopleCode snippet.
Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
　&End is 200
B. &Result is 300
　&End is Null
C. &Result is 300
　&End is 300
D. &Result is Null
　&End is 300
E. &Result is 100
　&End is 300
Answer: A

2. Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
   &SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1", PSU_TASK_TBL.TASK);
   &Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE

3. View the Exhibit.

An object-oriented PeopleCode program traverses the data buffer to get the value for Session Number (SESSION_NBR) in the Session Details record (PSU_CRS_SESSN) on the Course Sessions page.
The program uses a built-in function to instantiate the Level 0 object, then uses object methods to instantiate the remaining data buffer objects.
Select the option that represents the order in which the program instantiates the data buffer objects.
A. &Row_Level0, &Row _Level1, &Record, &Field
B. &Rowset_Level0, &Row_Level1, &Record, &Field
C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field
D. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field
Answer: D

4. The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to write a PeopleCode program to create a stand-alone rowset that will load data from the ITEM table into the data buffer. Select three PeopleCode statements that can be used with stand-alone rowsets. (Choose three.)
A. &RS_Item = GetRowSet(SCROLL.ITEM);
B. &RS_Item = CreateRowSet(RECORD.ITEM);
C. &Price = &RS_Item(&i).ITEM.PRICE.Value;
D. &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
E. &RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
F. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE);
Answer: BCE

5. View the Exhibit.

On the Employee Review page, you have a business rule with these requirements:
1.  If Review Type is Supervisor, then the prompt for Reviewer ID returns only supervisors.
2.  If Review Type is Peer or Performance, then the prompt for Reviewer ID returns all employees.
Select the three steps required to implement this business rule. (Choose three.)
A. Associate the REVIEWER_ID field with REVIEWER_VW.
B. Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
C. Add the DERIVED.EDITTABLE field to the page and make it invisible.
D. Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
E. Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
F. Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
G. Use a conditional statement in PeopleCode to populate the DERIVED.EDITTABLE field.
Answer: CEG

6. You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER ) component. Which four steps are necessary? (Choose four.)
A. Start the PeopleCode Debugger and set a breakpoint.
B. Access the Structure view on the PSU_CUST_ORDER component.
C. In Application Designer, select Component Buffers.
D. Access the Customer Orders component in the browser and trigger the breakpoint. Return to PeopleSoft Application Designer when the breakpoint triggers.
E. Open, or create, a PeopleCode program that will execute while Customer Orders is running in the browser.
F. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER component.
G. In Application Designer, select Debug, View Component Buffers.
Answer: ADEG

7. View the Exhibit.

Your client is upgrading its purchasing application to use object-oriented PeopleCode to incorporate the benefits of application classes.
The PeopleCode for the Purchase Order application is now encapsulated in an Application Package called PSU_PO. The assign_order_nbr function is now ORDER_NBR, a method of the ORDER class.
You are tasked with modifying this program to call the new ORDER_NBR method.
Which four PeopleCode statements will you use in the new program? (Choose four.)
A. Class PSU_PO:ORDER;
B. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR);
C. Import PSU_PO:ORDER;
D. Declare method PSU_PO:ORDER:ORDER_NBR;
E. &New = Create Order();
F. Local ORDER &New;
G. Method ORDER_NBR (&ORDER_NBR As Field out);
Answer: BCEF

8. You want to see exactly when a PeopleCode program fires in the context of the Component Processor flow. Which two methods will work? (Choose two.)
A. Insert a Print() statement in the program.
B. Insert a WinMessage() statement in the program.
C. Insert a MessageCatalog() statement in the program.
D. Run the PeopleCode Debugger and insert a breakpoint on the program.
E. Run the PeopleCode Debugger and select Debug, View Component Buffers.
Answer: BD

9. 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: B

10. The Get Student Enrollments page uses a PeopleCode program to select and display rows based on user input. When the user clicks Refresh, FieldChange PeopleCode populates a stand-alone rowset using a Select method. When you test the program, the new rows are appended to the previous rows instead of replacing them. How do you fix this problem?
A. Use a work scroll instead of a stand-alone rowset.
B. Add &Rowset.Flush(); after the Select method.
C. Use an Update method instead of a Select method.
D. Add &Rowset.Flush(); before the Select method.
E. Add &Rowset.Refresh (); after the Select method.
F. Add &Rowset.Refresh(); before the Select method.
Answer: D

11. 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: E

12. A Process Scheduler process is configured to run an Application Engine program. You need to modify the process to use parameters entered by the user at run time. Which four additional steps do you need to take? (Choose four.)
A. Create a process type for the new process.
B. Add bind variables to the command-line parameters.
C. Write a PeopleCode program to pass the parameters.
D. Create a state record with fields to pass input parameters.
E. Create a run control page with fields to enter the input parameters.
F. Create a run control record with fields to store the input parameters.
G. Modify the Application Engine program to retrieve the input parameters.
Answer: DEFG

13. View the Exhibit.

This run control page executes an Application Engine program that updates the Course table using the parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)
A. A state record with fields to hold input parameters
B. Component variables to pass the input parameters
C. A data buffer object to retrieve the input parameters
D. Application Engine SQL to retrieve the input parameters
E. A PeopleCode record object to update the Course table
F. A Process Instance table to store run control parameters
G. A run control record with fields to store the input parameters
Answer: ADG

14. Select three Application Engine action types that can be used to control program flow. (Choose three.)
A. Log Message
B. Call Section
C. XSLT
D. PeopleCode
E. Do While
F. Evaluate
Answer: BDE

15. You modify an Application Engine program to use parallel processing with temporary tables.
The Application Engine program includes this code snippet, which is part of a SQL statement that inserts rows into a temporary table.
INSERT INTO PS_CRS_FULL_TMP
What changes do you need to make to the code so that the Application Engine program will implement parallel processing properly?
A. No changes to the code are needed as long as the temporary table has been properly configured for parallel processing.
B. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the meta-SQL resolves to the correct state record at run time.
C. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Table(CRS_FULL_TMP) so that the system variables resolve to the correct syntax at run time.
D. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO %Table(CRS_FULL_TMP) so that the meta-SQL resolves to the correct temporary table instance at run time.
E. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Temp(CRS_FULL_TMP) so that the meta-SQL resolves to the correct syntax and temporary table instance at run time.
Answer: D

16. An Application Engine program uses a Do Select action. What occurs when the Select statement is executed?
A. Each row returned by the Select statement is stored in the state record. The Select statement continues until no more rows are returned. Then, the control passes to the calling section.
B. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the calling section.
C. All rows returned by the Select statement are stored in the state record. Then, the control is passed to the next section in the program.
D. All rows returned by the Select statement are stored in a cursor. The first row is stored in the state record. Then, the remaining actions in the step are processed sequentially. Thereafter, the control returns to the Do Select to fetch another row, until no more rows are returned.
E. When a row is returned, the remaining steps in the section execute and control returns to the calling step.
F. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.
Answer: D

17. 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

18. 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: D

19. 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

20. An Application Engine program requires a loop that will exit after 1000 rows have been processed. The COUNTER field in the state record is incremented in each iteration of the loop. Which option contains code that could be used in a Do While action to test for COUNTER?
A. Do While %Bind(Counter) < 1000
B. %SELECT (COUNTER)
FROM PS_INSTALLATION
Where COUNTER < 1000
C. If %Bind(Counter) >= 1000 then
　Exit;
D. %Select(COUNTER)
FROM PS_STATE_AET
Where COUNTER < 1000
E. %Select(COUNTER)
SELECT 'X'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
Answer: E

21. View the Exhibit.

As the developer, what do you need to do to make this PeopleSoft Application Engine program restartable?
A. Set the state record to derived/work.
B. Remove all section-level and step-level auto commits.
C. Nothing more. The Do Select action is set to Restartable.
D. Select the Disable Restart check box on the Program Properties page.
E. Deselect the Disable Restart check box on the Program Properties page.
Answer: E

22. You use a PeopleCode program to build a dynamic SQL Select statement for an Application Engine program. Where would you place the PeopleCode program?
A. In a SQL action.
B. In a SQL definition.
C. In a PreBuild event.
D. In a Do While action.
E. In a Do Select action.
F. In a PeopleCode action.
Answer: F

23. 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: C

24. 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: BDF
25. View the Exhibit. Note the values in the CHKPOINT row.

This program is taking much longer to run than it needs to.
The ability to restart without compromising data integrity is crucial. The program has the Disable Restart check box deselected.
What is one area of opportunity to cut processing time?
A. Reduce the frequency of commits.
B. Reduce the number of checkpoints by using Bulk Insert.
C. Replace section-level or step-level auto commits with explicit commits within SQL steps.
D. Use a derived/work record for the state record so that checkpoints are stored in memory instead of in a SQL table.
E. PeopleCode records checkpoints much more quickly than SQL actions, so execute SQL using PeopleCode actions wherever possible.
Answer: A

26. 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

27. Set processing can improve Application Engine performance in many cases by ______.
A. caching selected rows in memory
B. using SQL to process groups of rows at one time
C. transferring SQL processing from the client to the application server
D. applying sophisticated data normalization algorithms based on set theory
E. using precompiled SQL in Application Engine libraries, rather than letting Application Engine parse each statement
Answer: B

28. You add a button to a page to run an Application Engine program in synchronous mode. How do you configure the button?
A. Associate the button with a run control record that passes parameters to Process Scheduler to schedule the process.
B. Associate the button with FieldChange PeopleCode that uses a Process Request object to schedule the process.
C. Associate the button with FieldChange PeopleCode that uses a CallAppEngine function to launch the program.
D. Associate the button with an Application Engine PeopleCode action that passes parameters to a Call Section action.
E. Associate the button with OnExecute PeopleCode that uses a PSAE command to launch the program.
Answer: C

29. 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

30. Select two uses of the Program Flow view in PeopleSoft Application Engine Designer. (Choose two.)
A. Testing SQL statements
B. Ordering the steps in a program
C. Checking the syntax of PeopleCode
D. Viewing the expected sequence of steps
E. Viewing program flow during execution
F. Launching editors for SQL and PeopleCode
Answer: DF

KillTest IT認證題庫網專業提供Other Oracle Certification 1Z0-242 Exam 最新題庫下載，完全覆蓋1Z0-242考試原題。1Z0-242:PeopleSoft Application Developer II: App Engine & Integration

全部考試

640-802,000-514,310-065

密碼：

注冊賬號