Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 41:

  Examine the following code:

  andSQL = GetSQL(SQL.Absence_SQL, record.JOB, JOB.EMPLID); While andSQL.Fetch(andbegin, andstart); Which two statements are correct? (Choose two.)

  A. Absence_SQL is a SQL class.
  B. Absence_SQL is a SQL object.
  C. Absence_SQL is a SQL method.
  D. Absence_SQL is a SQL definition name.
  E. Absence_SQL contains a Delete clause.
  F. Absence_SQL contains a Select clause.
  G. Absence_SQL contains an Insert clause.
  D. Absence_SQL is a SQL definition name.
  F. Absence_SQL contains a Select clause.

• Question 42:

  View the Exhibit.

  PeopleCode is used to update the Grand Total field when a change is made to the Customer Orders page.

  On which three events should the program be placed? (Choose three.)

  

  A. RowInit
  B. RowDelete
  C. RowInsert
  D. FieldEdit
  E. FieldChange
  F. SavePreChange
  G. SavePostChange
  A. RowInit
  B. RowDelete
  E. FieldChange

• Question 43:

  Oracle's PeopleSoft Query uses query access group trees to control security of the tables in your PeopleSoft database. Which three statements are true regarding query access group trees? (Choose three.)

  A. You define a hierarchy of record components, based on logical or functional groupings, and then give users access to one or more branches of the tree.
  B. After you build your query access group trees, users are granted access by default to create new queries and to run existing queries, and they have the access rights to the record components that are used in the queries.
  C. Users can use PeopleSoft Query to retrieve information only from those tables with record definitions they have access to.
  D. You can create, view, and update query access group trees using PeopleSoft Query Access Manager.
  E. After you build a query tree, users can then generate queries on any tables that exist in the database.
  A. You define a hierarchy of record components, based on logical or functional groupings, and then give users access to one or more branches of the tree.
  C. Users can use PeopleSoft Query to retrieve information only from those tables with record definitions they have access to.
  D. You can create, view, and update query access group trees using PeopleSoft Query Access Manager.

• Question 44:

  View the Exhibit.

  This PeopleCode program uses a SQL Update to modify PSOPRDEFN, a table that is not in the component buffers.

  You want to be certain that this update will occur only if the entire component buffer is successfully written to the database.

  In which event or events should the program be placed?

  

  A. SaveEdit
  B. SavePreChange
  C. SavePostChange
  D. FieldEdit and SaveEdit
  E. SaveEdit and SavePostChange
  F. SavePreChange and SavePostChange
  C. SavePostChange

• Question 45:

  Select the three true statements about PeopleSoft field definitions. (Choose three.)

  A. All PeopleSoft field definition names are in uppercase.
  B. Date, Time, and DateTime fields all have a fixed length.
  C. When you work with Number and Signed Number field types, the sum of integer and decimal positions must be less than or equal to 40.
  D. Altering an existing field definition's default label can have consequences at both the record definition level and the page definition level.
  E. For a Long Character field, enter a field length of 256 to enable the database platform to determine the maximum length of the field.
  A. All PeopleSoft field definition names are in uppercase.
  B. Date, Time, and DateTime fields all have a fixed length.
  D. Altering an existing field definition's default label can have consequences at both the record definition level and the page definition level.

• Question 46:

  Select the three true statements regarding search keys. (Choose three.)

  A. Search key fields are indexed.
  B. Search key fields appear on the search page.
  C. A fieldcan be a search key even if it is not a key.
  D. Selecting the Search Key option automatically selects the List Box Item option.
  E. If an existing key field is changed to a search key, you must alter or rebuild the table.
  F. The search key property is irrelevant if the record definition is not used as a search record.
  A. Search key fields are indexed.
  B. Search key fields appear on the search page.
  D. Selecting the Search Key option automatically selects the List Box Item option.

• Question 47:

  You write a PeopleCode program that checks whether the user is selecting an existing search key value on the Search page or creating a new search key value. Which system variable do you use?

  A. %Add
  B. andAdd
  C. %Mode
  D. andMode
  E. %Search
  F. andSearch
  C. %Mode

• Question 48:

  The Run Status column on the Process List page indicates the current state of a process.

  Assume that the Process Scheduler server is running, which three statements are true regarding the Run Status column on the Process List page? (Choose three.)

  A. Initiated status indicates that a PeopleSoft Process Scheduler Server has acknowledged the new request. At this time, PeopleSoft Process Scheduler validates the parameters that are associated with this request and submits the command line to start the process.
  B. Queued status indicates that this process has successfully initiated the program and the program is running.
  C. Pending status indicates that this item is waiting for a previous item in the job before PeopleSoft Process Scheduler releases this item. When the previous item has completed successfully, PeopleSoft Process Scheduler changes the status of the item to Queued.
  D. Processing status indicates that PeopleSoft ProcessScheduler has successfully initiated the program, and that the program is running.
  E. No Success status is same as the Error status, which indicates that the program that is associated with the process request encountered an error while processing transactions within the program.
  A. Initiated status indicates that a PeopleSoft Process Scheduler Server has acknowledged the new request. At this time, PeopleSoft Process Scheduler validates the parameters that are associated with this request and submits the command line to start the process.
  C. Pending status indicates that this item is waiting for a previous item in the job before PeopleSoft Process Scheduler releases this item. When the previous item has completed successfully, PeopleSoft Process Scheduler changes the status of the item to Queued.
  D. Processing status indicates that PeopleSoft ProcessScheduler has successfully initiated the program, and that the program is running.

• Question 49:

  Select three uses for PeopleSoft application classes. (Choose three.)

  A. Organizing code into logical packages
  B. Encapsulating complex data structures
  C. Creating platform-independent applications
  D. Extending the general classes with subclasses
  E. Expediting application design with rapid prototyping
  A. Organizing code into logical packages
  B. Encapsulating complex data structures
  D. Extending the general classes with subclasses

• Question 50:

  You are testing a completed application and you see an incorrect label on one field on the page. Select the option that is the best course of action to correct this problem.

  A. Change the item label name in the component definition.
  B. Select the correct record field label on the record definition.
  C. Enter the correct field label as text on the page field definition.
  D. Change the default label on the field definition to the correct label.
  B. Select the correct record field label on the record definition.