Oracle 1Z0-242 Actual PDF : PeopleSoft Application Developer II: App Engine and Integration

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

Examine this PeopleCode snippet:
&SQL = CreateSQL("Select %EffDtCheck(EFFDT) from %Table(PSU_INSTR_TBL)");
Select the correct option.

• A. The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %Current(EFFDT) from %Table(PSU_INSTR_TBL)");
• B. The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %CurrDate(EFFDT) from %Table(PSU_INSTR_TBL)");
• C. The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %DateIn(EFFDT) from %Table(PSU_INSTR_TBL)");
• D. The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %DateOut(EFFDT) from %Table(PSU_INSTR_TBL)");
• E. The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %Date(EFFDT) from %Table(PSU_INSTR_TBL)");
• F. The statement is valid.

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. Save the data by selecting File, Save.
• B. Open the component interface in Application Designer.
• C. Enter data in the Component Interface Tester tool.
• 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. Validate that the data has been modified and saved by accessing the online component or using the database query tool.
• G. Right-click in the component interface view and select Test Component Interface.

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.

An Application Engine program uses a Do Select action. What occurs when the Select statement is executed?

• A. When a row is returned, the remaining steps in the section execute and control returns to the calling step.
• B. 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.
• C. 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.
• D. 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.
• E. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.
• F. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the calling section.