PL/SQL Nested Table
define type | declare instance | assign with constructor
Order (separated with | character) the steps to setting up and populating a nested table collection in PL/SQL?(declare type | define type | declare instance | define instance | assign with := | assign with constructor )
last to first
Starting with counter := c.LAST; (WHILE counter IS NOT NULL LOOP) counter :=c.PRIOR(counter) in the loop will process elements from? (first to last or last to first)
some elements
Nested tables are suitable for queries and updates that affect? (all elements or no elements or some elements)
can become sparse
An array is always dense. A nested table? (is always dense or can become sparse)
unbounded
An array is bounded. A nested table is?(bounded or unbounded)
parameter
A nested table can be passed to and from functions and procedures as a?
both
A nested table reference, such as names_tab(3) can be used on which sides of an assignment? (left or right or none or both)
not preserved
During the process of database storage and retrieval of a nested table, the order and subscripts are? (preserved or not preserved)
COUNT
For a nested table with no deleted elements, the LAST method returns the same as?(what other method)
cats := category_type(1,2,3,4);
Given a nested table collection named "category_type", how would an instance named "cats" be initialised with the values "1,2,3,4"?
names_tab(3)
Given the nested table collection: TYPE names_type IS TABLE OF CHAR(6); names_tab names_type('Arthur', 'Tony','Mike'), how is the element containing 'Mike' referenced?
not consecutive
Index values in a nested table are? (consecutive or not consecutive)
a separate table
Nested table data is stored in? ( a separate table or in the main table or in the file system )
REF CURSOR
What P L SQL data type cannot be used for the elements of a nested table?
constructor
What construct is used to insert elements of a nested table column
none
What order does the database store rows in a nested table? (asc or desc or input or none)
atomically null
When a nested table is not initialised it is said to be?
subscript
When a nested table is retrieved into a PL/SQL variable, how can the rows be identified in that variable?
LAST > COUNT
When elements are deleted from the middle of a nested table?( LAST > COUNT or COUNT > LAST or COUNT = LAST)
FETCH, INSERT, SELECT, UPDATE
Which SQL /PLSQL statements can assign one collection to another?
nested table
Which collection type is like a one-dimensional array with an unbound number of elements and can be stored in the database?