Oracle 1Z0-242 問題集

質問 1：
An Application Engine program is structured with sections, steps, and actions. Which two statements are correct? (Choose two.)
A. Sections execute sequentially.
B. Steps can call other programs.
C. Sections are ordered alphabetically following MAIN.
D. Steps execute alphabetically within a program.
E. Steps can call other steps.
正解：B,C

質問 2：
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. Provide the import data in a correctly formatted flat file.
B. Set the File Record ID on the File Layout segment properties.
C. Set the file layout properties to specify the file layout format of CSV.
D. Create a file layout to match the record and field structure of the data.
E. Preview and troubleshoot the input data format and content.
F. Write the Application Engine program to export the data.
正解：A,C,D,E

質問 3：
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 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.
B. 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.
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 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.
E. 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.
正解：D

質問 4：
Your customer asks you to evaluate an Application Engine program that she thinks is taking too long.
You suggest that set processing may improve the Application Engine program performance.
Select three reasons why you think set processing will help. (Choose three.)
A. Set processing selects only the rows that will be processed, rather than using conditional constructs to determine which rows to process.
B. Set processing uses stored procedures, which are more efficient than Application Engine SQL.
C. Set processing uses load balancing to distribute processing across multiple servers.
D. Set processing reduces network traffic by making fewer server trips.
E. Set processing transfers much of the processing work from Application Engine to the RDBMS, where there is less processing overhead.
F. Set processing reuses SQL statements where possible, which reduces overhead significantly.
正解：A,D,E

質問 5：
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. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field
B. &Row_Level0, &Row _Level1, &Record, &Field
C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field
D. &Rowset_Level0, &Row_Level1, &Record, &Field
正解：A