OCA OCP Oracle Certification Exam Braindumps

High quality and Value for the 1Z0-242 Exam.
 Killtest Practice Exams for PeopleSoft Application Developer II: App Engine & Integration 1Z0-242 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your Other Oracle Certification exam and get your Other Oracle Certification Certification.

We guarantee your success in the first attempt. If you do not pass the 1Z0-242 exam (PeopleSoft Application Developer II: App Engine & Integration) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. Killtest will help you to pass the 1Z0-242 exam. TestPassport 1Z0-242 contains 100 questions, multiple choice answers.

1. Evaluate this PeopleCode snippet.
Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
&End is 200
B. &Result is 300
&End is Null
C. &Result is 300
&End is 300
D. &Result is Null
&End is 300
E. &Result is 100
&End is 300
Answer: A

2. Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
   &SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1",

PSU_TASK_TBL.TASK);
   &Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE