Download Oracle.1z0-242.PracticeTest.2017-01-19.63q.vcex

Download Exam

File Info

Exam PeopleSoft Application Developer II: Application Engine & Integration
Number 1z0-242
File Name Oracle.1z0-242.PracticeTest.2017-01-19.63q.vcex
Size 2 MB
Posted Jan 19, 2017
Download Oracle.1z0-242.PracticeTest.2017-01-19.63q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 1

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


  1. &RS_Item = GetRowSet(SCROLL.ITEM);
  2. &RS_Item = CreateRowSet(RECORD.ITEM);
  3. &Price = &RS_Item(&i).ITEM.PRICE.Value;
  4. &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
  5. &RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
  6. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE);
Correct answer: BCE



Question 2

View the Exhibit.
  
   
On the Employee Review page, you have a business rule with these requirements: 
If Review Type is Supervisor, then the prompt for Reviewer ID returns only supervisors.  
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.)


  1. Associate the REVIEWER_ID field with REVIEWER_VW.
  2. Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
  3. Add the DERIVED.EDITTABLE field to the page and make it invisible.
  4. Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
  5. Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
  6. Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
  7. Use a conditional statement in PeopleCode to populate the DERIVED.EDITTABLE field.
Correct answer: CEG



Question 3

You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER ) component. Which four steps are necessary? (Choose four.)


  1. Start the PeopleCode Debugger and set a breakpoint.
  2. Access the Structure view on the PSU_CUST_ORDER component.
  3. In Application Designer, select Component Buffers.
  4. Access the Customer Orders component in the browser and trigger the breakpoint. Return to PeopleSoft Application Designer when the breakpoint triggers.
  5. Open, or create, a PeopleCode program that will execute while Customer Orders is running in the browser.
  6. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER component.
  7. In Application Designer, select Debug, View Component Buffers
Correct answer: ADEG



Question 4

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


  1. Class PSU_PO:ORDER;
  2. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR);
  3. Import PSU_PO:ORDER;
  4. Declare method PSU_PO:ORDER:ORDER_NBR;
  5. &New = Create Order();
  6. Local ORDER &New;
  7. Method ORDER_NBR (&ORDER_NBR As Field out);
Correct answer: BCEF



Question 5

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


  1. Insert a Print() statement in the program.
  2. Insert a WinMessage() statement in the program.
  3. Insert a MessageCatalog() statement in the program.
  4. Run the PeopleCode Debugger and insert a breakpoint on the program.
  5. Run the PeopleCode Debugger and select Debug, View Component Buffers.
Correct answer: BD



Question 6

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.


  1. The program will produce the expected results.
  2. The program is missing a loop to process each row in the level 1 rowset.
  3. The program is missing a loop to process each rowset in the level 1 row.
  4. The program can be simplified to: &Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value;
  5. This line of code is not needed: &RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
  6. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name.
Correct answer: B



Question 7

An Application Engine program uses a Do Select action. What occurs when the Select statement is executed?


  1. 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.
  2. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the calling section.
  3. 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.
  4. 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.
  5. When a row is returned, the remaining steps in the section execute and control returns to the calling step.
  6. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.
Correct answer: D



Question 8

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.


  1. 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.
  2. 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.
  3. 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.
  4. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes processing after the condition that caused the error is corrected.
  5. 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.
Correct answer: C



Question 9

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


  1. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.
  2. On the Run Control page, select the SQL Trace and Step Trace check boxes.
  3. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.
  4. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE 3.
  5. On the Process Definition Override Options page, for Parameter List, select Append and enter –TRACE SQL STEP.
  6. On the Process Definition Override Options page, for Parameter List, select Append and enter %%TRACE%% %%SQL%% %%STEP%%.
Correct answer: D



Question 10

You add a dynamic call to an Application Engine program following these steps: 
Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present.  
Build the state record.  
Verify that the state record is the default state record for the Application Engine program.  
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.  
Following the PeopleCode action, add a Call Section action. Select the correct statement.


  1. The Application Engine program will execute as expected.
  2. Step 2 is not needed for dynamic call.
  3. Step 3 is not needed.
  4. 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.
  5. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.
  6. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call.
Correct answer: E









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files