Oracle 26ai Object Queries and Collection Indexes - Quiz

Each question is worth one point, for 5 points total. Select one answer per question. Unanswered or invalid responses receive no credit.

1. Which size distinction between VARRAYs and nested tables is correct in Oracle 26ai? Select the one best answer.
	A. A VARRAY is always a stored row object, while a nested table is always an ordinary relational table.
	B. VARRAYs can be declared only inside PL/SQL and cannot be queried with SQL.
	C. A VARRAY has a declared maximum element count; a nested-table type declares no maximum count, although resource limits still apply.
	D. A VARRAY contains its maximum number of elements immediately after the type is created.

2. An object table persons has an embedded addr object with a city attribute. With table alias p, which query selects that scalar city? Select the one best answer.
	A. SELECT p.city FROM persons p;
	B. SELECT p.addr.city FROM persons p;
	C. SELECT REF(p) FROM persons p;
	D. SELECT VALUE(p) FROM persons p;

3. Which statement about PL/SQL collection indexes is correct in Oracle 26ai? Select the one best answer.
	A. VARRAYs and nested tables use integer indexes; associative arrays can use PLS_INTEGER or string keys.
	B. Every PL/SQL collection requires a string key.
	C. String-indexed associative arrays are standalone SQL types that can be stored directly as table columns.
	D. A nested table preserves its PL/SQL indexes as permanent business identifiers when stored and retrieved.

4. Which query returns each complete person object instance from the object table persons, using table alias p? Select the one best answer.
	A. SELECT REF(p) FROM persons p;
	B. SELECT p.addr.city FROM persons p;
	C. SELECT VALUE(p) FROM persons p;
	D. SELECT COUNT(*) FROM persons p;

5. Which statement about a REF column constrained with SCOPE IS persons is correct in Oracle 26ai? Select the one best answer.
	A. It restricts the referenced object table, but a reference can still become dangling.
	B. It guarantees that every referenced row exists, exactly like a referential integrity constraint.
	C. It stores a complete independent copy of every person object.
	D. It allows references to row objects in any compatible object table.

Submit