[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-242 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-242
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-242.html

PeopleSoft Application Developer II:App Engine amp; Integration

Question No: 11 – (Topic 0)

Examine the join in this Select statement:

SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT B WHERE A.TASK = B.TASK

AND A.RESOURCE = B.RESOURCE

Select the equivalent Select statement.

  1. SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT B WHERE %Join(A.TASK, B.RESOURCE)

  2. SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT B

    WHERE %Common(PROJECT A, EFFORT B)

  3. SELECT A.TASK , B.EFFORT_AMT

    FROM %Common(KEYS, PROJECT A, EFFORT B)

  4. SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT B

    WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT B)

  5. SELECT A.TASK , B.EFFORT_AMT

FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)

Answer: E

Question No: 12 – (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.)

  1. Create a process type for the new process.

  2. Add bind variables to the command-line parameters.

  3. Write a PeopleCode program to pass the parameters.

  4. Create a state record with fields to pass input parameters.

  5. Create a run control page with fields to enter the input parameters.

  6. Create a run control record with fields to store the input parameters.

  7. Modify the Application Engine program to retrieve the input parameters.

Answer: D,E,F,G

Question No: 13 – (Topic 0)

View the Exhibit.

This run control page executes an Application Engine program that updates the Course table using the parameters entered by a user.

In addition to the run control page, which three elements must be in place? (Choose three.)

Ensurepass 2018 PDF and VCE

  1. A state record with fields to hold input parameters

  2. Component variables to pass the input parameters

  3. A data buffer object to retrieve the input parameters

  4. Application Engine SQL to retrieve the input parameters

  5. A PeopleCode record object to update the Course table

  6. A Process Instance table to store run control parameters

  7. A run control record with fields to store the input parameters

Answer: A,D,G

Question No: 14 – (Topic 0)

Select three Application Engine action types that can be used to control program flow. (Choose three.)

  1. Log Message

  2. Call Section

  3. XSLT

  4. PeopleCode

  5. Do While

  6. Evaluate

Answer: B,D,E

Question No: 15 – (Topic 0)

You modify an Application Engine program to use parallel processing with temporary tables.

The Application Engine program includes this code snippet, which is part of a SQL statement that inserts rows into a temporary table.

INSERT INTO PS_CRS_FULL_TMP

What changes do you need to make to the code so that the Application Engine program will implement parallel processing properly?

  1. No changes to the code are needed as long as the temporary table has been properly configured for parallel processing.

  2. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO PS_CRS_FULL_TMP so that the meta-SQL resolves to the correct state record at run time.

  3. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO

    %Table(CRS_FULL_TMP) so that the system variables resolve to the correct syntax at run time.

  4. Replace INSERT INTO PS_CRS_FULL_TMP with INSERT INTO

    %Table(CRS_FULL_TMP) so that the meta-SQL resolves to the correct temporary table instance at run time.

  5. Replace INSERT INTO PS_CRS_FULL_TMP with %INSERT INTO

%Temp(CRS_FULL_TMP) so that the meta-SQL resolves to the correct syntax and temporary table instance at run time.

Answer: D

Question No: 16 – (Topic 0)

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

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

  2. All rows returned by the Select statement are stored in a cursor. Then, the control is

    passed to the calling section.

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

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

  5. When a row is returned, the remaining steps in the section execute and control returns to the calling step.

  6. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section.

Answer: D

Question No: 17 – (Topic 0)

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.

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

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

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

  4. If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes processing after the condition that caused the error is corrected.

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

Answer: C

Question No: 18 – (Topic 0)

How do you configure Process Scheduler to initiate an Application Engine trace for SQL and Step?

  1. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.

  2. On the Run Control page, select the SQL Trace and Step Trace check boxes.

  3. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.

  4. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE 3.

  5. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE SQL STEP.

  6. On the Process Definition Override Options page, for Parameter List, select Append and enter %%TRACE%% %%SQL%% %%STEP%%.

    Answer: D

    Question No: 19 – (Topic 0)

    You add a dynamic call to an Application Engine program following these steps:

    1. Add the fields AE_APPLID and AE_SECTION to the state record if they are not already present.

    2. Build the state record.

    3. Verify that the state record is the default state record for the Application Engine program.

    4. In a PeopleCode action, use a conditional test to populate the fields AE_APPLID and AE_SECTION with an Application Engine program name and section name, respectively.

    5. Following the PeopleCode action, add a Call Section action.

      Select the correct statement.

      1. The Application Engine program will execute as expected.

      2. Step 2 is not needed for dynamic call.

      3. Step 3 is not needed.

      4. Add a step after step 5 to insert a SQL action that will use the values in the state record to populate the Program and Section fields of the Application Engine Call Section action.

      5. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.

      6. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call.

Answer: E

Question No: 20 – (Topic 0)

An Application Engine program requires a loop that will exit after 1000 rows have been processed. The COUNTER field in the state record is incremented in each iteration of the loop. Which option contains code that could be used in a Do While action to test for COUNTER?

  1. Do While %Bind(Counter) lt; 1000

  2. %SELECT (COUNTER) FROM PS_INSTALLATION Where COUNTER lt; 1000

  3. If %Bind(Counter) gt;= 1000 then Exit;

  4. %Select(COUNTER) FROM PS_STATE_AET Where COUNTER lt; 1000

  5. %Select(COUNTER) SELECT #39;X#39;

FROM PS_INSTALLATION WHERE %Bind(COUNTER) lt; 1000;

Answer: E

100% Ensurepass Free Download!
Download Free Demo:1z0-242 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 1z0-242 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *