Oracle 1Z0-242 Online Practice Questions and Exam Preparation

Oracle 1Z0-242 Online Questions & Answers

• Question 1:

  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?

  A. No changes to the code are needed as long as the temporary table has been properly configured for parallel processing.
  B. 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.
  C. 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.
  D. 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.
  E. 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.
  D. 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.

• Question 2:

  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 reduces network traffic by making fewer server trips.
  B. Set processing uses load balancing to distribute processing across multiple servers.
  C. Set processing reuses SQL statements where possible, which reduces overhead significantly.
  D. Set processing uses stored procedures, which are more efficient than Application Engine SQL.
  E. Set processing transfers much of the processing work from Application Engine to the RDBMS, where there is less processing overhead.
  F. Set processing selects only the rows that will be processed, rather than using conditional constructs to determine which rows to process.
  A. 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 selects only the rows that will be processed, rather than using conditional constructs to determine which rows to process.

• Question 3:

  Logical transformations are required to _____.

  A. send or receive a nonrowset-based message
  B. alias the current version of the service operation
  C. send or receive a service operation using an alias
  D. send or receive nondefault versions of a service operation
  E. change the message for the current version of the service operation
  D. send or receive nondefault versions of a service operation

• Question 4:

  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 andRowset.Flush(); after the Select method.
  C. Use an Update method instead of a Select method.
  D. Add andRowset.Flush(); before the Select method.
  E. Add andRowset.Refresh (); after the Select method.
  F. Add andRowset.Refresh(); before the Select method.
  D. Add andRowset.Flush(); before the Select method.

• Question 5:

  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.
  A. Reduce the frequency of commits.

• Question 6:

  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.

  A. The Application Engine program will execute as expected.
  B. Step 2 is not needed for dynamic call.
  C. Step 3 is not needed.
  D. 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.
  E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.
  F. Step 4 is wrong. The PeopleCode program should use the AESection class to issue the dynamic call.
  E. Add a step after step 5 to select the Dynamic Call check box in the Call Section action.

• Question 7:

  An Application Engine program includes a step that selects all the rows in the PS_ORDERS table where CUSTOMER_TYPE = PARTNER, and then calls a PeopleCode program that processes each row of data.

  Which should be the first action type in the step?

  A. Do Select
  B. Do When
  C. Do While
  D. Do Until
  E. Do If
  F. Do Query
  A. Do Select

• Question 8:

  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
  A. Rowset-based message

• Question 9:

  An Application Engine program section uses a SQL Select statement to select fields from the CUST_ORDERS table, and then calls a section that uses a SQL Insert statement to update the CUST_HISTORY table based on those fields. How are the field values passed between the SQL statements?

  A. By using state variables
  B. By using a state record
  C. By using a SQL view
  D. By using meta variables
  E. By using a SQL cursor
  B. By using a state record

• Question 10:

  Which statement describes a container message?

  A. The container can be nested.
  B. The resulting shape is always rowset based.
  C. PSCAMA is automatically added to the schema.
  D. The resulting shape is always nonrowset based.
  E. The message parts can be a mixture of rowset based and nonrowset based.
  D. The resulting shape is always nonrowset based.