"A script enabled browser is required for this page to function properly"

Oracle Certification

PeopleSoft Application Developer II: Application Engine & Integration

Sample Questions

View answers below

Sample questions are provided solely to familiarize candidates with the multiple-choice format and writing style of questions that will be found on the exam.  Sample questions may not cover the full spectrum of difficulty that is covered by the exam questions. Success on the sample questions does not predict success on the exam.

1. View the Exhibit.

On the Employee Review page, you have 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.

Which method will you use to meet this requirement?

  1. Use LOAD-LOOKUP to create a temporary lookup table
  2. Create two subpages, one for each option, and then use PeopleCode to determine which subpage to use
  3. Set a variable prompt table edit on Reviewer ID, and then use PeopleCode to determine which prompt table to use
  4. Use PeopleCode to build the SQL Select for a stand-alone rowset, and then associate Reviewer ID with the stand-alone rowset
  5. Use PeopleCode to build the SQL Select statement for a dynamic view, and then use the dynamic view as the prompt table for Reviewer ID

    1a "Exhibit"


2. PeopleSoft Application Engine program development is easier and more efficient because Application Engine Designer is integrated with PeopleSoft Application Designer.

Select four integrated Application Designer development tools that you can use to develop Application Engine programs. (Choose four)

  1. Find In …
  2. SQL Editor
  3. Process Monitor
  4. PeopleCode Editor
  5. PeopleCode Debugger
  6. Record Cross Reference
  7. PeopleSoft Process Scheduler
3. View the Exhibit and examine the fields in the record definition.

This is the state record for the PSU_CUST_CHG Application Engine program. How will PSU_CUST_CHG perform at run time?

  1. It will execute as expected
  2. It will abend (abnormal end) because the PROCESS_INSTANCE field is not on the record
  3. It will abend (abnormal end) because the FROM_CUSTOMER_ID and TO_CUSTOMER_ID fields are not keys
  4. It will execute but performance may be affected because the PROCESS_INSTANCE field is not on the record
  5. It will execute, but performance may be affected because the FROM_CUSTOMER_ID and TO_CUSTOMER_ID fields are not keys

    3a "Exhibit"



4. When does a Do Select loop stop?
  1. When a row is returned
  2. When there is a commit
  3. When the cursor is closed
  4. When no row is returned from the cursor
  5. When control is passed to the calling section
  6. When n rows are returned, where n is the value set in the commit frequency field
5. An Application Engine program uses the record DYNAMIC_AET as a state record. Can you use this state record with a dynamic call?
  1. Yes
  2. Yes, as long as it is the default state record
  3. Yes, as long as the call is to a section within the same program
  4. Yes, assuming the section name is passed in a Global variable
  5. No. An error occurs if the field AE_SECTION is not present
  6. No. An error occurs if the field AE_RUNCNTL is not present
  7. No. The field AE_APPLID must be a Number field

    5a "Exhibit"


6. Examine this Application Engine command line.

psae.exe -CT PARM1 -CD PARM2 -CO PARM3 -CP PARM4 -R PARM5 -I 327 -AI PARM6 -OT PARM7 -FP PARM8

Which option correctly matches the parameters with their descriptions?

  1. -AI = Program Name
    -CO = Operator ID
    -R  = Run Control ID
    -CD = Database Name
  2. -CT = Program Name
    -CD = Operator ID
    -R  = Run Control ID
    -CO = Database Name
  3. -FP = Program Name
    -I = Operator ID
    -CT = Run Control ID
    -CP = Database Name
  4. -AI = Program Name
    -CD = Operator ID
    -R  = Run Control ID
    -CT = Database Name
  5. -CT = Program Name
    -CO = Operator ID
    -I  = Run Control ID
    -CD = Database Name
7. Which three statements apply to rowset-based messages used in outbound service operations to other PeopleSoft systems? (Choose three)
  1. Schemas are not necessary
  2. A liases cannot be used for field names
  3. Aliases cannot be used for record names
  4. The PeopleSoft IBRequest format is used
8. You received a FIXED-format flat file from a third- party vendor. You created a file layout for the import. When you preview the data, you realize that there is a problem with the layout-a field appears to start in the middle of the data. What will you do to correct the problem?
  1. Add a new segment to the file layout
  2. Specify file record IDs that match the input file record
  3. Increase the field length to accommodate the input data
  4. Decrease the start position and adjust the field length to match the input data start position and length
9. Purchase orders entered on your PS Financial System need to be exported to a FIXED flat file for input into a third-party system. The tables are PO_HDR and PO_DTL, with PO_HDR being the parent and PO_DTL the child. 

Which are the five steps you need to perform to create the file layout and export the data from your Financial System? (Choose five)

  1. Write the application engine program to export the data
  2. Provide the import data in a correctly formatted flat file
  3. Create a file layout to match the record and field structure of the data
  4. Set the file layout properties to specify the file layout format of FIXED
  5. Preview and troubleshoot the input data format and content
  6. Enter File Record IDs on the File Layout Segment Properties
  7. Adjust the start position of all file fields after the start position of the File Record ID

Answers

  1.  C
  2.  ABDE
  3.  B
  4.  D
  5.  E
  6.  A
  7.  ADE
  8.  D
  9.  ACDFG