最新的Oracle 1Z0-242免費考試真題

問題1

You have recently installed PeopleSoft HCM system. To populate employee information into the PERSONS table from your legacy system, you will read in a CSV flat file.
Which are the four steps you need to create the file layout on the HCM system to import the data? (Choose four.)

A. Preview and troubleshoot the input data format and content.

B. Provide the import data in a correctly formatted flat file.

C. Set the File Record ID on the File Layout segment properties.

D. Create a file layout to match the record and field structure of the data.

E. Set the file layout properties to specify the file layout format of CSV.

F. Write the Application Engine program to export the data.

正確答案: A,B,D,E

問題2

What is required in order to use an Application Engine Call Section action to call a portion of another Application Engine program?

A. The called action is set to Public.

B. The called step is set to Public.

C. The Call Section action must specify the program name, section, and step.

D. The Call Section action must specify the program name and section.

E. A Call Section action can never call a portion of another Application Engine program.

F. The called program has Application Library selected in the program properties.

正確答案: D

問題3

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 Do Select action.

B. In a SQL action.

C. In a PreBuild event.

D. In a SQL definition.

E. In a Do While action.

F. In a PeopleCode action.

正確答案: F

問題4

What steps would you take to debug an Application Engine program using the PeopleSoft Application Engine debugger? (Choose all that apply.)

A. Execute the Application Engine program from Application Designer.

B. View the file DBG1.tmp in the Temp directory.

C. On the sign-on page, select the debug settings for PeopleSoft Application Engine Debug.

D. View the results in the Debugger window.

E. In Application Designer, select Debug, Application Engine Debug Mode.

F. View the Debug log in Process Monitor.

G. Select the Debug check box on the Process Scheduler tab in Configuration Manager.

正確答案: A,D,G

問題5

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

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 Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes processing after the condition that caused the error is corrected.

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

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

正確答案: A

問題6

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

C. Steps are the smallest unit of work that can be committed within a program.

D. All PeopleCode is executed using PeopleCode actions.

E. SQL Select statements can be used to control program flow.

正確答案: C,D,E

問題7

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.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);

C. &RS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);

D. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE);

E. &Price = &RS_Item(&i).ITEM.PRICE.Value;

F. &RS_Item = CreateRowSet(RECORD.ITEM);

正確答案: B,E,F

最新的Oracle PeopleSoft Application Developer II: App Engine and Integration - 1Z0-242免費考試真題

聯系我們

站內鏈接

最新更新