Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 181:

  Examine this PeopleCode snippet:

  Local Rowset andRS_Level0, andRS_Level1;

  Local Row andRow_Level0, andRow_Level1;

  Local Record andRec_EMPLOYEE;

  Local Field andFld_ROLE;

  andRS_LEVEL0 = GetLevel0();

  andROW_LEVEL0 = andRS_Level0.GetRow(1);

  andRS_LEVEL1 = andROW_LEVEL0.GetRowSet(SCROLL.DEPT);

  andROW_LEVEL1 = andRS_LEVEL1(1);

  andREC_EMPLOYEE = andROW_LEVEL1.EMPLOYEE;

  andFLD_EMPID = andREC_TASKRSRC.EMPID;

  andID = andFLD_EMPID.Value;

  Can the code given above be replaced with the following statement?

  andID = GetField().Value

  A. No. The record must be specified.
  B. No. The row and record must be specified.
  C. Yes, if the code is placed on the current row.
  D. Yes, if the code is placed on the EMPID field.
  E. Yes, if the code is placed on the EMPLOYEE record.
  D. Yes, if the code is placed on the EMPID field.

• Question 182:

  Select the two field types that should be placed as the last field in the list of fields in a PeopleSoft record definition. (Choose two.)

  A. Image
  B. Prompt
  C. Character
  D. Attachment
  E. Long character
  F. ImageReference
  A. Image
  E. Long character

• Question 183:

  On the Process Scheduler Request page, you have to define the output type for your job or process. Which three statements are true regarding the process output type? (Choose three.)

  A. An output type that is selected for a job at the main job level carries throughto the job items.
  B. When an output type is selected for a process at the process definition level, it can be changed.
  C. An output type that is selected for a job at the main job level does not carry through to the job items.
  D. An output type that is selected for individual job items overwrites the output type that is entered for the parent job.
  E. An output type that is selected for individual processes or jobs that are attached to a job cannot override the output type that is entered for the parent job.
  F. An output type that is selected for a process at the process definition level overwrites the output type in the Process Scheduler Request page, and the Type drop-down list box in the Process Scheduler Request page becomes unavailable.
  A. An output type that is selected for a job at the main job level carries throughto the job items.
  D. An output type that is selected for individual job items overwrites the output type that is entered for the parent job.
  F. An output type that is selected for a process at the process definition level overwrites the output type in the Process Scheduler Request page, and the Type drop-down list box in the Process Scheduler Request page becomes unavailable.

• Question 184:

  Which three features have the greatest effect on buffer allocation performance? (Choose three.)

  A. Search keys
  B. Related fields
  C. Nested scroll areas
  D. Display control fields
  E. PeopleCode references to other record definitions
  B. Related fields
  C. Nested scroll areas
  E. PeopleCode references to other record definitions

• Question 185:

  Which is a valid use of errors and warnings in the PeopleCode row action events?

  A. Place an error statement in RowDelete to prevent a row from being deleted.
  B. Place an error statement in RowInsert to prevent a row from being inserted.
  C. Place a warning statement in RowInsert to give the user an opportunity to accept the insert or cancel it.
  D. Place an error statement in RowInsert to give the user an opportunity to accept the insert or cancel it.
  E. Place an error statement in RowDelete to give the user an opportunity to accept the delete or cancel it.
  A. Place an error statement in RowDelete to prevent a row from being deleted.

• Question 186:

  You can print the report after running the Crystal report and saving the file.

  Which three options are true when printing a Crystal report? (Choose three.)

  A. To print HTML reports from Crystal Reports, open the appropriate HTML file and print it from the browser.
  B. Before you print a Crystal report, you must modify a query to include additional fields and you need to modify the report definition in Crystal Reports.
  C. As with many Microsoft Windows applications, you can choose to print the entire report or only a few pages, specify the number of copies to print, and indicate whether you want the copies collated.
  D. If you want to update and print the report from within Crystal Reports, the query and report names must match touse the formatting that you just created in Crystal Reports every time you print the report.
  E. If you want to run your report directly from Microsoft Windows-based PeopleSoft Query, the query and report names must match to use the formatting that you justcreated in Crystal Reports every time you print the report.
  A. To print HTML reports from Crystal Reports, open the appropriate HTML file and print it from the browser.
  C. As with many Microsoft Windows applications, you can choose to print the entire report or only a few pages, specify the number of copies to print, and indicate whether you want the copies collated.
  E. If you want to run your report directly from Microsoft Windows-based PeopleSoft Query, the query and report names must match to use the formatting that you justcreated in Crystal Reports every time you print the report.

• Question 187:

  Within the component processor flow, field action processing is initiated when _____.

  A. a field value is changed
  B. a user changes a value in a field
  C. the component build process completes
  D. a user enters an incorrect value in a field
  E. a user changes a value in a field and exits the field or saves
  E. a user changes a value in a field and exits the field or saves

• Question 188:

  View the Exhibit.

  Select the SQL that corresponds to the record definition shown.

  

  A. SELECT A.COURSE,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START_DATEFROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = B.COURSE
  B. SELECT
  C. INSTRUCTOR,A.COURSE,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START_DATEF ROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = B.COURSE
  D. SELECTA.COURSE,A.INSTRUCTOR,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START _DATEFROM PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE =
  E. COURSE
  F. SELECT
  G. INSTRUCTOR,A.COURSE,B.DESCR,A.SESSION_NBR,A.TRAINING_LOC,A.START_DTFRO M PS_PSU_CRS_SESSN A,PS_PSU_COURSE_TBL BWHERE A.COURSE = B.COURSE
  B. SELECT

• Question 189:

  View the Exhibits.

  Examine the two pages and select the correct statement.

  

  A. You can group these pages in the same component.
  B. You cannot group these pages in the same component.
  B. You cannot group these pages in the same component.

• Question 190:

  Select four PeopleSoft field definition types. (Choose four.)

  A. VarChar
  B. Integer
  C. Number
  D. Binary
  E. Long Character
  F. BLOB
  G. Image
  H. ImageReference
  C. Number
  E. Long Character
  G. Image
  H. ImageReference