Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 21:

  PeopleCode in the SavePostChange and SavePrechange events can be placed on the component either at the component level or at the component record level. Which two statements are true about the how these events are processed? (Choose two.)

  A. PeopleCode in these events placed at the component record level runs once per row when the page is saved.
  B. PeopleCode in these events placed at the component record level runs once when the page is saved.
  C. PeopleCode in these events placed at the component level runs once per row when the page is saved.
  D. PeopleCode in these events placed at the component level runs once when the page is saved.
  E. PeopleCode in these events placed at the component record level triggers a Save when a row is changed.
  F. PeopleCode in these events placed at the component level triggers a Save when the page is changed.
  A. PeopleCode in these events placed at the component record level runs once per row when the page is saved.
  D. PeopleCode in these events placed at the component level runs once when the page is saved.

• Question 22:

  View the Exhibit.

  As the component processor loads a component, it executes PeopleCode programs according to buffer allocation rules.

  Each row in the table represents a PeopleCode program and its associated definition, scroll level, and event.

  In what order will the programs execute?

  

  A. A, B, C, D, E
  B. C, A,D, E, B
  C. C, E, A, D, B
  D. E, C, A, B, D
  E. E, D, C, B, A
  D. E, C, A, B, D

• Question 23:

  The primary role of Oracle's PeopleSoft Process Scheduler is to support the PeopleSoft application environment.

  Which three statements are true regarding the usage and advantages of PeopleSoft Process Scheduler? (Choose three.)

  A. You can perform certain processes (such as running reports, loading benefit enrollment forms, calculating payroll deductions, and so on) inthe background of the online system.
  B. PeopleSoft Process Schedulerhas two purposes. The first is to provide different methods of viewing reports, based on the level of access granted. The second is to assign users to a Report Manager Administration role in PeopleSoft Security, so they can delete reports from the database.
  C. You can take advantage of the distributed computing environment at your site, whereby you can schedule performance-sensitive jobs to run on a powerful server while the online system is still available to end users.
  D. You can extract the precise information that you are looking for by using visual representations of your PeopleSoft database, without writing SQL statements.
  E. You can schedule a process request to run on any date or during any time interval that your business requires, such as monthly,daily, hourly, or by the minute.
  A. You can perform certain processes (such as running reports, loading benefit enrollment forms, calculating payroll deductions, and so on) inthe background of the online system.
  C. You can take advantage of the distributed computing environment at your site, whereby you can schedule performance-sensitive jobs to run on a powerful server while the online system is still available to end users.
  E. You can schedule a process request to run on any date or during any time interval that your business requires, such as monthly,daily, hourly, or by the minute.

• Question 24:

  Fill in the blanks using PeopleCode data buffer access classes.

  A record object contains at least one ____ object.

  One _____ object can be instantiated to represent the entire component buffer. A row object contains at least one _______ object or _______ object.

  A rowset object contains at least one _______ object.

  A. field, rowset, rowset, record, row
  B. row, component, record, field, record
  C. scroll, rowset, row, record, row
  D. field, page, rowset, row, record
  E. row, record, record, field, row
  A. field, rowset, rowset, record, row

• Question 25:

  View the Exhibit.

  Select the two true statements regarding this subrecord. (Choose two.)

  

  A. The subrecord generates this SQL build script:CREATE TABLE PSU_ADDRESS_SBR (STREET1 CHAR(30) NOTNULL,CITY CHAR(30) NOT NULL, STATE CHAR(6) NOT NULL,ZIP CHAR(10) NOT NULL, COUNTRY CHAR(3) NOT NULL)
  B. The PeopleCode on the COUNTRY field is invalid.
  C. The subrecord has no effect on the performance of the application.
  D. The subrecord is transparent tothe database management system.
  C. The subrecord has no effect on the performance of the application.
  D. The subrecord is transparent tothe database management system.

• Question 26:

  When considering key structure, which three options are mutually exclusive? (Choose three.)

  A. Key
  B. Search Key
  C. Descending Key
  D. Alternate Search Key
  E. Duplicate Order Key
  A. Key
  D. Alternate Search Key
  E. Duplicate Order Key

• Question 27:

  This PeopleCode snippet creates a record object, where TASK and RESOURCE_NAME are keys on TASK_RSRC.

  andMyRec = CreateRecord(Record.TASK_RSRC); andMyRec.TASK.Value = andTask; andMyRec.RESOURCE_NAME.Value = andResource;

  Which method will populate the record object with one row from PS_TASK_RSRC?

  A. Insert
  B. Fetch
  C. Update
  D. Execute
  E. SelectByKey
  E. SelectByKey

• Question 28:

  Select the two true statements about PeopleSoft Pure Internet Architecture. (Choose two.)

  A. Metadata is cached on the application server.
  B. Most code is executed on the application server.
  C. By placing the Application Designer executables on the Web server, you can take advantage of PeopleSoft Pure Internet Architecture to develop applications in the browser interface.
  D. The Web server generates the HTML and transfers it to the application server, which then retrieves the application data and sends all information directly to the browser for display to the user.
  A. Metadata is cached on the application server.
  B. Most code is executed on the application server.

• Question 29:

  View the Exhibit.

  Select the page that most likely uses this subpage.

  

  

  A. Exhibit A
  B. Exhibit B
  C. Exhibit C
  D. Exhibit D
  D. Exhibit D

• Question 30:

  View the Exhibit.

  This FieldChange program conditionally populates DERIVED.EDITTABLE, based on the value of PSU_EMP_RVW_RVR.REVIEW_TYPE.

  Another similar program should be placed in a companion event. In which other event should the other PeopleCode program be placed?

  

  A. FieldEdit
  B. RowInit
  C. RowInsert
  D. SavePreChange
  E. SavePostChange
  B. RowInit