PL/SQL Nested Table

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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?


Kaugnay na mga set ng pag-aaral

Chapter 10: Principles of Fluid and Electrolytes

View Set

1G) Calculating Healthcare Statistics

View Set

Module 37: Public Goods and Services

View Set

Chapter 9 - Television: Broadcast and Beyond

View Set