Chinese(T) | English
contact me
User Login
Username:
Password :

PeopleSoft Application Developer II: App Engine & Integration

Index >> Oracle >> Other Oracle Certification >> "1Z0-242"Exam

VUE/Prometric Code:1Z0-242

Exam Name:PeopleSoft Application Developer II: App Engine & Integration
Questions and Answers:100 Q&As
Price:$99
Updated:2008-11-12
PeopleSoft Application Developer II: App Engine & Integration
Test Q&A Updated Price
1Z0-242 100 Q&A 2008-11-12 $99

please download in PDF format Demo: 1Z0-242

killtest 1Z0-242 Exam Features

High quality and Value for the 1Z0-242 Exam.
Killtest Practice Exams for PeopleSoft Application Developer II: App Engine & Integration 1Z0-242 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your Other Oracle Certification exam and get your Other Oracle Certification Certification.
We guarantee your success in the first attempt. If you do not pass the 1Z0-242 (PeopleSoft Application Developer II: App Engine & Integration) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

killtest 1Z0-242 Downloadable.
Printable Exams (in PDF format) Our Exam 1Z0-242 Preparation Material provides you everything you will need to take your Other Oracle Certification exam. The Other Oracle Certification Certification details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get Other Oracle Certification exam questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first Other Oracle Certification exam try, but also save your valuable time .

  • Comprehensive questions with complete details about 1Z0-242 exam.
  • 1Z0-242 exam questions accompanied by exhibits.
  • Verified Answers Researched by Industry Experts and almost 100% correct.
  • Drag and Drop questions as experienced in the Real Other Oracle Certification exam.
  • 1Z0-242 exam questions updated on regular basis.
  • Like actual Other Oracle Certification Certification exams, 1Z0-242 exam preparation is in multiple-choice questions (MCQs).
  • Tested by many real Other Oracle Certification exams before publishing.
  • Try free Other Oracle Certification exam demo before you decide to buy it in http://www.Killtest.com.

High quality and Value for the 1Z0-242 Exam:100% Guarantee to Pass Your Other Oracle Certification exam and get your Other Oracle Certification Certification.

http://www.Killtest.com The safer.easier way to get Other Oracle Certification Certification.

We offer Demo version of Q&A, Q&A are as follows (not to provide picture):

1Z0-242:please download 1Z0-242 in PDF format Demo 1Z0-242

1. Evaluate this PeopleCode snippet.
Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
&End is 200
B. &Result is 300
&End is Null
C. &Result is 300
&End is 300
D. &Result is Null
&End is 300
E. &Result is 100
&End is 300
Answer: A

2. Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
   &SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1",

PSU_TASK_TBL.TASK);
   &Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE

3. View the Exhibit.
 
An object-oriented PeopleCode program traverses the data buffer to get the value for Session

Number (SESSION_NBR) in the Session Details record (PSU_CRS_SESSN) on the Course Sessions

page.
The program uses a built-in function to instantiate the Level 0 object, then uses object

methods to instantiate the remaining data buffer objects.
Select the option that represents the order in which the program instantiates the data

buffer objects.
A. &Row_Level0, &Row _Level1, &Record, &Field
B. &Rowset_Level0, &Row_Level1, &Record, &Field
C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field
D. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field
Answer: D

4. 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: BCE

5. View the Exhibit.
 
On the Employee Review page, you have a business rule with these requirements:
1.  If Review Type is Supervisor, then the prompt for Reviewer ID returns only supervisors.
2.  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.)
A. Associate the REVIEWER_ID field with REVIEWER_VW.
B. Create REVIEWER_VW as a dynamic view of the EMPLOYEE table.
C. Add the DERIVED.EDITTABLE field to the page and make it invisible.
D. Set the prompt table edit for the REVIEWER_ID field to REVIEWER_VW.
E. Set the prompt table edit for the REVIEWER_ID field to DERIVED.%EDITTABLE.
F. Use a SQL Select statement in PeopleCode to populate the REVIEWER_VW view.
G. Use a conditional statement in PeopleCode to populate the DERIVED.EDITTABLE field.
Answer: CEG

6. You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER )

component. Which four steps are necessary? (Choose four.)
A. Start the PeopleCode Debugger and set a breakpoint.
B. Access the Structure view on the PSU_CUST_ORDER component.
C. In Application Designer, select Component Buffers.
D. Access the Customer Orders component in the browser and trigger the breakpoint. Return to

PeopleSoft Application Designer when the breakpoint triggers.
E. Open, or create, a PeopleCode program that will execute while Customer Orders is running

in the browser.
F. Drill down through the component hierarchy in the Structure view on the PSU_CUST_ORDER

component.
G. In Application Designer, select Debug, View Component Buffers.
Answer: ADEG

7. View the Exhibit.
 
Your client is upgrading its purchasing application to use object-oriented PeopleCode to

incorporate the benefits of application classes.
The PeopleCode for the Purchase Order application is now encapsulated in an Application

Package called PSU_PO. The assign_order_nbr function is now ORDER_NBR, a method of the ORDER

class.
You are tasked with modifying this program to call the new ORDER_NBR method.
Which four PeopleCode statements will you use in the new program? (Choose four.)
A. Class PSU_PO:ORDER;
B. &New.ORDER_NBR(PSU_PO_HDR.ORDER_NBR);
C. Import PSU_PO:ORDER;
D. Declare method PSU_PO:ORDER:ORDER_NBR;
E. &New = Create Order();
F. Local ORDER &New;
G. Method ORDER_NBR (&ORDER_NBR As Field out);
Answer: BCEF

8. You want to see exactly when a PeopleCode program fires in the context of the Component

Processor flow. Which two methods will work? (Choose two.)
A. Insert a Print() statement in the program.
B. Insert a WinMessage() statement in the program.
C. Insert a MessageCatalog() statement in the program.
D. Run the PeopleCode Debugger and insert a breakpoint on the program.
E. Run the PeopleCode Debugger and select Debug, View Component Buffers.
Answer: BD

9. View the Exhibit.
 
A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at

level 1.
Analyze this code snippet.
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_TaskRsrc;
Local Field & Fld_PctAvail ;
&RS_Level0 = GetLevel0();
&Row_Level0 = &RS_Level0.GetRow(1);
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
&Row_Level1 = &RS_Level1.GetRow(1);
&Rec_TaskRsrc = &Row_Level1.GetRecord(Record.PSU_Task_RSRC);
&Fld_PctAvail = &Rec_TaskRsrc.GetField(Field.PCT_AVAILABLE);
&Pct = &Fld_PctAvail.Value;
Select the correct option.
A. The program will produce the expected results.
B. The program is missing a loop to process each row in the level 1 rowset.
C. The program is missing a loop to process each rowset in the level 1 row.
D. The program can be simplified to:
&Pct = &RS_Level0.PSU_Task_RSRC.PCT_AVAILABLE.Value;
E. This line of code is not needed:
&RS_Level1 = &Row_Level0.GetRowset(Scroll.PSU_TASK_RSRC);
F. The &RS_Level0 = GetLevel0(); function is missing the Level 0 scroll name.
Answer: B

10. The Get Student Enrollments page uses a PeopleCode program to select and display rows

based on user input. When the user clicks Refresh, FieldChange PeopleCode populates a stand

-alone rowset using a Select method. When you test the program, the new rows are appended to

the previous rows instead of replacing them. How do you fix this problem?
A. Use a work scroll instead of a stand-alone rowset.
B. Add &Rowset.Flush(); after the Select method.
C. Use an Update method instead of a Select method.
D. Add &Rowset.Flush(); before the Select method.
E. Add &Rowset.Refresh (); after the Select method.
F. Add &Rowset.Refresh(); before the Select method.
Answer: D

