Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 121:

  Match each description with a PeopleCode data buffer access object.

  A. A component scroll
  B. Consists of one or more records of data
  C. Can have zero, one, or more child rowsets
  D. Consists of one or more fields
  E. a - Rowsetb - Rowc - Rowd - Record
  F. a - Recordb - Rowc - Rowd - Record
  G. a - Rowsetb - Rowsetc - Rowd - Field
  H. a - Recordb - Rowsetc - Rowd - Record
  I. a - Rowsetb - Rowc - Recordd - Field
  A. A component scroll

• Question 122:

  View the Exhibit.

  You design the shown page. You write PeopleCode on the Review Type field that enables the Reviewer ID field for any review type other than Self Assessment. Select the option that best describes the most efficient configuration of processing modes for this application.

  

  A. The component is in deferred mode.The page is in interactive mode.The Review Type field is in deferred mode.
  B. The component is in interactive mode.The page is in deferred mode.The Review Type field is in deferred mode.
  C. The component is in deferred mode.The page is in deferred mode.The Review Type field is in interactive mode.
  D. Thecomponent is in deferred mode.The page is in deferred mode.The Review Type field is in deferred mode.
  C. The component is in deferred mode.The page is in deferred mode.The Review Type field is in interactive mode.

• Question 123:

  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, level, and event.

  In what order will the programs execute?

  

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

• Question 124:

  Put the search process flow events in the correct order:

  1) User selects the search key.

  2) Search page builds dynamically.

  3) Search key passes to the component.

  4) Component search record properties are accessed.

  5) User clicks content reference.

  A. 1, 3, 4, 2, 5
  B. 5, 2, 4, 1, 3
  C. 1, 5, 4, 3, 2
  D. 5, 4, 2, 1, 3
  D. 5, 4, 2, 1, 3

• Question 125:

  View the Exhibit.

  The red dot on the left margin of the PeopleCode Editor screen _____.

  

  A. marks a breakpoint
  B. marks a bookmark
  C. indicates an abend
  D. indicates a syntax error
  E. indicates a compile error
  F. indicates a run-time error
  A. marks a breakpoint

• Question 126:

  This PeopleCode function uses effective-date logic to return the current row from PSXLATITEM.

  SQLExec("SELECT A.XLATSHORTNAME, A.XLATLONGNAME FROM PSXLATITEM A WHERE

  A. EFFDT = (SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE
  B. FIELDNAME = B.FIELDNAME AND
  C. FIELDVALUE = B.FIELDVALUE AND
  D. EFFDT
  E. %Date
  F. %AsOfDate
  G. %DateTime
  H. %EffDtCheck
  I. %CurrentDateIn
  J. %CurrentDateOut
  E. %Date

• Question 127:

  The Component Processor's flow can be used to simulate a looping construct. In which event would a PeopleCode program designed to take advantage of this feature be placed?

  A. RowInit
  B. PreBuild
  C. PostBuild
  D. SearchInit
  E. FieldDefault
  F. FieldFormula
  A. RowInit

• Question 128:

  View the Exhibit. Select the advanced search page that this record definition will generate.

  

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

• Question 129:

  Select the three statements that are true about search records. (Choose three.)

  A. Search records build the search page for the component.
  B. Search records are referenced only at level zero in the component.
  C. Search records rarely reference views; they are usually SQL tables.
  D. Search records populate level zero on all pages that are in the component.
  E. Search records provide a high-level key to the primary records that are referenced in the component.
  A. Search records build the search page for the component.
  D. Search records populate level zero on all pages that are in the component.
  E. Search records provide a high-level key to the primary records that are referenced in the component.

• Question 130:

  Select the three elements that must be present before registering a component. (Choose three.)

  A. Folder
  B. Primary table
  C. Permission list
  D. Menu definition
  E. Content reference definition
  A. Folder
  C. Permission list
  D. Menu definition