Act now and download your Oracle 1Z0-242 test today! Do not waste time for the worthless Oracle 1Z0-242 tutorials. Download Regenerate Oracle PeopleSoft Application Developer II: App Engine & Integration exam with real questions and answers and begin to learn Oracle 1Z0-242 with a classic professional.

2016 Nov 1Z0-242 test questions

Q11. - (Topic 0) 

Which two tasks do you need to complete after consuming a Web service? (Choose two.) 

A. Add a point-to-point routing. 

B. Add the appropriate OnRequest handler. 

C. Secure the service operation with a permission list. 

D. Write the PeopleCode to invoke the service operation. 

E. Update the connection properties on the service operation. 

Answer: C,D 


Q12. - (Topic 0) 

View the Exhibit, that shows the Run Archive page that you use to archive transactional service operation data in the messaging system. Based on the run control in the exhibit, what data will the system archive when you run the process? 

A. All synchronous service operations in the messaging system with a status of Done 

B. All asynchronous service operations in the messaging system with a status of Done or Cancel 

C. All synchronous and asynchronous service operations in the messaging system with a status of Error 

D. Only asynchronous and synchronous service operations in the messaging system with a status of Done or Cancel 

E. All asynchronous service operations in the messaging system with a status of Done or Cancel. In addition, the system will delete all synchronous service operations. 

Answer:


Q13. - (Topic 0) 

You created a component interface and now must implement it on an online component. The PeopleCode must instantiate the component interface. Which five steps are needed to instantiate the component interface? (Choose five) 

A. Establish a session with the %Session system variable. 

B. Establish a session with the Connect method. 

C. Use the GetCompIntfc method. 

D. Set key values. 

E. If the key uniquely defines a component interface, then execute the Find method. 

F. Get or set property values. 

G. Run the Cancel method and then the Save method. 

H. Run the Save method. 

Answer: A,C,D,F,H 


Q14. - (Topic 0) 

An Application Engine program has a Do While action with the following code: %SELECT (TEMP_FLD) 

SELECT 'COUNTER' 

FROM PS_INSTALLATION 

WHERE %Bind(COUNTER) < 1000; 

What will be the result? 

A. The program will abend because PS_INSTALLATION does not have a COUNTER field. 

B. The Do While action will go into an infinite loop because the Select statement will always return true. 

C. The actions following the Do While action will never execute because the Select will never return true. 

D. The Do While will execute at least once, no matter what the result of the Select. 

E. The Do While will execute as expected, as long as COUNTER is being incremented in PS_INSTALLATION for every loop. 

F. The Do While will execute as expected, as long as COUNTER is being incremented in the state record for every loop. 

Answer:


Q15. - (Topic 0) 

The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL. 

You tested the following SQL Select statement in your database query tool and it returned the expected results. (Line numbers have been added for clarity.) 

1.

 SELECT a.ORDER_LINE_NBR 

2.

 , a.ITEM_CD 

3.

 , a.QTY_ORDERED 

4.

 , b.QTY_ON_HAND 

5.

 FROM PS_PSU_ORDER_DTL a 

6.

 , PS_PSU_STOCK_TBL b 

7.

 WHERE a.ITEM_CD = b.ITEM_CD 

You copy and paste the SQL statement to a Do Select action, but it needs to be modified so that it populates the PSU_ORDERS_AET state record. 

What do you need to do? 

A. Change line 1 to: 

%SELECT a.ORDER_LINE_NBR 

B. Add this line before line 1: 

INSERT INTO PS_PSU_ORDERS_AET 

C. Add this line before line 1: 

%SELECT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

D. Add this line before line 1: 

%UPDATE (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

E. Add this line after line 7: 

%INSERT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

Answer:


Replace 1Z0-242 answers:

Q16. - (Topic 0) 

A Process Scheduler process is configured to run an Application Engine program. You need to modify the process to use parameters entered by the user at run time. Which four additional steps do you need to take? (Choose four.) 

A. Create a process type for the new process. 

B. Add bind variables to the command-line parameters. 

C. Write a PeopleCode program to pass the parameters. 

D. Create a state record with fields to pass input parameters. 

E. Create a run control page with fields to enter the input parameters. 

F. Create a run control record with fields to store the input parameters. 

G. Modify the Application Engine program to retrieve the input parameters. 

Answer: D,E,F,G 


Q17. - (Topic 0) 

You add a dynamic call to an Application Engine program following these steps: 

1. 

Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present. 

2. 

Build the state record. 

3. 

Verify that the state record is the default state record for the Application Engine 

program. 

4. 

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. 

5. 

Following the PeopleCode action, add a Call Section action. 

Select the correct statement. 

A. The Application Engine program will execute as expected. 

B. Step 2 is not needed for dynamic call. 

C. Step 3 is not needed. 

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

E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action. 

F. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call. 

Answer:


Q18. - (Topic 0) 

View the Exhibit. 

Note the Prompt Table field. 

Select the correct statement. 

A. %EDITTABLE allows a user to override standard system edits. 

B. %EDITTABLE allows the user select a prompt table at run time. 

C. %EDITTABLE is used to assign a prompt table based on a value in another field on the page. 

D. %EDITTABLE is meta-SQL that is used to filter prompt table values based on run-time values. 

E. %EDITTABLE is a system variable that resolves to a language-specific translate table at run time. 

Answer:


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

A. &RS_Item = GetRowSet(SCROLL.ITEM); 

B. &RS_Item = CreateRowSet(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 = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE); 

Answer: B,C,E 


Q20. - (Topic 0) 

Which two characteristics are required to create Transform type application engine programs? (Choose two). 

A. The Program Type is Transform Only. 

B. The Action Type is either XSLT or PeopleCode. 

C. You must set the Graphical Mapper option to Yes. 

D. You must define the psft_function in the application engine program. 

E. The input and output message names must be defined in the application engine program properties, even if Oracle Graphical Mapper is not used. 

Answer: A,B