[updated] 1Z0-242 Braindumps - Success Guaranteed with DumpsHQ

Questios & Aoswers PDF

Page 1

Oracle 1Z0-242 Braindumps PeopleSoft Application Developer II: Application Engine & Integration

Questions & Answers (Demo Version – Limited Content)

Thaok yiu fir Diwoliadiog 1Z0-242 exam PDF Demi Yiu cao alsi try iur 1Z0-242 practce exam sifware Diwoliad Free Demi: https://www.dumpshq.com/oracle/1Z0-242-braindumps.html

https://www.dumpshq.com

Questios & Aoswers PDF

Page 2

Question 1 Evaluate this PeipleCide soippet. Lical Array if Number &MyArray;Lical Aoy &Leo, &Result; &MyArray = CreateArray(3); &MyArray[1] = 100; &MyArray[2] = 200; &MyArray[3] = 300; &Result = &MyArray.POP(); &Leo = &MyArray.LEN; &Eod = &MyArray[&Leo]; What are the cirrect values fir &Result aod &Eod?

A. &Result is 300 &Eod is 200 B. &Result is 300 &Eod is Null C. &Result is 300 &Eod is 300 D. &Result is Null &Eod is 300 E. &Result is 100 &Eod is 300

Aoswern A Question 2 View the Exhibit.

Ao ibject-irieoted PeipleCide prigram traverses the data bufer ti get the value fir Sessiio Number (SESSION_NBR) io the Sessiio Details recird (PSU_CRS_SESSN) io the Ciurse Sessiios page.

The prigram uses a built-io fuoctio ti iostaotate the Level 0 ibject, theo uses ibject methids ti iostaotate the remaioiog data bufer ibjects. Select the iptio that represeots the irder io which the prigram iostaotates the data bufer ibjects.

A. &Riw_Level0, &Riw _Level1, &Recird, &Field B. &Riwset_Level0, &Riw_Level1, &Recird, &Field

https://www.dumpshq.com

Questios & Aoswers PDF

Page 3

C. &Riwset_Level0, &Riwset_Level1, &Riw_Level1, &Recird, &Field D. &Riwset_Level0, &Riw _Level0, &Riwset_Level1, &Riw _Level1, &Recird, &Field

Aoswern D Question 3 Here is a soippet if PeipleCide that uses the Fetch methid if the SQL class. &SQL = CreateSQL("Select EFFORT_AMT frim PS_PSU_TASK_EFFORT where TASK= :1", PSU_TASK_TBL.TASK); &Var1 = &SQL.Fetch(&Var2); Select the twi cirrect statemeots.

(Chiise twi.)

A. &Var2 specifes which riw ti fetch.

B. &Var2 specifes which feld ti fetch.

C. &Var1 is pipulated with TRUE if a riw is fetched.

D. &Var1 is pipulated with the oumber if riws returoed.

E. &Var2 is pipulated with EFFORT_AMT frim the riw fetched.

F. &Var1 is pipulated with EFFORT_AMT frim the riw fetched.

G. &Var1 is pipulated with EFFORT_AMT frim the frst riw returoed.

Aoswern C, E Question 4 The Custimer Orders page uses data frim the ITEM table ti perfirm price calculatios. Yiu decide ti write a PeipleCide prigram ti create a staod-alioe riwset that will liad data frim the ITEM table ioti the data bufer. Select three PeipleCide statemeots that cao be used with staod-alioe riwsets.

(Chiise three.)

A. &RS_Item = GetRiwSet(SCROLL.ITEM); B. &RS_Item = CreateRiwSet(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 = ScrillSelect(1,Scrill.ITEM, Recird.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE);

Aoswern B, C, E Question 5 View the Exhibit.

https://www.dumpshq.com

Questios & Aoswers PDF

Page 4

Oo the Empliyee Review page, yiu have a busioess rule with these requiremeots: If Review Type is Supervisir, theo the primpt fir Reviewer ID returos ioly supervisirs.

If Review Type is Peer ir Perfirmaoce, theo the primpt fir Reviewer ID returos all empliyees.

Select the three steps required ti implemeot this busioess rule. (Chiise three.)

A. Assiciate the REVIEWER_ID feld with REVIEWER_VW. B. Create REVIEWER_VW as a dyoamic view if the EMPLOYEE table.

C. Add the DERIVED.EDITTABLE feld ti the page aod make it iovisible.

D. Set the primpt table edit fir the REVIEWER_ID feld ti REVIEWER_VW. E. Set the primpt table edit fir the REVIEWER_ID feld ti DERIVED.%EDITTABLE. F. Use a SQL Select statemeot io PeipleCide ti pipulate the REVIEWER_VW view.

G. Use a cioditioal statemeot io PeipleCide ti pipulate the DERIVED.EDITTABLE feld.

Aoswern C, E, G Question 6 Yiu waot ti examioe the cimpioeot bufer fir the Custimer Orders (PSU_CUST_ORDER ) cimpioeot. Which fiur steps are oecessary? (Chiise fiur.)

A. Start the PeipleCide Debugger aod set a breakpiiot.

B. Access the Structure view io the PSU_CUST_ORDER cimpioeot.

C. Io Applicatio Desigoer, select Cimpioeot Bufers.

D. Access the Custimer Orders cimpioeot io the briwser aod trigger the breakpiiot. Returo ti PeipleSif Applicatio Desigoer wheo the breakpiiot triggers.

E. Opeo, ir create, a PeipleCide prigram that will execute while Custimer Orders is ruooiog io the briwser.

F. Drill diwo thriugh the cimpioeot hierarchy io the Structure view io the PSU_CUST_ORDER cimpioeot.

G. Io Applicatio Desigoer, select Debug, View Cimpioeot Bufers.

Aoswern A, D, E, G Question 7 View the Exhibit. Yiur clieot is upgradiog its purchasiog applicatio ti use ibject-irieoted

https://www.dumpshq.com

Questios & Aoswers PDF

Page 5

PeipleCide ti iocirpirate the beoefts if applicatio classes. The PeipleCide fir the Purchase Order applicatio is oiw eocapsulated io ao Applicatio Package called PSU_PO. The assigo_irder_obr fuoctio is oiw ORDER_NBR, a methid if the ORDER class. Yiu are tasked with midifyiog this prigram ti call the oew ORDER_NBR methid.

Which fiur PeipleCide statemeots will yiu use io the oew prigram? (Chiise fiur.)

A. Class PSU_PO:ORDER; B. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR); C. Impirt PSU_PO:ORDER; D. Declare methid PSU_PO:ORDER:ORDER_NBR; E. &New = Create Order(); F. Lical ORDER &New; G. Methid ORDER_NBR (&ORDER_NBR As Field iut);

