최신Oracle PeopleSoft Application Develper I: PeopleTools and PeopleCode - 1Z0-241무료샘플문제
문제1
Examine this PeopleCode snippet:
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_EMPLOYEE;
Local Field &Fld_ROLE;
&RS_LEVEL0 = GetLevel0();
&ROW_LEVEL0 = &RS_Level0.GetRow(1);
&RS_LEVEL1 = &ROW_LEVEL0.GetRowSet(SCROLL.DEPT);
&ROW_LEVEL1 = &RS_LEVEL1(1);
&REC_EMPLOYEE = &ROW_LEVEL1.EMPLOYEE;
&FLD_EMPID = &REC_TASKRSRC.EMPID;
&ID = &FLD_EMPID.Value;
Can the code given above be replaced with the following statement?
&ID = GetField().Value
Examine this PeopleCode snippet:
Local Rowset &RS_Level0, &RS_Level1;
Local Row &Row_Level0, &Row_Level1;
Local Record &Rec_EMPLOYEE;
Local Field &Fld_ROLE;
&RS_LEVEL0 = GetLevel0();
&ROW_LEVEL0 = &RS_Level0.GetRow(1);
&RS_LEVEL1 = &ROW_LEVEL0.GetRowSet(SCROLL.DEPT);
&ROW_LEVEL1 = &RS_LEVEL1(1);
&REC_EMPLOYEE = &ROW_LEVEL1.EMPLOYEE;
&FLD_EMPID = &REC_TASKRSRC.EMPID;
&ID = &FLD_EMPID.Value;
Can the code given above be replaced with the following statement?
&ID = GetField().Value
정답: B
문제2
View this PeopleCode snippet:
If &MyVar = 0 then
&MyVar = 1;
End-if;
The &MyVar variable is not declared. What will be the result?
View this PeopleCode snippet:
If &MyVar = 0 then
&MyVar = 1;
End-if;
The &MyVar variable is not declared. What will be the result?
정답: A
문제3
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?
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
문제4
Select the two most likely reasons to specify an Add search record in a component. (Choose two.)
Select the two most likely reasons to specify an Add search record in a component. (Choose two.)
정답: B,D
문제5
View the Exhibits.
Based on this page layout and page order, select the two true statements about this page definition. (Choose two.)
View the Exhibits.
Based on this page layout and page order, select the two true statements about this page definition. (Choose two.)
정답: A,B
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
Examine this PeopleCode snippet:
class RO_ROWSET extends Rowset;
Which statement is true?
Examine this PeopleCode snippet:
class RO_ROWSET extends Rowset;
Which statement is true?
정답: B
문제7
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?
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?
정답: B
문제8
For the Employee Expenses application, a PeopleCode program could be placed either on the EMPLOYEE record or on the EMP_EXPENSE component. You decide to place it on the component.
Which is a valid reason for choosing to place the program on the component instead of the record?
For the Employee Expenses application, a PeopleCode program could be placed either on the EMPLOYEE record or on the EMP_EXPENSE component. You decide to place it on the component.
Which is a valid reason for choosing to place the program on the component instead of the record?
정답: E
문제9
Which is a valid use of errors and warnings in the PeopleCode row action events?
Which is a valid use of errors and warnings in the PeopleCode row action events?
정답: A
문제10
Select the three statements that are true about search records. (Choose three.)
Select the three statements that are true about search records. (Choose three.)
정답: B,C,D