Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 111:

  Select the option that correctly demonstrates a parent/child relationship where the first record definition is the parent and the second record definition is the child.

  

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

• Question 112:

  Select the three tasks that you can perform using the Registration Wizard. (Choose three.)

  A. Add pages to existing components.
  B. Add components to existing menus.
  C. Add components to a portal registry.
  D. Add components to a permission list.
  E. Create new menus and add components to the new menus.
  B. Add components to existing menus.
  C. Add components to a portal registry.
  D. Add components to a permission list.

• Question 113:

  View the Exhibit.

  In which event should the PeopleCode program have a corresponding program?

  

  A. FieldChange
  B. RowInit
  C. RowDelete
  D. RowSelect
  E. Activate
  F. FieldFormula
  C. RowDelete

• Question 114:

  A PeopleCode program prepopulates the fields on a search page based on the user role.

  Which definition contains the program?

  A. the menu
  B. the view record
  C. the search page
  D. the search record
  E. the USER_ID field
  D. the search record

• Question 115:

  Select the two characteristics of summary pages that set them apart from non-summary pages. (Choose two.)

  A. They are display-only.
  B. They contain only level zero.
  C. They typically contain no related fields.
  D. They reference one record definition.
  A. They are display-only.
  C. They typically contain no related fields.

• Question 116:

  Examine this PeopleCode snippet: If All(START_DT, END_DT) Then Which option is true?

  A. The correct syntax isIf Any(START_DT, END_DT) Then
  B. The correct syntax isIf %All(START_DT, END_DT) Then
  C. If either START_DT or END_DT has values, the statement returns TRUE.
  D. If both START_DT and END_DT have values, the statement returns TRUE.
  E. If both START_DT and END_DT have values or if they are both empty, the statement returns TRUE.
  D. If both START_DT and END_DT have values, the statement returns TRUE.

• Question 117:

  You have a query that retrieves data for employees who took vacation for a specific duration (for example, two weeks). You want to change this query so that it will prompt the user to enter a value for the duration of the vacation. To achieve

  this result, which action would you take?

  A. Add a prompt to further refine the query when it is run.
  B. Define expressions to calculate the duration of a vacation.
  C. Define a HAVING criterion to display the duration of a vacation.
  D. Apply aggregate functions to determine the duration of a vacation.
  A. Add a prompt to further refine the query when it is run.

• Question 118:

  Select the three true statements about the portal registry and navigation. (Choose three.)

  A. Modifying the portal registry grants access to a component.
  B. Portal registry navigation uses menu definitionsto determine folder structure.
  C. You can modify the portal registry through the registration wizard.
  D. The portal registry can be accessed through the structure and content reference.
  E. In the portal registry, you can modify the node, folder, and security properties of a content reference.
  C. You can modify the portal registry through the registration wizard.
  D. The portal registry can be accessed through the structure and content reference.
  E. In the portal registry, you can modify the node, folder, and security properties of a content reference.

• Question 119:

  Which three PeopleCode events should NOT be used for errors and warnings? (Choose three.)

  A. SearchInit
  B. SearchSave
  C. RowSelect
  D. RowInit
  E. RowDelete
  F. FieldEdit
  G. FieldChange
  H. SaveEdit
  A. SearchInit
  D. RowInit
  G. FieldChange

• Question 120:

  Select three true statements about the structure of PeopleSoft databases. (Choose three.)

  A. The standard suffix for a prompt table is _TBL.
  B. System catalog table names vary based on database platform.
  C. PSXLATITEM is a PeopleTools table that stores translate values.
  D. PS_PAGEDEFN is a PeopleTools table that stores page metadata.
  E. Application data table structure is based on related language tables metadata.
  F. The standard categories of tables in a PeopleSoft database are the system catalog tables, the PeopleTools tables, the related language tables, and the application data tables.
  A. The standard suffix for a prompt table is _TBL.
  B. System catalog table names vary based on database platform.
  C. PSXLATITEM is a PeopleTools table that stores translate values.