ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 12 discussion

Actual exam question from Oracle's 1z0-148
Question #: 12
Topic #: 1
[All 1z0-148 Questions]

Examine this block:

Which two will be correct after line 5?

  • A. va. LAST and va. LIMIT will return the same value.
  • B. va. LAST and va. COUNT will return the same value.
  • C. va. LIMIT and va. COUNT will return the same value.
  • D. va. LIMIT and va. NEXT (199) will return the same value.
  • E. va. LAST will return 200.
  • F. va. NEXT (199) will return NULL.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by Swetank123 at Nov. 2, 2019, 4:18 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Swetank123
Highly Voted 5 years, 3 months ago
Correct Answer will B and F because limit will be 200 count will be 100 and last will be 100 and next(199) will return null.
upvoted 9 times
szefco
4 years, 8 months ago
Confirm: B and F are correct answers: DECLARE TYPE va$ IS VARRAY(200) OF NUMBER; va va$ := va$(); BEGIN va.EXTEND(100); dbms_output.put_line('va.LIMIT = ' || va.LIMIT); dbms_output.put_line('va.LAST = ' || va.LAST); dbms_output.put_line('va.COUNT = ' || va.COUNT); dbms_output.put_line('va.NEXT(199) = ' || va.next(199)); end; Statement processed. va.LIMIT = 200 va.LAST = 100 va.COUNT = 100 va.NEXT(199) =
upvoted 6 times
...
...
Angelos_ang
Most Recent 2 years, 4 months ago
Selected Answer: BF
B & F!
upvoted 1 times
...
Rakeshpro
2 years, 4 months ago
DECLARE TYPE va$ IS VARRAY(200) OF NUMBER; va va$ := va$(); BEGIN va.EXTEND(100); DBMS_OUTPUT.PUT_LINE('count: ' || va.count); --100 DBMS_OUTPUT.PUT_LINE('limit: ' || va.limit); --200 DBMS_OUTPUT.PUT_LINE('first: ' || va.first); --1 DBMS_OUTPUT.PUT_LINE('last: ' || va.last); --100 DBMS_OUTPUT.PUT_LINE('va(1): ' || va(1)); --null DBMS_OUTPUT.PUT_LINE('va(100): ' || va(100)); --null --DBMS_OUTPUT.PUT_LINE('va(101): ' || va(101)); --ORA-06533: Subscript beyond count DBMS_OUTPUT.PUT_LINE('va.next(1): ' || va.next(1)); --2 DBMS_OUTPUT.PUT_LINE('va.next(99): ' || va.next(99)); --100 DBMS_OUTPUT.PUT_LINE('va.next(100): ' || va.next(100)); --null END; /
upvoted 1 times
Rakeshpro
2 years, 4 months ago
http://www.dba-oracle.com/t_adv_plsql_next_prior_methofs.htm
upvoted 1 times
Rakeshpro
2 years, 4 months ago
Answer is B & F
upvoted 1 times
...
...
...
chrishillinger
2 years, 5 months ago
Selected Answer: BF
As already said by the other comments
upvoted 1 times
...
CosminCof
4 years, 2 months ago
BF the right answer
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago