Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 61:

  Examine this PeopleCode snippet:

  Local Rowset andRSCUST, andRSSTUD;

  andRSCUST = GetRowset(RECORD.CUST_TBL);

  andRSSTUD = CreateRowset(RECORD.STUDENT_TBL);

  andRSCUST.CopyTo(andRSSTUD, RECORD.CUST_TBL, RECORD.STUDENT_TBL);

  Select the correct statement.

  A. The CopyTo() function copies like-named fields from andRSCUST to andRSSTUD.
  B. The CopyTo() function copies like-named fields from andRSSTUD to andRSCUST.
  C. The CopyTo() function is meaningless in this context because andRSCUST is a stand-alone rowset object with no data.
  D. The CopyTo() function is meaningless in this context because andRSSTUD is a stand-alone rowset object with no data.
  E. The PeopleCode statement:andRSCUST.CopyTo(andRSSTUD, RECORD.CUST_TBL, RECORD.STUDENT_TBL);could be replaced with:andRSSTUD = andRSCUST;
  F. The PeopleCode statement:andRSCUST.CopyTo(andRSSTUD, RECORD.CUST_TBL, RECORD.STUDENT_TBL); should be replaced with:andRSCUST.Fill(andRSSTUD, RECORD.CUST_TBL, RECORD.STUDENT_TBL);
  A. The CopyTo() function copies like-named fields from andRSCUST to andRSSTUD.

• Question 62:

  Select the two most likely reasons to specify an Add search record in a component. (Choose two.)

  A. The component requires the Add action.
  B. The component writes to a different table in Add mode.
  C. The component requires a different search key in Add mode.
  D. The search record is a view and the component requires the Add action.
  E. The search record is a security view and you must maintain row-level security in Add mode.
  D. The search record is a view and the component requires the Add action.
  E. The search record is a security view and you must maintain row-level security in Add mode.

• Question 63:

  When do you need to use a PeopleCode looping construct to access values in the component buffer? (Choose all that apply.)

  A. When the PeopleCode references fields on the same row
  B. When the PeopleCode references fields on other rows on the same level
  C. When the PeopleCode references fields at a higher level
  D. When the PeopleCode references fields at a lower level
  E. When the PeopleCode references fields on another scroll at the same level
  F. Never if you use data buffer objects to traverse the rowset
  B. When the PeopleCode references fields on other rows on the same level
  D. When the PeopleCode references fields at a lower level
  E. When the PeopleCode references fields on another scroll at the same level

• Question 64:

  Examine this PeopleCode snippet:

  class RO_ROWSET extends Rowset;

  Which statement is true?

  A. Rowset is a subclass of the RO_ROWSET class.
  B. RO_ROWSET is an instance of the Rowset class.
  C. RO_ROWSET is a superclass of the Rowset class.
  D. Rowset is a superclass of the RO_ROWSETclass.
  E. RO_ROWSET is an application class in the Rowset application package.
  D. Rowset is a superclass of the RO_ROWSETclass.

• Question 65:

  View the Exhibit.

  The Customer Orders page has a requirement that Order Status cannot be changed to Closed if Fill Status is for any row in Order Details.

  You write a FieldChange PeopleCode program with a loop to check the values of Fill Status.

  Each loop increments andI.

  Which statement would you use in the loop to check Fill Status?

  

  A. andstatus = FetchValue(Scroll.ORDER_DTL, andI, ORDER_DTL.FILL_STATUS);
  B. andstatus = FetchValue(andI, ORDER_DTL.FILL_STATUS);
  C. andstatus = FetchValue(ORDER_DTL.FILL_STATUS, andI);
  D. andstatus = FetchValue(ORDER_DTL.FILL_STATUS);
  E. andstatus = ORDER_DTL.FILL_STATUS;
  A. andstatus = FetchValue(Scroll.ORDER_DTL, andI, ORDER_DTL.FILL_STATUS);

• Question 66:

  Select three steps that you perform when you create a subrecord. (Choose three.)

  A. Insert fields.
  B. Build the record.
  C. Set field properties.
  D. Set record field properties.
  E. Select the SubRecord record type.
  A. Insert fields.
  D. Set record field properties.
  E. Select the SubRecord record type.

• Question 67:

  View the Exhibit.

  Examine the Use tab of this component definition and then select the two true statements. (Choose two.)

  

  A. This component contains at least two pages.
  B. This component contains pages that are effective-dated.
  C. This structure of this component consists of only a level zero.
  D. The structure of this component consists of at least a level zero and a level one.
  B. This component contains pages that are effective-dated.
  D. The structure of this component consists of at least a level zero and a level one.

• Question 68:

  Which two statements are true about the structure of PeopleSoft databases? (Choose two.)

  A. Related language table structure varies by language.
  B. In PeopleSoft databases, application datavary by customer.
  C. In PeopleSoft databases, metadata is stored in PeopleTools tables.
  D. In PeopleSoft databases, page structures are stored in forms on the Web server.
  E. The recommended method of maintaining PeopleTools data structures is through theplatform query tool.
  B. In PeopleSoft databases, application datavary by customer.
  C. In PeopleSoft databases, metadata is stored in PeopleTools tables.

• Question 69:

  Which are the two PeopleCode row action events? (Choose two.)

  A. RowInsert
  B. RowDelete
  C. RowInit
  D. RowSelect
  E. PreBuild
  F. PostBuild
  A. RowInsert
  B. RowDelete

• Question 70:

  Select the three best practices for portal navigation design. (Choose three.)

  A. Design for a flat taxonomy.
  B. Order content references and folders alphabetically.
  C. Clearly describe each level in the taxonomy using mouse-over text in sentence case.
  D. Clearly label each level in the taxonomy, repeating the primary business process name if necessary.
  E. Limit the contents of a folder so that folder and content references combined are visible to the end user.
  A. Design for a flat taxonomy.
  C. Clearly describe each level in the taxonomy using mouse-over text in sentence case.
  E. Limit the contents of a folder so that folder and content references combined are visible to the end user.