11. Examine the join in this Select statement:
    SELECT A.TASK , B.EFFORT_AMT
    FROM PS_PROJECT A , PS_EFFORT B
    WHERE A.TASK = B.TASK
    AND A.RESOURCE = B.RESOURCE
Select the equivalent Select statement.
A. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(A.TASK, B.RESOURCE)
B. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Common(PROJECT A, EFFORT B)
C. SELECT A.TASK , B.EFFORT_AMT
FROM %Common(KEYS, PROJECT A, EFFORT B)
D. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT B)
E. SELECT A.TASK , B.EFFORT_AMT
FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)
Answer: E

12. 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: DEFG

13. View the Exhibit.
 
This run control page executes an Application Engine program that updates the Course table

using the parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)
A. A state record with fields to hold input parameters
B. Component variables to pass the input parameters
C. A data buffer object to retrieve the input parameters
D. Application Engine SQL to retrieve the input parameters
E. A PeopleCode record object to update the Course table
F. A Process Instance table to store run control parameters
G. A run control record with fields to store the input parameters
Answer: ADG

14. Select three Application Engine action types that can be used to control program flow.

(Choose three.)
A. Log Message
B. Call Section
C. XSLT
D. PeopleCode
E. Do While
F. Evaluate
Answer: BDE

15. You modify an Application Engine program to use parallel processing with temporary

tables.
The Application Engine program includes this code snippet, which is part of a SQL statement

that inserts rows into a temporary table.
INSERT INTO PS_CRS_FULL_TMP
What changes do you need to make to the code so that the Application Engine program will

implement parallel processing properly?
A. No changes to the code are needed as long as the temporary table has been properly

configured for parallel processing.
B. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the meta-

SQL resolves to the correct state record at run time.
C. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Table(CRS_FULL_TMP) so that the

system variables resolve to the correct syntax at run time.
D. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO %Table(CRS_FULL_TMP) so that the

meta-SQL resolves to the correct temporary table instance at run time.
E. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO %Temp(CRS_FULL_TMP) so that the

meta-SQL resolves to the correct syntax and temporary table instance at run time.
Answer: D

16. An Application Engine program uses a Do Select action. What occurs when the Select

statement is executed?
A. Each row returned by the Select statement is stored in the state record. The Select

statement continues until no more rows are returned. Then, the control passes to the calling

section.
B. All rows returned by the Select statement are stored in a cursor. Then, the control is

passed to the calling section.
C. All rows returned by the Select statement are stored in the state record. Then, the

control is passed to the next section in the program.
D. All rows returned by the Select statement are stored in a cursor. The first row is stored

in the state record. Then, the remaining actions in the step are processed sequentially.

Thereafter, the control returns to the Do Select to fetch another row, until no more rows

are returned.
E. When a row is returned, the remaining steps in the section execute and control returns to

the calling step.
F. When a row is returned, it is stored in the state record. Then, the control is passed to

the calling section.
Answer: D

17. An Application Engine program inserts rows into PS_VENDOR.
The program encounters an error and abends (ends abnormally).
You correct the error, but now PS_VENDOR is in an unknown state.
Select the correct statement.
A. If Log File was enabled in Configuration Manager, a script file was created that you use

to return the database to its original state. After you correct the error, you can run the

program again.
B. If Recover was enabled for the program, the changes to PS_VENDOR are rolled back. After

you correct the error, you can run the program again.
C. If Restart was enabled for the program, a checkpoint was saved with the last commit.

After you correct the error, you can restart the program and processing will resume from the

point of the last commit.
D. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes

processing after the condition that caused the error is corrected.
E. If a state record was defined for the program, PS_VENDOR is restored based on parameters

that were written to the state record. Then you can restart the program using the same run

control parameters.
Answer: C

18. How do you configure Process Scheduler to initiate an Application Engine trace for SQL

