Exam 1z0-148 topic 1 question 42 discussion

Actual exam question from Oracle's 1z0-148

Question #: 42
Topic #: 1

[All 1z0-148 Questions]

Select a valid reason for using VARRAYS.

A. When the amount of data to be held in the collection is widely variable.
B. As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.
C. When you want to delete elements from the middle of the collection.
D. As a column in a table when you want to store no more than 10 elements in each row’s collection.

Show Suggested Answer

Suggested Answer: B 🗳️
Reference -
https://www.go4expert.com/articles/oracle-nested-tables-varrays-t20494/

by DmitryPDN at Feb. 5, 2020, 6:43 p.m.

Comments

Submit Cancel

chrishillinger

2 years, 9 months ago

Selected Answer: D

D sounds right - according to https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS99929 where it states "A varray is appropriate when: You know the maximum number of elements."

upvoted 1 times

...

CosminCof

4 years, 6 months ago

In my opinion is D

upvoted 4 times

...

jcamt

4 years, 7 months ago

D is the option because varrays are a good choice when the number of elements is known in advance https://docs.oracle.com/cd/B10501_01/appdev.920/a96624/05_colls.htm

upvoted 4 times

...

kahabe59

5 years, 2 months ago

D is the correct answer

upvoted 3 times

...

DmitryPDN

5 years, 4 months ago

Why not D? Varrays could be stored in table column and have strict limit for quantity of elements inside.

upvoted 2 times

...