×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You have a query that retrieves data for employees who took vacation for a specific duration (for example,
two weeks). You want to change this query so that it will prompt the user to enter a value for the duration of
the vacation. To achieve this result, which action would you take?
two weeks). You want to change this query so that it will prompt the user to enter a value for the duration of
the vacation. To achieve this result, which action would you take?
2.
Which PeopleCode statement would you use to instantiate a row object for the current row?
3.
Select the object-oriented equivalent.
Examine this PeopleCode snippet:
&Date = ORDER.DATE;
&Date = ORDER.DATE;
Select the object-oriented equivalent.
4.
A PeopleCode program uses an Evaluate construct to change the display characteristics of a page based
on how the user accessed the page.
For instance, if the user accesses the page through Employee Self Service, the program will hide some
elements, but if the user accesses the page through Manage Human Resources, those elements are
visible.
Which system variable does Evaluate check?
on how the user accessed the page.
For instance, if the user accesses the page through Employee Self Service, the program will hide some
elements, but if the user accesses the page through Manage Human Resources, those elements are
visible.
Which system variable does Evaluate check?
5.
Select the correct use of the MsgGet function.
6.
Select the correct statement.
Examine this PeopleCode snippet:
Local Rowset &RS1;
&RS1 = CreateRowset(RECORD.PSU_CUST_TBL);
&Customer = "XYZ";
&RS1.Fill("WHERE CUSTOMER_ID =:1", &Customer);
Local Rowset &RS1;
&RS1 = CreateRowset(RECORD.PSU_CUST_TBL);
&Customer = "XYZ";
&RS1.Fill("WHERE CUSTOMER_ID =:1", &Customer);
Select the correct statement.
7.
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
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
8.
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?
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?
9.
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?
the Search page or creating a new search key value. Which system variable do you use?
10.
Examine this PeopleCode snippet:
class OCP_ROWSET extends Rowset;
property integer FilledRowCount get;
method OCP_ROWSET(&strRecName As string, &strDataFld As string, &strGetOrCreate As string);
method InsertRow(&iRow As integer) Returns boolean;
Select the correct statements. (Choose all that apply.)