Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 131:

  Examine this PeopleCode snippet:

  Local Rowset andRS1;

  andRS1 = CreateRowset(RECORD.PSU_CUST_TBL);

  andCustomer = "XYZ";

  andRS1.Fill("WHERE CUSTOMER_ID =:1", andCustomer);

  Select the correct statement.

  A. The snippet is correct as shown.
  B. The snippet is not correct.The CreateRowset function instantiates a stand-alone rowset object.A GetRowset function should be used to instantiate a rowset object that uses a Fill method.
  C. The snippet is not correct.The CreateRowset function instantiates a rowset object that references the component buffer.A Select method should be used instead of a Fill method.
  D. The snippet is not correct.The CreateRowset function instantiates a rowset object that references the component buffer.A GetRowset function should be used to instantiate a rowset object that uses a Fill method.
  E. The snippet is not correct.The CreateRowset function instantiates a stand-alone rowset object.A Select method should be used instead of a Fill method.
  A. The snippet is correct as shown.

• Question 132:

  View the Exhibit.

  Select the record definition that builds this search page.

  

  

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

• Question 133:

  What are three standard system edits that the component processor performs on a field? (Choose three.)

  A. Duplicate key
  B. Required field
  C. Spelling
  D. Field format
  E. Foreign key
  A. Duplicate key
  B. Required field
  D. Field format

• Question 134:

  View the Exhibit.

  The Student Personal Details page writes to the PS_STUDENT table.

  If the "Same address as Customer" check box is selected on the Student Personal Details page, as shown on the Exhibit, the student address is copied from the PS_CUSTOMER table.

  As a result, the PS_STUDENT table must be updated whenever a change to the address value on the Customer page is written to the PS_CUSTOMER table.

  The recommended method to enforce this is to ________.

  

  A. use a prompt table edit
  B. write a Data Mover script
  C. write a PeopleCode program
  D. create an Integration Broker message
  E. create an Application Engine daemon process
  C. write a PeopleCode program

• Question 135:

  Your customer indicates that when she promotes her employees, typically she increases their pay simultaneously.

  You want to manage this with one table. Which two fields must you place on that table to accommodate this request? (Choose two.)

  A. EFFDT
  B. EFFSEQ
  C. EFF_STATUS
  D. EFFECTIVE_DT
  E. EFFECTIVE_SEQ
  A. EFFDT
  B. EFFSEQ

• Question 136:

  Select three rules for PeopleCode user-defined variables. (Choose three.)

  A. User-defined variables must begin with %.
  B. The variable name can be up to 1,000 characters long.
  C. The variable name must be at least eight characters long.
  D. User-defined string variables begin with $ and numeric variables begin with #.
  E. The variable name must contain at least one numeric character andone uppercase character.
  F. If a variable has not been declared before it is used, it is automatically declared as Local Any.
  G. Component and global scope variables must be declared before the first line of executable code.
  B. The variable name can be up to 1,000 characters long.
  F. If a variable has not been declared before it is used, it is automatically declared as Local Any.
  G. Component and global scope variables must be declared before the first line of executable code.

• Question 137:

  Examine this PeopleCode snippet:

  Local Rowset andRS_Level0, andRS_Level1;

  Local Row andRow_Level0, andRow_Level1;

  Local Record andRec_EMP;

  Local Field andFld_ROLE;

  andRS_Level0 = GetLevel0();

  andROW_Level0 = andRS_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?

  A. andRow_Level1 = GetRow(andI);
  B. andRow_Level1 = andRS_Level1.GetRow(andI);
  C. andRS_Level1 = andRow_Level0.GetRowSet(SCROLL.DEPT);
  D. andREC_TASKRSRC = andRow_Level1.GetRecord(RECORD.EMP);
  E. andFLD_PCTAVAIL = andREC_TASKRSRC.GetField(FIELD.ROLE);
  C. andRS_Level1 = andRow_Level0.GetRowSet(SCROLL.DEPT);

• Question 138:

  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. A, D, E, B, C
  C. B, C, A, D, E
  D. A, C, D, B, E
  E. E, D, C, B, A
  D. A, C, D, B, E

• Question 139:

  View this PeopleCode snippet:

  If andMyVar = 0 then andMyVar = 1; End-if;

  The andMyVar variable is not declared. What will be the result?

  A. The program will fail at run time.
  B. The program will not pass the syntax checker.
  C. The program will run but will produce undefined results.
  D. andMyVar willbe automatically declared with a type of Any.
  E. andMyVar will be automatically declared as Local Number.
  F. andMyVar will be automatically declared with a scope of Global.
  D. andMyVar willbe automatically declared with a type of Any.

• Question 140:

  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 two correct statements. (Choose two.)

  A. andRSCUST is a stand-alone rowset object that references the rows in PS_CUST_TBL.
  B. andRSSTUD is a stand-alone rowset object that references the rows in PS_STUDENT_TBL.
  C. andRSCUST is a rowset object that references the component buffer data for the CUST_TBL record.
  D. andRSCUST is a stand-alone rowset object based on the structure of the CUST_TBL record definition.
  E. andRSSTUD is a rowset object that references the component buffer data for the STUDENT_TBL record.
  F. andRSSTUD is a stand-alone rowset object based on the structure of the STUDENT_TBL record definition.
  C. andRSCUST is a rowset object that references the component buffer data for the CUST_TBL record.
  F. andRSSTUD is a stand-alone rowset object based on the structure of the STUDENT_TBL record definition.