It is impossible to pass Oracle 1Z0-242 exam without any help in the short term. Come to Pass4sure soon and find the most advanced, correct and guaranteed Oracle 1Z0-242 practice questions. You will get a surprising result by our Updated PeopleSoft Application Developer II: App Engine & Integration practice guides.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-242 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-242 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-242-exam-dumps.html
Q1. - (Topic 0)
An Application Engine program incorporates PeopleCode and SQL. Which three statements are correct? (Choose three.)
A. All SQL statements are executed using SQL actions.
B. All PeopleCode is executed using PeopleCode actions.
C. SQL Select statements can be used to control program flow.
D. Steps are the smallest unit of work that can be committed within a program.
E. If a program executes a step with a SQL Insert or Update statement, it must also execute a step with a Commit action before completion.
Answer: B,C,D
Q2. - (Topic 0)
Which two modifications can you make to an individual component interface property? (Choose two.)
A. Change the name.
B. Set up synchronization.
C. Add a user-defined method.
D. Expose a standard method.
E. Make the property read-only.
Answer: A,E
Q3. - (Topic 0)
You created a component interface based on a component that has a parent PSU_CRS_SESSN and one non-effective-dated child record PSU_STU_ENROLL.
The component interface PeopleCode was created by a developer and a snippet of that PeopleCode is as follows:
&oPsuStuEnrollCollection = &oPsuCrsEnroll.PSU_STU_ENROLL;
For &i = 1 To &oPsuStuEnrollCollection.Count
&oPsuStuEnroll = &oPsuStuEnrollCollection.Item(&i);
If &oPsuStuEnroll.ENROLL_STATUS = "ENR" then
&oPsuStuEnroll.ENROLL_STATUS = "RES";
End-if
End-For;
Which statement best describes what this snippet of PeopleCode is trying to accomplish?
A. Inserts a child row if ENROLL_STATUS = ENR
B. Modifies each child row in which ENROLL_STATUS =ENR
C. Inserts a child row if any row has ENROLL_STATUS = ENR
D. Modifies each child row if any row has ENROLL_STATUS = ENR
Answer: B
Q4. - (Topic 0)
View the Exhibit that shows the message tree structure for the STUDENT_INFO message. Based on this structure, which two statements describe the message? (Choose two.)
A. This is a rowset-based message.
B. Student is an alias for the record.
C. This is a non-rowset-based message.
D. The alias for this message is Student.
E. The description for the STUDENT_ID field is ID.
F. The EMPHASIS field is included in the message.
Answer: A,B
Q5. - (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 used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record.
You added a SQL action to update PS_PSU_STOCK_TBL using the values in the state record.
Which code would you use in the SQL action?
A. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %1 - %2
WHERE ITEM_CD = %3
(QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
B. %UPDATE (QTY_ON_HAND)
SELECT QTY_ON_HAND - QTY_ORDERED
FROM PS_PSU_STOCK_TBL
WHERE ITEM_CD = %Bind(ITEM_CD)
C. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind(QTY_ORDERED)
WHERE ITEM_CD = %Bind(ITEM_CD)
D. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind(QTY_ORDERED)
WHERE ITEM_CD = Bind(ITEM_CD)
E. %UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED)
WHERE ITEM_CD = %ITEM_CD
Answer: C
Q6. - (Topic 0)
The Application Engine program PSU_PROC_CRSE has a Do Select action with the following code:
%Select (COURSE, EFFDT, DESCR, TOOLS_REL)
SELECT COURSE
, EFFDT
, DESCR
, TOOLS_REL
FROM PS_PSU_COURSE_TBL A
WHERE A.EFFDT <= (SELECT MAX(A1.EFFDT)
FROM PS_PSU_COURSE_TBL A1
WHERE A1.COURSE = A.COURSe
AND A1.EFFDT <= GETDATE())
The program works fine in testing, but it fails when run on an Oracle database platform.
Select the two approaches that will resolve the problem and give the expected results. (Choose two.)
A. Delete the Where clause.
B. Change the WHERE clause to WHERE A.EFFDT = MAX(EFFDT).
C. Change the SELECT clause to SELECT DISTINCT.
D. Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn).
E. Replace the GETDATE() function with the %CurrentDateIn system variable.
F. Select the Active check box on the step so that the PeopleSoft Application Engine automatically selects the current row.
Answer: D,E
Q7. - (Topic 0)
View the Exhibit, which displays your file layout for a purchase order. In your application engine program to export the data to a file, which statement will instantiate the rowset?
A. &rowset=CreateRowset(Record.PSU_PO_HDR),CreateRowset(Record.PSU_PO_DTL);
B. &rowset=CreateRowset(Record.PSU_PO_HDR,CreateRowset(Record.PSU_PO_DTL));
C.
&rowset1=CreateRowset(Record.PSU_PO_HDR);&rowset2=CreateRowset(Record.PSU_ PO_DTL);
D. &MYFILE.SetFileLayout(FileLayout.PO_FILE);
E. &MYFILE = GetFile("E:\temp\PO_OUT.txt", "W", %FilePath_Absolute);
Answer: B
Q8. - (Topic 0)
View the Exhibit, which shows the WS Security page for the BPEL node definition. You have consumed a Web service from the node BPEL that requires WS Security. On the Node Definitions page, you have entered PTTOOLS as the default user ID, DEMO as the external user ID, and DEMO as the external user password.
Based on this configuration, which user ID and password will be included in the SOAP header?
A. No SOAP header is added
B. DEMO as the user ID and no password
C. PTTOOLS as the user ID and no password
D. DEMO as the user ID and DEMO as the password
E. PTTOOLS as the user ID and PTTOOLS as the password
Answer: D
Q9. - (Topic 0)
Logical transformations are required to _____.
A. send or receive a nonrowset-based message
B. alias the current version of the service operation
C. send or receive a service operation using an alias
D. send or receive nondefault versions of a service operation
E. change the message for the current version of the service operation
Answer: D
Q10. - (Topic 0)
What steps would you take to debug an Application Engine program using the PeopleSoft Application Engine debugger? (Choose all that apply.)
A. View the Debug log in Process Monitor.
B. View the results in the Debugger window.
C. View the file DBG1.tmp in the Temp directory.
D. Execute the Application Engine program from Application Designer.
E. In Application Designer, select Debug, Application Engine Debug Mode.
F. Select the Debug check box on the Process Scheduler tab in Configuration Manager.
G. On the sign-on page, select the debug settings for PeopleSoft Application Engine Debug.
Answer: B,D,F