Our pass rate is high to 98.9% and the similarity percentage between our 1Z0-242 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1Z0-242 exam in just one try? I am currently studying for the Oracle 1Z0-242 exam. Latest Oracle 1Z0-242 Test exam practice questions and answers, Try Oracle 1Z0-242 Brain Dumps First.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-242 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q11. - (Topic 0)
Your customer presents you with a requirement for an Application Engine program that performs massive updates to reporting tables based on each day transactions. The requirements are: The Application Engine program must complete all processing within a four-hour window.
In the event of an abend, there must be a way for the program to resume processing where it stopped.
What are your three design considerations? (Choose three.)
A. Using a state record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend.
B. Using a run control record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend.
C. If the program commits frequently, less work will be lost if a restart is needed. However, each commit takes processing time.
D. If the program commits frequently, fewer benchmarks are needed, which saves time. However, more work must be redone if a restart is needed.
E. If the Disable Restart checkbox is selected for an Application program, processing time is reduced because Application Engine does not record checkpoints. However, the developer must build restart logic into the program.
F. If the Disable Restart check box is not selected, derived/work state record field values are stored to PS_AERUNCONTROL before each commit. However, using a derived/work state record improves processing speed.
Q12. - (Topic 0)
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.
Q13. - (Topic 0)
Examine this PeopleCode snippet:
&SQL = CreateSQL("Select %EffDtCheck(EFFDT) from %Table(PSU_INSTR_TBL)");
Select the correct option.
A. The statement is valid.
B. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %DateIn(EFFDT) from %Table(PSU_INSTR_TBL)");
C. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %DateOut(EFFDT) from %Table(PSU_INSTR_TBL)");
D. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %CurrDate(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 not valid. The correct syntax is:
&SQL = CreateSQL("Select %Current(EFFDT) from %Table(PSU_INSTR_TBL)");
Q14. - (Topic 0)
The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL. You used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record. You added a SQL action to update PS_PSU_STOCK_TBL using the values in the state record. Which code would you use in the SQL action?
A. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %1 - %2
WHERE ITEM_CD = %3
(QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
B. %UPDATE (QTY_ON_HAND)
SELECT QTY_ON_HAND - QTY_ORDERED
WHERE ITEM_CD = %Bind(ITEM_CD)
C. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind(QTY_ORDERED)
WHERE ITEM_CD = %Bind(ITEM_CD)
D. UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind(QTY_ORDERED)
WHERE ITEM_CD = Bind(ITEM_CD)
E. %UPDATE PS_PSU_STOCK_TBL
SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED)
WHERE ITEM_CD = %ITEM_CD
Q15. - (Topic 0)
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
Q16. - (Topic 0)
You have been asked to import a CSV file. You create the file layout definition for the record structure and enter your default file name on the Preview tab. When you preview the file, only the first column of the preview grid is populated. What will you do to correct this problem?
A. change the file layout format to match the input file
B. specify file record IDs that match the input file records
C. increase the field length to accommodate the input data
D. change the definition delimiter to match the one that is used in the input file
E. decrease the start position and adjust the field length to match the input data start position and length
Q17. - (Topic 0)
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.
Q18. - (Topic 0)
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.
48. - (Topic 0)
An Application Engine program is structured with sections, steps, and actions. Which two statements are correct? (Choose two.)
A. Steps can call other steps.
B. Sections execute sequentially.
C. Steps can call other programs.
D. Steps execute alphabetically within a program.
E. Sections are ordered alphabetically following MAIN.
Q19. - (Topic 0)
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.
Q20. - (Topic 0)
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