Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Colombo
YEYE 3 in 1 Instant Coffee Mix 50 Sachet
Romeshka
Updated:
Yesterday at 12:16 AM
Colombo
Red Hat Certified System Administrator (RHCSA) - RHEL 10
Sanjeewani95
Updated:
Friday at 7:43 PM
NURSING , CAREGIVER , HOTEL & BEAUTY COURSES
IVA Para Medical Campus
Updated:
Jul 2, 2026
Handmade Character Soft Toys Peppa Pig Family
anil1961
Updated:
Jul 1, 2026
Ad icon
Video Content Creator
pramukag
Updated:
Jun 28, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
Education
Oracle 1z0-242 exam paper share
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Nacyym" data-source="post: 5445614" data-attributes="member: 154122"><p>Evaluate this PeopleCode snippet.</p><p>Local Array of Number &MyArray;</p><p>Local Any &Len, &Result;</p><p>&MyArray = CreateArray(3);</p><p>&MyArray[1] = 100;</p><p>&MyArray[2] = 200;</p><p>&MyArray[3] = 300;</p><p>&Result = &MyArray.POP();</p><p>&Len = &MyArray.LEN;</p><p>&End = &MyArray[&Len];</p><p>What are the correct values for &Result and &End?</p><p>A. &Result is 300</p><p>&End is 200</p><p>B. &Result is 300</p><p>&End is Null</p><p>C. &Result is 300</p><p>&End is 300</p><p>D. &Result is Null</p><p>&End is 300</p><p>E. &Result is 100</p><p>&End is 300</p><p>Answer: A</p><p> Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.</p><p>&SQL = CreateSQL(”Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TAS</p><p>PSU_TASK_TBL.TASK);</p><p>&Var1 = &SQL.Fetch(&Var2);</p><p>Select the two correct statements. (Choose two.)</p><p>A. &Var2 specifies which row to fetch.</p><p>B. &Var2 specifies which field to fetch.</p><p>C. &Var1 is populated with TRUE if a row is fetched.</p><p>D. &Var1 is populated with the number of rows returned.</p><p>E. &Var2 is populated with EFFORT_AMT from the row fetched.</p><p>F. &Var1 is populated with EFFORT_AMT from the row fetched.</p><p>G. &Var1 is populated with EFFORT_AMT from the first row returned.</p><p>Answer: CE</p><p> 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 .</p><p><a href="http://www.killtest.com/OtherOracleCertification/1Z0-242.asp" target="_blank">Oracle exams</a></p><p><a href="http://www.killtest.com/OtherOracleCertification/1Z0-242.asp" target="_blank"></a></p></blockquote><p></p>
[QUOTE="Nacyym, post: 5445614, member: 154122"] 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 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 . [URL="http://www.killtest.com/OtherOracleCertification/1Z0-242.asp"]Oracle exams [/URL] [/QUOTE]
Insert quotes…
Verification
Asuwa dahayen wadi kalama keeyada?
Post reply
Top
Bottom