1Z0-242 Other Oracle Certification Braindump
ExamSoon 1Z0-242 Exams
Oracle PeopleSoft Application Developer II: App Engine & Integration
O rder : 1Z0-242 Exam
Practice Exam: 1Z0-242
Exam Number/Code: 1Z0-242
Exam Name: PeopleSoft Application Developer II: App Engine & Integration
Questions and Answers: 100 Q&As
Free 1Z0-242 Braindumps
Exam : Oracle 1Z0-242
Title : Oracle Spplication Server 10g:Administration II
1. How do you configure Process Scheduler to initiate an Application Engine trace for SQL and Step?
A. Add %%TRACE%% %%SQL%% %%STEP%% to the parameter list for the Process Type.
B. On the Run Control page, select the SQL Trace and Step Trace check boxes.
C. On the Process Monitor page, select the SQL Trace and Step Trace check boxes.
D. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE 3.
E. On the Process Definition Override Options page, for Parameter List, select Append and enter -TRACE SQL STEP.
F. On the Process Definition Override Options page, for Parameter List, select Append and enter %%TRACE%% %%
SQL%% %%STEP%%.
Answer: D
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
3. 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 &R