Oracle Database 11g: Administrator I : 1z1-052 Exam

Killtest provides all kinds of Oracle exams ,and we can offer you latest exam materials , such as practice exams ,dumps in pdf and sorftware format,after you buy the right product , we can send you both to you ,it is conveniently for you to read ,pdf one you can printed it out , and the test engine one you can read it as real exam .

1Z0-242: please download 1Z0-242 in Software format Demo

For an example :

 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

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