nerdexam
Oracle

1Z0-241 · Question #14

Examine this PeopleCode snippet: Local Rowset&RS_Level0, &RS_Level1; Local Row &Row_Level0, &Row_Level1; Local Record &Rec_EMP; Local Field &Fld_ROLE; &RS_Level0 = GetRowset(0); &ROW_Level0 =…

The correct answer is C. &RS_Level1 = &Row_Level0.GetRowset(SCROLL.DEPT). See the full explanation below for the reasoning.

Question

Examine this PeopleCode snippet: Local Rowset&RS_Level0, &RS_Level1; Local Row &Row_Level0, &Row_Level1; Local Record &Rec_EMP; Local Field &Fld_ROLE; &RS_Level0 = GetRowset(0); &ROW_Level0 = &RS_Level0.GetRow(1); If this is the beginning of a program that will traverse the data buffer to access values at level 1, which would be the next valid PeopleCode statement?

Options

  • A&Row_Level1 = GetRow(&l);
  • B&Row_Level1 = &RS_Level1.GetRow(&l);
  • C&RS_Level1 = &Row_Level0.GetRowset(SCROLL.DEPT);
  • D&RES_TASKRRC = &Row_Level1.GetRecord(RECORD.EMP);
  • E&FLD_PCTAVAIL = &REC_TASKRSRC.GetField(Field.ROLE);

How the community answered

(27 responses)
  • A
    11% (3)
  • B
    4% (1)
  • C
    81% (22)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-241 Practice