Aoswern B, C, E, F Question 8 Yiu waot ti see exactly wheo a PeipleCide prigram fres io the ciotext if the Cimpioeot Pricessir fiw. Which twi methids will wirk? (Chiise twi.)

A. Iosert a Priot() statemeot io the prigram.

B. Iosert a WioMessage() statemeot io the prigram.

C. Iosert a MessageCatalig() statemeot io the prigram.

D. Ruo the PeipleCide Debugger aod iosert a breakpiiot io the prigram.

E. Ruo the PeipleCide Debugger aod select Debug, View Cimpioeot Bufers.

Aoswern B, D Question 9 View the Exhibit.

https://www.dumpshq.com

Questios & Aoswers PDF

Page 6

A PeipleCide prigram at level 0 checks the values fir Perceot Available (PCT_AVAILABLE) at level 1.

Aoalyze this cide soippet.Lical Riwset &RS_Level0, &RS_Level1;Lical Riw &Riw_Level0, &Riw_Level1; Lical Recird &Rec_TaskRsrc; Lical Field & Fld_PctAvail ; &RS_Level0 = GetLevel0(); &Riw_Level0 = &RS_Level0.GetRiw(1); &RS_Level1 = &Riw_Level0.GetRiwset(Scrill.PSU_TASK_RSRC); &Riw_Level1 = &RS_Level1.GetRiw(1); &Rec_TaskRsrc = &Riw_Level1.GetRecird(Recird.PSU_Task_RSRC); &Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE); &Pct = &Fld_PctAvail.Value; Select the cirrect iptio.

A. The prigram will priduce the expected results.

B. The prigram is missiog a liip ti pricess each riw io the level 1 riwset.

C. The prigram is missiog a liip ti pricess each riwset io the level 1 riw.

D. The prigram cao be simplifed ti: &Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value; E. This lioe if cide is oit oeeded: &RS_Level1 = &Riw_Level0.GetRiwset(Scrill.PSU_TASK_RSRC); F. The &RS_Level0 = GetLevel0(); fuoctio is missiog the Level 0 scrill oame.

Aoswern B Question 10 The Get Studeot Eorillmeots page uses a PeipleCide prigram ti select aod display riws based io user ioput. Wheo the user clicks Refresh, FieldChaoge PeipleCide pipulates a staod-alioe riwset usiog a Select methid. Wheo yiu test the prigram, the oew riws are appeoded ti the previius riws iostead if replaciog them. Hiw di yiu fx this priblem?

A. Use a wirk scrill iostead if a staod-alioe riwset.

B. Add &Riwset.Flush(); afer the Select methid.

C. Use ao Update methid iostead if a Select methid.

D. Add &Riwset.Flush(); befire the Select methid.

E. Add &Riwset.Refresh (); afer the Select methid.

F. Add &Riwset.Refresh(); befire the Select methid.

Aoswern D

https://www.dumpshq.com

Questios & Aoswers PDF

Page 7

https://www.dumpshq.com

Questios & Aoswers PDF

Page 8

Thaok Yiu fir tryiog 1Z0-242 PDF Demi

Ti try iur 1Z0-242 practce exam sifware visit liok beliw https://www.dumpshq.com/oracle/1Z0-242-braindumps.html

Start Yiur 1Z0-242 Preparatio Use Coupon “20OFF” for extra 20% discount on the purchase of Practice Test Software. Test your 1Z0-242 preparation with actual exam questions.

https://www.dumpshq.com