Which two statements are true about associative arrays and nested tables? (Choose two.)

The correct answer is B. Only associative arrays can use numbers and strings for subscripts. C. Both associative arrays and nested tables can hold an arbitrary number of elements. Associative arrays, also known as index-by tables, let you look up elements using arbitrary numbers and strings for subscript values. These are similar to hash tables in other programming languages. Nested tables hold an arbitrary number of elements. They use sequential numbers…

Writing Executable Statements

Question

Options

AOnly associative arrays can hold an arbitrary number of elements.
BOnly associative arrays can use numbers and strings for subscripts.
CBoth associative arrays and nested tables can hold an arbitrary number of elements.
DBoth associative arrays and nested tables can use numbers and strings for subscripts.

How the community answered

(66 responses)

A
20% (13)
B
71% (47)
D
9% (6)

Explanation

Associative arrays, also known as index-by tables, let you look up elements using arbitrary numbers and strings for subscript values. These are similar to hash tables in other programming languages. Nested tables hold an arbitrary number of elements. They use sequential numbers as subscripts. You can define equivalent SQL types, allowing nested tables to be stored in database tables and manipulated through SQL.

Topics

#associative arrays#nested tables#collection subscripts#collection capacity

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice