Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 81:

  Which PeopleCode statement would you use to instantiate a row object for the current row?

  A. andRow = GetRow();
  B. andRow = CreateRow();
  C. andRow = andRowSet.Row();
  D. andRow = andRowSet.GetRow;
  E. andRow = andRowSet.GetCurrRow;
  A. andRow = GetRow();

• Question 82:

  View the Exhibit.

  Select the SQL statement that corresponds to the record definition.

  

  A. SELECT
  B. COURSE,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESCR,A.ENROLL_DT ,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID = B.STUDENT_IDAND B.CUSTOMER_ID=
  C. CUSTOMER_ID
  D. SELECT
  E. COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL BWHERE A.STUDENT_ID =
  F. STUDENT_IDAND B.CUSTOMER_ID = B.CUSTOMER_ID
  G. SELECT
  H. COURSE,A.STUDENT_ID,A.SESSION_NBR,B.STUDENT_NAME,B.CUSTOMER_ID,C.DESC R,A.ENROLL_DT,A.ENROLL_STATUSFROM PS_PSU_STU_ENROLL A, PS_PSU_STUDENT_TBL B, PS_PSU_CUST_TBL CWHERE A.STUDENT_ID =
  I. STUDENT_IDAND B.CUSTOMER_ID = C.CUSTOMER_ID
  J. SELECT A.COURSE D.SELECT
  C. CUSTOMER_ID

• Question 83:

  You create a custom application in the default processing mode. Select three scenarios that cause the application to make a trip to the application server. (Choose three.)

  A. Saving the component
  B. Inserting a row in a grid
  C. Expanding a collapsible section
  D. Entering XYZ in the Customer field
  E. Entering a number in the Quantity and Amount fields. Both these fields have FieldEdit PeopleCode in them.
  A. Saving the component
  B. Inserting a row in a grid
  C. Expanding a collapsible section

• Question 84:

  Select the two true statements about translate values. (Choose two.)

  A. You must enter a translate short name.
  B. You can use any four-character combination as a translate value.
  C. You must maintain translate values through Application Designer.
  D. You can inactivate any translate value by changing the value of the effective status field to "I".
  E. The default displayed value that appears in a page field is the translate long name.
  B. You can use any four-character combination as a translate value.
  D. You can inactivate any translate value by changing the value of the effective status field to "I".

• Question 85:

  Choose the four statements that are true about PSXLATITEM and its values. (Choose four.)

  A. Translate values are numeric.
  B. Translate values are effective-dated.
  C. Translate values are linked to a field.
  D. Fields can share values in PSXLATITEM.
  E. Translate values should be relatively static.
  F. PSXLATITEM is thename of the PeopleTools translate table.
  B. Translate values are effective-dated.
  C. Translate values are linked to a field.
  E. Translate values should be relatively static.
  F. PSXLATITEM is thename of the PeopleTools translate table.

• Question 86:

  Select the correct syntax for a PeopleCode conditional construct.

  A. Do Case Case = Case = ;Case = ;Case-Other;End-Case;
  B. When Or When = ;Else When = ;When-Other;End-When;
  C. Evaluate When = When = ;When = ;When- Other;End-Evaluate;
  D. Evaluate When = thenWhen = then;When = then;Else;End-Evaluate;
  E. Do When When = When = ;When = ;When- Other;End-When;
  C. Evaluate When = When = ;When = ;When- Other;End-Evaluate;

• Question 87:

  View the Exhibit.

  You begin to register a component using the registration wizard. Based on the values that appear in the dialog box, select the best course of action.

  

  A. Continue registering the component as it is.
  B. Stop the registration process to investigate why this component isalready registered.
  C. Change the user-facing fields to mixed case and make them less technical and then continue registering the component.
  A. Continue registering the component as it is.

• Question 88:

  During the execution of a PeopleCode program, a FieldEdit program issues an error statement. The component processor _____.

  A. notifies the user and the processing continues
  B. terminates the program and rolls back changes
  C. displays a message and returns to the reset state
  D. displays a message, loops back through the component build flow, and waits for the user to change the field
  E. displays a message, loops back to display the page, and waits for the user to change the field
  E. displays a message, loops back to display the page, and waits for the user to change the field

• Question 89:

  Select three differences between derived/work fields and SQL table fields. (Choose three.)

  A. Derived/work fields cannot contain PeopleCode.
  B. Derived/work fields cannot have prompt table edits.
  C. Users cannot change values in derived/work fields.
  D. Derived/work field values are not stored in the database.
  E. Standard system validations, such as data type, are not applied on derived/work fields.
  F. Derived/work fields can be placed at any level of the page without violating page-order rules.
  G. Only those derived/work fields that are on a page or that are referenced by PeopleCode are loaded into the component buffer.
  D. Derived/work field values are not stored in the database.
  F. Derived/work fields can be placed at any level of the page without violating page-order rules.
  G. Only those derived/work fields that are on a page or that are referenced by PeopleCode are loaded into the component buffer.

• Question 90:

  View the Exhibit.

  What is OCPUtilites?

  

  A. a record definition
  B. an application class
  C. an application package
  D. a PeopleCode program
  E. an application class superclass
  F. an application package subpackage
  F. an application package subpackage