and Step?
A. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.
B. On the Run Control page, select the SQL Trace and Step Trace check boxes.
C. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.
D. On the Process Definition Override Options page, for Parameter List, select Append and

enter -TRACE 3.
E. On the Process Definition Override Options page, for Parameter List, select Append and

enter -TRACE SQL STEP.
F. On the Process Definition Override Options page, for Parameter List, select Append and

enter %%TRACE%% %%SQL%% %%STEP%%.
Answer: D

19. 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: E

20. An Application Engine program requires a loop that will exit after 1000 rows have been

processed. The COUNTER field in the state record is incremented in each iteration of the

loop. Which option contains code that could be used in a Do While action to test for

COUNTER?
A. Do While %Bind(Counter) < 1000
B. %SELECT (COUNTER)
FROM PS_INSTALLATION
Where COUNTER < 1000
C. If %Bind(Counter) >= 1000 then
Exit;
D. %Select(COUNTER)
FROM PS_STATE_AET
Where COUNTER < 1000
E. %Select(COUNTER)
SELECT 'X'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
Answer: E

21. View the Exhibit.
 
As the developer, what do you need to do to make this PeopleSoft Application Engine program

restartable?
A. Set the state record to derived/work.
B. Remove all section-level and step-level auto commits.
C. Nothing more. The Do Select action is set to Restartable.
D. Select the Disable Restart check box on the Program Properties page.
E. Deselect the Disable Restart check box on the Program Properties page.
Answer: E

22. You use a PeopleCode program to build a dynamic SQL Select statement for an Application

Engine program. Where would you place the PeopleCode program?
A. In a SQL action.
B. In a SQL definition.
C. In a PreBuild event.
D. In a Do While action.
E. In a Do Select action.
F. In a PeopleCode action.
Answer: F

23. View the Exhibit.
 
Which PeopleSoft Application Engine action is represented by the box labeled Test?
A. Do Select
B. Do While
C. Do Until
D. Do When
E. Do If
F. Do Loop
Answer: C

24. 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: BDF
25. View the Exhibit. Note the values in the CHKPOINT row.
 
This program is taking much longer to run than it needs to.
The ability to restart without compromising data integrity is crucial. The program has the

Disable Restart check box deselected.
What is one area of opportunity to cut processing time?
A. Reduce the frequency of commits.
B. Reduce the number of checkpoints by using Bulk Insert.
C. Replace section-level or step-level auto commits with explicit commits within SQL steps.
D. Use a derived/work record for the state record so that checkpoints are stored in memory

instead of in a SQL table.
E. PeopleCode records checkpoints much more quickly than SQL actions, so execute SQL using

PeopleCode actions wherever possible.
Answer: A

26. View the Exhibit.
 
You want to add trace parameters to an Application Engine command line.
Which trace parameters will trace steps, SQL, and PeopleCode?
A. TRACE 1 2 256
B. TRACE 1,2,256
C. TRACE (1,2,256)
D. TRACE 1 -TRACE 2 -TRACE 256
E. TRACE 259
F. TRACE 512
G. TRACE 12256
Answer: E

27. Set processing can improve Application Engine performance in many cases by ______.
A. caching selected rows in memory
B. using SQL to process groups of rows at one time
C. transferring SQL processing from the client to the application server
D. applying sophisticated data normalization algorithms based on set theory
E. using precompiled SQL in Application Engine libraries, rather than letting Application

Engine parse each statement
Answer: B

28. You add a button to a page to run an Application Engine program in synchronous mode. How

do you configure the button?
A. Associate the button with a run control record that passes parameters to Process

Scheduler to schedule the process.
B. Associate the button with FieldChange PeopleCode that uses a Process Request object to

schedule the process.
C. Associate the button with FieldChange PeopleCode that uses a CallAppEngine function to

launch the program.
D. Associate the button with an Application Engine PeopleCode action that passes parameters

to a Call Section action.
E. Associate the button with OnExecute PeopleCode that uses a PSAE command to launch the

