exam questions

Exam 1z0-148 All Questions

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

Exam 1z0-148 topic 1 question 24 discussion

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


Which two statements are correct about the collections before v3. DELETE is executed?

  • A. The values of v3(31) (2) and v3 (33) (2) are identical.
  • B. The value of v3 (31) (3) is 6.
  • C. The value of v3 (31) (1) and v3 (33) (3) are identical,
  • D. The value of v3 (31) (1) is "hello".
  • E. The values of v3 (32) (2) and v1 (2) are identical.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

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
Tinamoran
Highly Voted 5 years, 3 months ago
CE v3(31)(2) = 1 v3(32)(2) = 5 v3(33)(1) = 1 v3(33)(3) = 1 v3(32)(2) = world v1(2) = world
upvoted 9 times
...
Rakeshpro
Most Recent 2 years, 4 months ago
Selected Answer: CE
DECLARE TYPE ntbl IS TABLE OF VARCHAR2(20); v1 ntbl := ntbl('hello', 'world', 'test'); TYPE ntb2 IS TABLE OF ntbl INDEX BY PLS_INTEGER; v3 ntb2; BEGIN dbms_output.put_line(v1.count); --3 dbms_output.put_line(v3.count); --0 v3(31) := ntbl(4, 5, 6); dbms_output.put_line(v3.count); --1 dbms_output.put_line(v3(31)(1) || ' ' || v3(31)(2) || ' ' || v3(31)(3)); --4 5 6 v3(32) := v1; dbms_output.put_line(v3.count); --2 dbms_output.put_line('Test: ' || v3(32)(1) || ' ' || v3(32)(2) || ' ' || v3(32)(3)); --hello world test v3(33) := ntbl(2,5,1); dbms_output.put_line(v3.count); --3 dbms_output.put_line(v3(33)(1) || ' ' || v3(33)(2) || ' ' || v3(33)(3)); --2 5 1 v3(31) := ntbl(1,1); dbms_output.put_line(v3.count); --3 dbms_output.put_line(v3(31)(1) || ' ' || v3(31)(2)); --1 1 v3.DELETE; --DELETE all elements dbms_output.put_line(v3.count); --0 END;
upvoted 1 times
...
chrishillinger
2 years, 5 months ago
Selected Answer: CE
CE is correct
upvoted 1 times
...
Benjmaz
4 years ago
E. is the only only answer. The statement says what is the value of the collection before v3.DELETE
upvoted 1 times
Benjmaz
4 years ago
C, E. are correct
upvoted 1 times
...
...
CosminCof
4 years, 2 months ago
CE is the correct answer
upvoted 1 times
CosminCof
4 years, 1 month ago
A. v3(31)(2) = 1; v3(33)(2) = 5; B. v3(31)(3) -> doesen't exist C. v3(31)(1) = 1; v3(33)(3) = 1; D. v3(31)(1) = 1; E. v3(32)(2) = 'world'; v1(2) = 'world';
upvoted 1 times
...
...
olkaolka
4 years, 6 months ago
A,B,E Did it at server
upvoted 2 times
Skiv
4 years, 4 months ago
dbms_output.put_line(v3(31)(1) || ',' || v3(31)(2) || ',' || v3(31)(3)); dbms_output.put_line(v3(32)(1) || ',' || v3(32)(2) || ',' || v3(32)(3)); dbms_output.put_line(v3(33)(1) || ',' || v3(33)(2) || ',' || v3(33)(3)); dbms_output.put_line(v3(34)(1) || ',' || v3(34)(2)); if v3(31)(2) = v3(33)(2) or (v3(31)(2) is null and v3(33)(2) is null) then dbms_output.put_line('A'); end if; if v3(31)(3) = cast(6 as number) then dbms_output.put_line('B'); end if; if v3(31)(1) = v3(33)(3) or (v3(31)(1) is null and v3(33)(3) is null) then dbms_output.put_line('C'); end if; if v3(31)(1) = 'hello' then dbms_output.put_line('D'); end if; if v3(32)(2) = v1(2) or (v3(32)(2) is null and v1(2) is null) then dbms_output.put_line('E'); end if; output: 4,5,6 hello,world,test 2,5,1 1,1 A B E not B because v3(31)(3) = '6', not 6?
upvoted 1 times
...
...
Adela_bg
4 years, 7 months ago
CE v3(31)(1): = v3(33)(3) 1 = 1 v3(32)(2): = v1(2) world = world
upvoted 1 times
...
szefco
4 years, 8 months ago
I think correct answers are: AE
upvoted 1 times
krazzygenius
4 years, 5 months ago
A is wrong see the last statement in the question.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago