[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-242 Dumps with VCE and PDF 1-10

2018 Jan Oracle Official New Released 1z0-242
100% Free Download! 100% Pass Guaranteed!

PeopleSoft Application Developer II:App Engine amp; Integration

Question No: 1 – (Topic 0)

Evaluate this PeopleCode snippet.

Local Array of Number amp;MyArray; Local Any amp;Len, amp;Result;

amp;MyArray = CreateArray(3);

amp;MyArray[1] = 100;

amp;MyArray[2] = 200;

amp;MyArray[3] = 300;

amp;Result = amp;MyArray.POP();

amp;Len = amp;MyArray.LEN;

amp;End = amp;MyArray[amp;Len];

What are the correct values for amp;Result and amp;End?

  1. amp;Result is 300

    amp;End is 200

  2. amp;Result is 300

    amp;End is Null

  3. amp;Result is 300

    amp;End is 300

  4. amp;Result is Null

    amp;End is 300

  5. amp;Result is 100

amp;End is 300

Answer: A

Question No: 2 – (Topic 0)

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.

Ensurepass 2018 PDF and VCE

  1. amp;Row_Level0, amp;Row _Level1, amp;Record, amp;Field

  2. amp;Rowset_Level0, amp;Row_Level1, amp;Record, amp;Field

  3. amp;Rowset_Level0, amp;Rowset_Level1, amp;Row_Level1, amp;Record, amp;Field

  4. amp;Rowset_Level0, amp;Row _Level0, amp;Rowset_Level1, amp;Row _Level1, amp;Record, amp;Field

Answer: D

Question No: 3 – (Topic 0)

Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.

amp;SQL = CreateSQL(quot;Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1quot;, PSU_TASK_TBL.TASK);

amp;Var1 = amp;SQL.Fetch(amp;Var2);

Select the two correct statements. (Choose two.)

  1. amp;Var2 specifies which row to fetch.

  2. amp;Var2 specifies which field to fetch.

  3. amp;Var1 is populated with TRUE if a row is fetched.

  4. amp;Var1 is populated with the number of rows returned.

  5. amp;Var2 is populated with EFFORT_AMT from the row fetched.

  6. amp;Var1 is populated with EFFORT_AMT from the row fetched.

  7. amp;Var1 is populated with EFFORT_AMT from the first row returned.

Answer: C,E

Question No: 4 – (Topic 0)

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. amp;RS_Item = GetRowSet(SCROLL.ITEM);

  2. amp;RS_Item = CreateRowSet(RECORD.ITEM);

  3. amp;Price = amp;RS_Item(amp;i).ITEM.PRICE.Value;

  4. amp;RS_Item.Select(quot;Where ITEM = :1quot;, CUST_ORDER.ITEM);

  5. amp;RS_Item.Fill(quot;Where CUST_TYPE = :1quot;, CUST_ORDER.TYPE);

  6. amp;RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, (quot;Where CUST_TYPE = :1quot;, CUST_ORDER. CUST_TYPE);

    Answer: B,C,E

    Question No: 5 – (Topic 0)

    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


      Select the three steps required to implement this business rule. (Choose three.)

      Ensurepass 2018 PDF and VCE

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

      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.

Answer: C,E,G

Question No: 6 – (Topic 0)

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.

Answer: A,D,E,G

Question No: 7 – (Topic 0)

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.

Ensurepass 2018 PDF and VCE

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;


  3. Import PSU_PO:ORDER;

  4. Declare method PSU_PO:ORDER:ORDER_NBR;

  5. amp;New = Create Order();

  6. Local ORDER amp;New;

  7. Method ORDER_NBR (amp;ORDER_NBR As Field out);

Answer: B,C,E,F

Question No: 8 – (Topic 0)

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.

Answer: B,D

Question No: 9 – (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 amp;RS_Level0, amp;RS_Level1; Local Row amp;Row_Level0, amp;Row_Level1; Local Record amp;Rec_TaskRsrc;

Local Field amp; Fld_PctAvail ;

amp;RS_Level0 = GetLevel0();

amp;Row_Level0 = amp;RS_Level0.GetRow(1);

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

amp;Row_Level1 = amp;RS_Level1.GetRow(1);

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

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

amp;Pct = amp;Fld_PctAvail.Value; Select the correct option.

Ensurepass 2018 PDF and VCE

  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:

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

  5. This line of code is not needed:

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

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

Answer: B

Question No: 10 – (Topic 0)

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?

  1. Use a work scroll instead of a stand-alone rowset.

  2. Add amp;Rowset.Flush(); after the Select method.

  3. Use an Update method instead of a Select method.

  4. Add amp;Rowset.Flush(); before the Select method.

  5. Add amp;Rowset.Refresh (); after the Select method.

  6. Add amp;Rowset.Refresh(); before the Select method.

Answer: D

100% Free Download!
Download Free Demo:1z0-242 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-242 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Reply