Oracle 1Z0-242 Online Practice Questions and Exam Preparation

Oracle 1Z0-242 Online Questions & Answers

• Question 31:

  View the Exhibit that shows the message tree structure for the STUDENT_INFO message. Based on this structure, which two statements describe the message? (Choose two.)

  

  A. This is a rowset-based message.
  B. Student is an alias for the record.
  C. This is a non-rowset-based message.
  D. The alias for this message is Student.
  E. The description for the STUDENT_ID field is ID.
  F. The EMPHASIS field is included in the message.
  A. This is a rowset-based message.
  B. Student is an alias for the record.

• Question 32:

  Which two tasks do you need to complete after consuming a Web service? (Choose two.)

  A. Add a point-to-point routing.
  B. Add the appropriate OnRequest handler.
  C. Secure the service operation with a permission list.
  D. Write the PeopleCode to invoke the service operation.
  E. Update the connection properties on the service operation.
  C. Secure the service operation with a permission list.
  D. Write the PeopleCode to invoke the service operation.

• Question 33:

  The Application Engine program PSU_PROC_CRSE has a Do Select action with the following code:

  %Select (COURSE, EFFDT, DESCR, TOOLS_REL) SELECT COURSE , EFFDT , DESCR , TOOLS_REL FROM PS_PSU_COURSE_TBL A WHERE A.EFFDT <= (SELECT MAX(A1.EFFDT) FROM PS_PSU_COURSE_TBL A1 WHERE A1.COURSE = A.COURSe AND A1.EFFDT <= GETDATE())

  The program works fine in testing, but it fails when run on an Oracle database platform.

  Select the two approaches that will resolve the problem and give the expected results. (Choose two.)

  A. Delete the Where clause.
  B. Change the WHERE clause to WHERE A.EFFDT = MAX(EFFDT).
  C. Change the SELECT clause to SELECT DISTINCT.
  D. Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn).
  E. Replace the GETDATE() function with the %CurrentDateIn system variable.
  F. Select the Active check box on the step so that the PeopleSoft Application Engine automatically selects the current row.
  D. Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn).
  E. Replace the GETDATE() function with the %CurrentDateIn system variable.

• Question 34:

  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.
  E. Deselect the Disable Restart check box on the Program Properties page.

• Question 35:

  Select a good reason to select Disable Restart in an Application Engine program.

  A. The program commits every row.
  B. Selecting Disable Restart improves performance because it causes Application Engine to defer all commits until processing completes.
  C. The program does a lot of preparation work up front, like joining tables and loading data into temporary work tables.
  D. The program only commits once, when the program successfully completes.
  E. The program performs crucial and time-sensitive data processing.
  D. The program only commits once, when the program successfully completes.

• Question 36:

  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_TBLSET QTY_ON_HAND = %1 - %2WHERE ITEM_CD = %3 (QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
  B. %UPDATE (QTY_ON_HAND)SELECT QTY_ON_HAND - QTY_ORDEREDFROM PS_PSU_STOCK_TBLWHERE ITEM_CD = %Bind(ITEM_CD)
  C. UPDATE PS_PSU_STOCK_TBLSET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind (QTY_ORDERED)WHERE ITEM_CD = %Bind(ITEM_CD)
  D. UPDATE PS_PSU_STOCK_TBLSET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind (QTY_ORDERED)WHERE ITEM_CD = Bind(ITEM_CD)
  E. %UPDATE PS_PSU_STOCK_TBLSET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED) WHERE ITEM_CD = %ITEM_CD
  C. UPDATE PS_PSU_STOCK_TBLSET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind (QTY_ORDERED)WHERE ITEM_CD = %Bind(ITEM_CD)

• Question 37:

  View the Exhibit.

  This PeopleCode program disables the CHARGE_BACK field:

  Local Row andRow;

  andRow = GetRow();

  andRow.PSU_TASK_EFFORT.CHARGE_BACK.Enabled = False;

  For this program to work as shown, what is the highest level at which it could be placed?

  

  A. PSU_TASK_TBL (Table)
  B. PSU_TASK_RSRC (Table)
  C. PSU_TASK_EFFORT (Table)
  D. CHARGE_BACK (Record Field)
  E. PSU_TASK_RESOURCES (Component)
  F. PSU_TASK_TBL (Table) - Search Record
  C. PSU_TASK_EFFORT (Table)

• Question 38:

  View the Exhibit, which displays your file layout for a purchase order. In your application engine program to export the data to a file, which statement will instantiate the rowset?

  

  A. androwset=CreateRowset(Record.PSU_PO_HDR),CreateRowset(Record.PSU_PO_DTL);
  B. androwset=CreateRowset(Record.PSU_PO_HDR,CreateRowset(Record.PSU_PO_DTL));
  C. androwset1=CreateRowset(Record.PSU_PO_HDR);androwset2=CreateRowset(Record.PSU_PO_DTL);
  D. andMYFILE.SetFileLayout(FileLayout.PO_FILE);
  E. andMYFILE = GetFile("E:\temp\PO_OUT.txt", "W", %FilePath_Absolute);
  B. androwset=CreateRowset(Record.PSU_PO_HDR,CreateRowset(Record.PSU_PO_DTL));

• Question 39:

  You add a button to a page to run an Application Engine program in synchronous mode. How do you configure the button?

  A. Associate the button with a run control record that passes parameters to Process Scheduler to schedule the process.
  B. Associate the button with FieldChange PeopleCode that uses a Process Request object to schedule the process.
  C. Associate the button with FieldChange PeopleCode that uses a CallAppEngine function to launch the program.
  D. Associate the button with an Application Engine PeopleCode action that passes parameters to a Call Section action.
  E. Associate the button with OnExecute PeopleCode that uses a PSAE command to launch the program.
  C. Associate the button with FieldChange PeopleCode that uses a CallAppEngine function to launch the program.

• Question 40:

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

  

  A. A state record with fields to hold input parameters
  B. Component variables to pass the input parameters
  C. A data buffer object to retrieve the input parameters
  D. Application Engine SQL to retrieve the input parameters
  E. A PeopleCode record object to update the Course table
  F. A Process Instance table to store run control parameters
  G. A run control record with fields to store the input parameters
  A. A state record with fields to hold input parameters
  D. Application Engine SQL to retrieve the input parameters
  G. A run control record with fields to store the input parameters