1Z0-241 Exam Questions

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 d...

Which three statements are true regarding Query Profile? (Choose three.)

Examine this PeopleCode snippet: class OCP_ROWSET extends Rowset; property integer FilledRowCount get; method OCP_ROWSET(&strRecName As string, &strDataFId As string, &strGetOrCrea...

View the Exhibit. [Image of an error message box: "SQL error. Smt #: 601. Error Position: 0. Return: 601 - [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PS_TS...

Are parameters passed to user-defined internal and external PeopleCode functions by reference or by value?

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

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

Here is a partial list of events in the Component Processor flow. 1. SQL select 2. Search page 3. Record defaults 4. Add row to buffer 5. Standard system field edits 6. Wait for us...

Select the three primary advantages of using the Message Catalog. (Choose three.)

View the Exhibits. [Image of two "Student ID" pages, one for "Course Code" and "Course Description", the other for "Skill" and "Description" and "Proficiency"] Examine the two page...

Select the four items that you can use as translate values for the COLOR field. (Choose four.)

View the Exhibit. What is OCP?

You attempt to drag the ADDR_SBP subpage into the PSU_HOTEL page. The insert gives you an error and fails. Select the most likely reason why this occurred.

Examine this PeopleCode snippet: Local Rowset&RS_Level0, &RS_Level1; Local Row &Row_Level0, &Row_Level1; Local Record &Rec_EMP; Local Field &Fld_ROLE; &RS_Level0 = GetRowset(0); &R...

View the Exhibit. You design the shown page. You write PeopleCode on the Review Type field that enables the Reviewer ID field for any review type other than Self Assessment. Select...

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...

View the Exhibit. This FieldChange program conditionally populates DERIVED.EDITTABLE, based on the value of PSU_EMP_RVW_RVR.REVIEW_TYPE. Another similar program should be placed in...

In Crystal Reports, you use the Design tab to format reports. Which three statements are true regarding the usage of the Design tab? (Choose three.)

View the Exhibit. You access a content reference and see the search page shown. Select the property that you must change so that the search page title is more descriptive.

Which PeopleCode event is used to populate a field only if the field is empty?

Select the two true statements about the Web server and the application server. (Choose two.)

Match each description with a PeopleCode data buffer access object. a. A component scroll b. Consists of one or more records of data c. Can have zero, one, or more child rowsets d....

View the Exhibit. Select the advanced search page that this record definition will generate. (Exhibit shows a record definition for PSU_CRSE_SRCH)

The Customer Orders page has a requirement that Order Status cannot be changed to Closed if Fill Status is ' ' for any row in Order Details. You write a FieldChange PeopleCode prog...

Select two options that demonstrate referential integrity in PeopleSoft applications. (Choose two.)

A SQL object is instantiated using the following statement: &SQL = CreateSQL("Select EFFORT_SPENT from PS_TASK_TBL where TASK=:1", TASK=TASK.TASK); Which PeopleCode statement can b...

You run this SQL statement in your query tool: SELECT * FROM DBA_OBJECTS; Assuming that the syntax is correct for your platform, what does the statement select from?

Fill in the blanks using PeopleCode data buffer access classes. A record object contains at least one ____ object. One ____ object can be instantiated to represent the entire compo...

You click a content reference to access a component. You should see a search page, but instead the component is displayed immediately with a row of data from the table. Select the...

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

Select two parts of the Message Catalog. (Choose two.)

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

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 on...

Which two PeopleCode snippets contain syntax errors? (Choose two.)

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

The View Log/Trace page enables you to view the output file, message log, and trace file in a browser. Select the conditions that, if satisfied, will display the View Log/Trace lin...

View the Exhibit. The student Personal Details page writes to the PS_STUDENT table. If the "Same address as Customer" check box is selected on the Student Personal Details page, as...

Why would you choose to reference a derived/work field in a PeopleCode program, rather than aPeopleCode variable?

Select the record definitions that are correctly configured as A) a control table and B) a transaction table, respectively.

Examine the Use tab of this component definition and then select the two true statements. (Choose two.)

You are importing the DEV_COURSE project from a file. Select the two files that must be present in the DEV_COURSE folder. (Choose two.)

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.

The Component Processor's flow can be used to simulate a looping construct. In which event would a PeopleCode program designed to take advantage of this feature be placed?

View the Exhibit. This PeopleCode program compares two editable fields on a component. Which event or events should the program be placed in?

When a user change triggers an error, you want PeopleCode to position the cursor in the field that triggered the error. What is the correct syntax?

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

Select the two true statements about PeopleSoft Pure Internet Architecture. (Choose two.)

On a page definition, which control is most like a link?

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....

View the Exhibit. You attempt to access a component through a content reference and the shown error appears. Select the most appropriate course of action to identify the error.