View the Exhibit. A PeopleCode program at level 0 checks the values for Percent Available (PCT_AVAILABLE) at level 1. Analyze this code snippet. Local Rowset &RS_Level0, &RS_Level1; Local Row &Row_Level0, &Row_Level1; Local Record &Rec_TaskRsrc; Local Field & Fld_PctAvail ; &RS_Level0…

The Get Student Enrollments page uses a PeopleCode program to select and display rows based on user input. When the user clicks Refresh, FieldChange PeopleCode populates a stand-alone rowset using a Select method. When you test the program, the new…

Examine the join in this Select statement: SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT B WHERE A.TASK = B.TASK AND A.RESOURCE = B.RESOURCE Select the equivalent Select statement. A. SELECT A.TASK , B.EFFORT_AMT FROM PS_PROJECT A , PS_EFFORT…

A Process Scheduler process is configured to run an Application Engine program. You need to modify the process to use parameters entered by the user at run time. Which four additional steps do you need to take? (Choose four.) A.…

View the Exhibit. This run control page executes an Application Engine program that updates the Course table using the parameters entered by a user. In addition to the run control page, which three elements must be in place? (Choose three.)…

Select three Application Engine action types that can be used to control program flow. (Choose three.) A. Log Message B. Call Section C. XSLT D. PeopleCode E. Do While F. Evaluate

You modify an Application Engine program to use parallel processing with temporary tables. The Application Engine program includes this code snippet, which is part of a SQL statement that inserts rows into a temporary table. INSERT INTO PS_CRS_FULL_TMP What changes…

An Application Engine program uses a Do Select action. What occurs when the Select statement is executed? A. Each row returned by the Select statement is stored in the state record. The Select statement continues until no more rows are…

If Review Type is Peer or Performance, then the prompt for Reviewer ID returns all employees. Select the three steps required to implement this business rule. (Choose three.) A. Associate the REVIEWER_ID field with REVIEWER_VW. B. Create REVIEWER_VW as a…

You want to examine the component buffer for the Customer Orders (PSU_CUST_ORDER ) component. Which four steps are necessary? (Choose four.) A. Start the PeopleCode Debugger and set a breakpoint. B. Access the Structure view on the PSU_CUST_ORDER component. C.…