program.
Answer: C

29. View the Exhibit.
 
This is the state record for the PSU_CUST_CHG Application Engine program.
How will selecting a Record Type of Derived/Work for the state record affect the program

PSU_CUST_CHG at run time?
A. It will execute as expected only if it does not update database tables.
B. It will execute as expected unless the program needs to be restarted.
C. It will execute, but performance could be improved by using SQL View.
D. It will abend (abnormal end) because the Record Type for a state record must be SQL

Table.
E. It will abend (abnormal end) because the Record Type for a state record must be Temporary

Table.
Answer: B

30. Select two uses of the Program Flow view in PeopleSoft Application Engine Designer.

(Choose two.)
A. Testing SQL statements
B. Ordering the steps in a program
C. Checking the syntax of PeopleCode
D. Viewing the expected sequence of steps
E. Viewing program flow during execution
F. Launching editors for SQL and PeopleCode
Answer: DF

31. View the Exhibit.
 
You want to reuse the code in this Application Engine program by making it available to

other Application Engine programs.
What must you do to use the program as a repository for PeopleSoft Application Engine

sections?
A. Delete the MAIN section.
B. Rename the MAIN section.
C. Use the suffix LIB in the program name.
D. Include at least one Call Section action.
E. Set Access to Public for at least one section.
F. Select the Application Library check box on the Advanced tabbed page of the PeopleSoft

Application Engine Properties dialog.
Answer: E

32. View the Exhibit.
 
You run an Application Engine program through Process Scheduler with Trace configured as

shown in the Exhibit.
What will the trace show? (Choose all that apply.)
A. SQL statements
B. Statement Timings
C. PeopleCode Detail Timings
D. Trace Each Statement in Program
E. Nothing. The program has to be run in two-tier mode.
F. Nothing. A PeopleTools Trace File must be specified.
Answer: E

33. 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: BCD

34. An Application Engine program section uses a SQL Select statement to select fields from

the CUST_ORDERS table, and then calls a section that uses a SQL Insert statement to update

the CUST_HISTORY table based on those fields. How are the field values passed between the

SQL statements?
A. By using state variables
B. By using a state record
C. By using a SQL view
D. By using meta variables
E. By using a SQL cursor
Answer: B

35. An Application Engine program has a SQL action with the following code:
INSERT INTO %Table(AETEST_TAO)
(PROCESS_INSTANCE
 , AE_INT_1
 , AE_APPLID
 , AE_SECTION)
SELECT %ProcessInstance
 , %Bind (AE_INT_1)
 , %AEProgram
 , %AESection
FROM PS_INSTALLATION
What is the purpose of the %Table construct?
A. %Table resolves to the correct state record.
B. %Table can improve performance by caching the table in memory.
C. %Table resolves to the assigned temporary table instance at run time.
D. %Table populates the state record with the results of the Select statement.
Answer: C

36. On the Service Operation definition page, the Introspection link is used to _____.
A. provide a Web service
B. consume a Web service
C. add a new service operation
D. add a new service operation version
E. add routing to existing service operation
Answer: E

37. 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: AE

38. You can use the ExecuteEdits method in handler code to _____.
A. call a component interface
B. invoke the standard system edits
C. execute a PeopleCode built-in function
D. call PeopleCode validation built-in functions
E. call an application engine program from the receiving process
Answer: B

39. View the Exhibit, which shows the file layout for SETID_FILE. You have been asked to

write the PeopleCode to export SETIDs to a flat file, along with an action row indicating

whether the action is an addition or a change. The resulting flat file will contain a row

indicating the action followed by a row containing transaction data. The PeopleCode will be

placed on the SETID_TBL.SETID.SavePostChange event.
 
