• Description:App Engine & Integration
• Passing Score:75%
• Practice Test - Number of questions:91 questions
• Simulation Test - Number of questions:91 questions
• Simulation Test Duration:90 minutes
• Has explanations:No

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

Answer(s)

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

&RS_Item = CreateRowSet(RECORD.ITEM);

&Price = &RS_Item(&i).ITEM.PRICE.Value;

&RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);