Oracle 1Z0-241 Online Practice Questions and Exam Preparation

Oracle 1Z0-241 Online Questions & Answers

• Question 101:

  Which three statements are true when you want to view queries? (Choose three.)

  A. You can view all public queries, and private queries that are in your list of queries.
  B. If you want to run queries that are not saved in PeopleSoft Query, you can use the Run page in Query Manager.
  C. Query Viewer is a version of Query Manager. It has the same functions, but in a different view.
  D. You can run a predefined query from your browser and view it online using any of the following links on the Query Manager search page: HTML, Excel, or Schedule.
  E. If you want to run multiple queries and run each query multiple times with different run-time prompt values, the Run page is more useful than the HTML, Excel, or Schedule links on the Query Manager search page.
  B. If you want to run queries that are not saved in PeopleSoft Query, you can use the Run page in Query Manager.
  D. You can run a predefined query from your browser and view it online using any of the following links on the Query Manager search page: HTML, Excel, or Schedule.
  E. If you want to run multiple queries and run each query multiple times with different run-time prompt values, the Run page is more useful than the HTML, Excel, or Schedule links on the Query Manager search page.

• Question 102:

  Select the three primary purposes for SQL views in PeopleSoft applications. (Choose three.)

  A. Reporting
  B. Filtering rows
  C. Joining tables
  D. Assigning aliases
  E. Rearranging columns
  B. Filtering rows
  C. Joining tables
  E. Rearranging columns

• Question 103:

  Select the two rules about PeopleSoft prompt table mechanics. (Choose two.)

  A. The prompt matches fields based on name, data type, and length.
  B. The prompt automatically filters the rows based on higher-level key values in the buffer.
  C. The prompt selects the highest-level key on the prompt record definition unless the EFFDT field is present.
  D. The prompt automatically selects for the lowest-level key on the prompt record definition ignoring the EFFDT and EFF_STATUS fields.
  B. The prompt automatically filters the rows based on higher-level key values in the buffer.
  D. The prompt automatically selects for the lowest-level key on the prompt record definition ignoring the EFFDT and EFF_STATUS fields.

• Question 104:

  You add the STREET2 field to the existing PS_ADDRESS_SBR subrecord. What do you do next?

  A. Alter the PS_ADDRESS_SBR subrecord and test the alter.
  B. Build the PS_ADDRESS_SBR subrecord and test the build.
  C. Alter the record definitions that reference the PS_ADDRESS_SBR and test the alter.
  D. Build the record definitionsthat reference the PS_ADDRESS_SBR and test the build.
  C. Alter the record definitions that reference the PS_ADDRESS_SBR and test the alter.

• Question 105:

  Within the component processor flow, the component build process is a loop that executes until _____.

  A. the End Build marker is reached
  B. the entire component-level PeopleCodeexecutes
  C. all the page elements are retrieved and displayed
  D. all the rows in the record are loaded into the buffer
  E. all the rows that were selected from the database are loaded into the buffer
  E. all the rows that were selected from the database are loaded into the buffer

• Question 106:

  The Order table includes (among other fields) a customer ID and an amount for each item that was ordered. An existing query returns the same number of rows as are in the table. For example, if John ordered 10 items, you would see 10 rows with his ID in the customer ID column.

  You want to determine how much each customer has ordered, so you need a query that displays just one row for each customer ID and amount field. The value of the amount field in John row would be the sum of the values from the 10 rows.field. The value of the amount field in John? row would be the sum of the values from the 10 rows.

  How would you calculate how much each customer has ordered?

  A. Apply the aggregate function Sum to the amount field.
  B. Add a prompt query to further refine the query when it is run.
  C. Define expressions to calculate how much each customer has ordered.
  D. Define a HAVING criterion to display how much each customer has ordered.
  A. Apply the aggregate function Sum to the amount field.

• Question 107:

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

• Question 108:

  Select four field definition types that appear in the Field Definition Type drop-down list box when you create a new field definition in Application Designer. (Choose four.)

  A. Character
  B. Integer
  C. Number
  D. Signed Number
  E. Attachment
  F. BLOB
  G. Binary
  A. Character
  C. Number
  D. Signed Number
  E. Attachment

• Question 109:

  View the Exhibit.

  Based on this Build dialog box, select the two options that are true. (Choose two.)

  

  A. When you click the Build button, the TS_EMP tables are created.
  B. When you click the Build button, nothing happens to your database.
  C. When you click the Build button, the TS_EMP tables may lose existing data.
  D. When you click the Build button, the TS_INSTSCHD_VW view is created.
  E. When you click the Build button, Application Designer generates a script file.
  B. When you click the Build button, nothing happens to your database.
  E. When you click the Build button, Application Designer generates a script file.

• Question 110:

  Select the three true statements about levels on a page. (Choose three.)

  A. You usually associate level zero with the search record.
  B. Each level is associated with one primary record definition.
  C. Related fields in a level must reference the same record definition.
  D. All fields in a level must write to that level's primary record definition.
  E. Multiple levels of the same number, for example, two level twos, are allowed on a page.
  A. You usually associate level zero with the search record.
  B. Each level is associated with one primary record definition.
  E. Multiple levels of the same number, for example, two level twos, are allowed on a page.