Which set of statements will write both the AUDIT_ACTN and SETID_TBL rows to the file?
A. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRecord(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRowset(&rRec2);
B. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRecord(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRecord(&rRec2);
C. &SETID = SETID_TBL.SETID;
If %Mode = "A" Then
&rRec1.AUDIT_ACTN.Value = "A";
Else
&rRec1.AUDIT_ACTN.Value = "C";
End-If;
&SETIDOUT.WriteRowset(&rRec1);
&rRec2 = GetRecord();
&SETIDOUT.WriteRowset(&rRec2);
Answer: B

40. You have been asked to configure the Integration Gateway on your local Web server. You

entered the Gateway URL, loaded the connectors, and successfully pinged the Gateway. You

select the Domain Status page to activate your domain, however, you cannot find your domain

listed. To activate the domain, you need to _____.
A. reboot the Web server
B. purge the domain status
C. purge the application server cache
D. start Pub/Sub on the application server
E. use the Integration Broker Quick Configuration page
Answer: D

41. Component interface Find keys are mapped to ____.
A. all keys in a component search record
B. search keys in a component search record
C. duplicate order keys in a component search record
D. alternate search key in a component search record
E. search and alternate search keys in a component
Answer: E

42. Which type of message is most often used for PeopleSoft-to-PeopleSoft integrations?
A. Rowset-based message
B. Rowset-based message parts
C. Non-rowset-based message
D. Non-rowset-based message parts
Answer: A

43. View the Exhibit that shows the PeopleCode to publish the CUSTOMER service operation.

This code has been placed in the SavePostChange event in the CUSTOMER_ID field in the

PSU_CUST_TBL record. When a user updates the customer in the PeopleSoft Pure Internet

Architecture and saves the page, what data from the page will be copied into the message

structure?
 
A. The entire rowset
B. Only the rows of data at level 0
C. Only the rows of data at level 1
D. Only the rows of data that have changed in the rowset
E. The original values of the changed rows, as well as the rows of data that have changed
Answer: A

44. 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: AB

45. Which three URLs must be defined before you can create messages and schemas? (Choose

three.)
A. Inquiry URL
B. Publish URL
C. Target location
D. Service namespace
E. Schema namespace
Answer: CDE

46. You created a component interface and now must implement it on an online component. The

PeopleCode that triggers a component interface is placed on the SavePostChange event. Select

the three reasons for placing the PeopleCode on the SavePostChange event? (Choose three.)
A. SavePostChange event is not field dependent.
B. SavePostChange is initiated after the Component Processor updates the database.
C. SavePostChange is generally used to update tables that are not in the component.
D. An error or warning that is generated in SavePostChange causes the component interface to

be canceled, but the component data is saved.
E. The system issues a SQL commit after the SavePostChange terminates successfully.
Answer: BCE

47. Select three characteristics of the Default User ID field that you define for a node.

(Choose three.)
A. It is required for all nodes.
B. It is used for inbound service operations.
C. It is used for outbound service operations.
D. You specify a value for the field only when you set the authentication option to None.
E. It is used when a third party invokes a service operation without an authentication user

ID and password.
Answer: ABE

48. Published services are stored in the PeopleSoft database in the _____ table.
A. PSIBWSDL
B. PSIBPROFILE
C. PSIBUDDI_VW
D. PSIBRTNGDEFN
E. PSIBUDDISETUP
F. PSIBMSGSCHEMA
Answer: A

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

50. You created a component interface with the standard methods of Create, Find, Get,

Cancel, and Save. You secured the component interface and provided full access to all the

methods. You want to test the GET method to access the online information. Which three steps

will you use to test the GET method? (Choose three.)
A. Open the component interface in Application Designer.
B. Right-click in the component interface view and select Test Component Interface.
C. Save the data by selecting File, Save.
D. Use the Find option to test the GET method after supplying key values.
E. Use the Get Existing option to test the GET method after supplying key values.
F. Enter data in the Component Interface Tester tool.
G. Validate that the data has been modified and saved by accessing the online component or

using the database query tool.
Answer: ABE