Oracle 1Z0-242 Online Practice Questions and Exam Preparation

Oracle 1Z0-242 Online Questions & Answers

• Question 81:

  You created a component interface with the standard methods of Create, Find, Get, Cancel, and Save. You secured the component interface and provided full access to all the methods. You want to test the GET method to access the online information. Which three steps will you use to test the GET method? (Choose three.)

  A. Open the component interface in Application Designer.
  B. Right-click in the component interface view and select Test Component Interface.
  C. Save the data by selecting File, Save.
  D. Use the Find option to test the GET method after supplying key values.
  E. Use the Get Existing option to test the GET method after supplying key values.
  F. Enter data in the Component Interface Tester tool.
  G. Validate that the data has been modified and saved by accessing the online component or using the database query tool.
  A. Open the component interface in Application Designer.
  B. Right-click in the component interface view and select Test Component Interface.
  E. Use the Get Existing option to test the GET method after supplying key values.

• Question 82:

  Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.

  andSQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1", PSU_TASK_TBL.TASK); andVar1 = andSQL.Fetch(andVar2);

  Select the two correct statements. (Choose two.)

  A. andVar2 specifies which row to fetch.
  B. andVar2 specifies which field to fetch.
  C. andVar1 is populated with TRUE if a row is fetched.
  D. andVar1 is populated with the number of rows returned.
  E. andVar2 is populated with EFFORT_AMT from the row fetched.
  F. andVar1 is populated with EFFORT_AMT from the row fetched.
  G. andVar1 is populated with EFFORT_AMT from the first row returned.
  C. andVar1 is populated with TRUE if a row is fetched.
  E. andVar2 is populated with EFFORT_AMT from the row fetched.

• Question 83:

  The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to write a PeopleCode program to create a stand-alone rowset that will load data from the ITEM table into the data buffer. Select three PeopleCode statements that can be used with stand-alone rowsets. (Choose three.)

  A. andRS_Item = GetRowSet(SCROLL.ITEM);
  B. andRS_Item = CreateRowSet(RECORD.ITEM);
  C. andPrice = andRS_Item(andi).ITEM.PRICE.Value;
  D. andRS_Item.Select("Where ITEM = :1", CUST_ORDER.ITEM);
  E. andRS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);
  F. andRS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, ("Where CUST_TYPE = :1", CUST_ORDER. CUST_TYPE);
  B. andRS_Item = CreateRowSet(RECORD.ITEM);
  C. andPrice = andRS_Item(andi).ITEM.PRICE.Value;
  E. andRS_Item.Fill("Where CUST_TYPE = :1", CUST_ORDER.TYPE);

• Question 84:

  You created a component interface and now must implement it on an online component. The PeopleCode that triggers a component interface is placed on the SavePostChange event. Select the three reasons for placing the PeopleCode on the SavePostChange event? (Choose three.)

  A. SavePostChange event is not field dependent.
  B. SavePostChange is initiated after the Component Processor updates the database.
  C. SavePostChange is generally used to update tables that are not in the component.
  D. An error or warning that is generated in SavePostChange causes the component interface to be canceled, but the component data is saved.
  E. The system issues a SQL commit after the SavePostChange terminates successfully.
  B. SavePostChange is initiated after the Component Processor updates the database.
  C. SavePostChange is generally used to update tables that are not in the component.
  E. The system issues a SQL commit after the SavePostChange terminates successfully.

• Question 85:

  An inbound request to a PeopleSoft application is received by the appropriate listening connector in the Integration Gateway. Which connector is the request passed to?

  A. HTTP target connector
  B. PeopleSoft target connector
  C. PeopleSoft listening connector
  D. PeopleSoft service listening connector
  B. PeopleSoft target connector

• Question 86:

  View the Exhibit.

  You run an Application Engine program through Process Scheduler with Trace configured as shown in the Exhibit. What will the trace show? (Choose all that apply.)

  

  A. SQL statements
  B. Statement Timings
  C. PeopleCode Detail Timings
  D. Trace Each Statement in Program
  E. Nothing. The program has to be run in two-tier mode.
  F. Nothing. A PeopleTools Trace File must be specified.
  E. Nothing. The program has to be run in two-tier mode.

• Question 87:

  You have recently installed PeopleSoft HCM system. To populate employee information into the PERSON, ADDRESSES, and NAMES tables, you will read in an XML flat file from a non-PeopleSoft system.

  PERSON is the parent table and ADDRESSES and NAMES are the child tables of PERSON.

  Which two steps will you need to perform to create the file layout on the HCM system? (Choose two.)

  A. Write the application engine program to export the data.
  B. Provide the import data in a correctly formatted flat file.
  C. Create a file layout to match the record and field structure of the data.
  D. Set the file layout properties to specify the file layout format of XML.
  E. Preview and troubleshoot the input data format and content.
  F. Enter file record IDs on the file layout segment properties.
  G. Adjust the start position of all file fields after the start position of the file record.
  C. Create a file layout to match the record and field structure of the data.
  D. Set the file layout properties to specify the file layout format of XML.

• Question 88:

  Which three URLs must be defined before you can create messages and schemas? (Choose three.)

  A. Inquiry URL
  B. Publish URL
  C. Target location
  D. Service namespace
  E. Schema namespace
  C. Target location
  D. Service namespace
  E. Schema namespace

• Question 89:

  View the Exhibit that shows the PeopleCode used to publish the LOCATION_SYNC service operation. This code has been placed in the SavePostChange event in the SETID field in the LOCATION_TBL record. When a user updates the location 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
  D. Only the rows of data that have changed in the rowset

• Question 90:

  View the Exhibit.

  You want to reuse the code in this Application Engine program by making it available to other Application Engine programs.

  What must you do to use the program as a repository for PeopleSoft Application Engine sections?

  

  A. Delete the MAIN section.
  B. Rename the MAIN section.
  C. Use the suffix LIB in the program name.
  D. Include at least one Call Section action.
  E. Set Access to Public for at least one section.
  F. Select the Application Library check box on the Advanced tabbed page of the PeopleSoft Application Engine Properties dialog.
  E. Set Access to Public for at least one section.