File Info
| Exam | PeopleSoft Application Developer II: Application Engine & Integration |
| Number | 1z0-242 |
| File Name | Oracle.1z0-242.PracticeTest.2017-01-19.63q.tqb |
| Size | 2 MB |
| Posted | Jan 19, 2017 |
| Download | Oracle.1z0-242.PracticeTest.2017-01-19.63q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
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.)
- &RS_Item = GetRowSet(SCROLL.ITEM);
- &RS_Item = CreateRowSet(RECORD.ITEM);
- &Price = &RS_Item(&i).ITEM.PRICE.Value;
- &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
- &RS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
- &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.)
- Associate the REVIEWER_ID field with REVIEWER_VW.
- Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
- Add the DERIVED.EDITTABLE field to the page and make it invisible.
- Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
- Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
- Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
- 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.)
- Start the PeopleCode Debugger and set a breakpoint.
- Access the Structure view on the PSU_CUST_ORDER component.
- In Application Designer, select Component Buffers.
- Access the Customer Orders component in the browser and trigger the breakpoint. Return to PeopleSoft Application Designer when the breakpoint triggers.
- Open, or create, a PeopleCode program that will execute while Customer Orders is running in the browser.
- Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER component.
- In Application Designer, select Debug, View Component Buffers
Correct answer: ADEG
