PeopleSoft Application Developer II: App Engine & Integration:1z0-242 exam
Wednesday, August 19th, 2009“Oracle Other Certification “, also known as 1z0-242 exam, is a Oracle certification.
Preparing for the 1z0-242 exam? Searching 1z0-242 Test Questions, 1z0-242 Practice Exam, 1z0-242 Dumps?
With the complete collection of questions and answers, Test4actual has assembled to take you through 100 Q&A to your 1z0-242 exam preparation. In the 1z0-242 exam resources, you will cover every field and category in Oracle Other Certification helping to ready you for your successful Oracle Certification.
Free 1z0-242 Demo Download
Test4actual offers free demo for Oracle Other Certification 1z0-242 exam (PeopleSoft Application Developer II: App Engine & Integration). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Exam Details
The Oracle Other Certification exam is the qualifying exam available to candidates pursuing a single-exam option for the Oracle Certified Network Associate Oracle Other Certification certification. The Oracle Other Certification (1z0-242) exam will test materials from the new Interconnection Oracle Network Devices (ICND) course as well as the new Introduction to Oracle Networking Technologies (INTRO) course. The exam will certify that the successful candidate has important knowledge and skills necessary to select, connect, configure, and troubleshoot the various Oracle networking devices. The exam covers topics on Extending Switched Networks with VLANS, Determining IP Routes, Managing IP traffic with Access Lists, Establishing Point-to-Point connections, and Establishing Frame Relay Connections.
FREE DEMO:
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
3. The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to
write a PeopleCode program to create a standalone
rowset that will load data from the ITEM table into
the data buffer. Select three PeopleCode statements that can be used with standalone
rowsets. (Choose
three.)
A. &RS_Item = GetRowSet(SCROLL.ITEM);
B. &RS_Item = CreateRowSet(RECORD.ITEM);
C. &Price = &RS_Item(&i).ITEM.PRICE.Value;
D. &RS_Item.Select(”Where ITEM = :1″, CUST_ORDER.ITEM);
E. &RS_Item.Fill(”Where CUST_TYPE = :1″, CUST_ORDER.TYPE);
F. &RS_Item = ScrollSelect(1,Scroll.ITEM, Record.ITEM, (”Where CUST_TYPE = :1″, CUST_ORDER.
CUST_TYPE);
Answer: BCE
4. The Get Student Enrollments page uses a PeopleCode program to select and display rows based on
user input. When the user clicks Refresh, FieldChange PeopleCode populates a standalone
rowset using
a Select method. When you test the program, the new rows are appended to the previous rows instead of
replacing them. How do you fix this problem?
A. Use a work scroll instead of a standalone
rowset.
B. Add &Rowset.Flush(); after the Select method.
C. Use an Update method instead of a Select method.
D. Add &Rowset.Flush(); before the Select method.
E. Add &Rowset.Refresh (); after the Select method.
F. Add &Rowset.Refresh(); before the Select method.
Answer: D
5. Examine the join in this Select statement:
SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE A.TASK = B.TASK
AND A.RESOURCE = B.RESOURCE
Select the equivalent Select statement.
A. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(A.TASK, B.RESOURCE)
B. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE
%Common(PROJECT A, EFFORT B)
C. SELECT A.TASK , B.EFFORT_AMT
FROM %Common(KEYS, PROJECT A, EFFORT B)
D. SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT B)
E. SELECT A.TASK , B.EFFORT_AMT
FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)
Answer: E