ora3

Edit Answers
1234567891011121314151617
Across
  1. 6. A VARRAY once created,cannot be used directly inside pl/sql blocks.A _____ of the type the user defined VARRAY must be created to use in our blocks
  2. 7. A user has created a nested table n1 as a datbase object. The nested table is being used inside a table as follows: Fill with the required appropriate keyword: create table empl(id number,ename varchar2(20),contact n1)nested_table contact _____ as contact_nested_table;
  3. 8. When limit method is applied on a nested table, it returns a _______ value
  4. 9. Method to remove all the elements from a collection
  5. 11. Fill in with the appropriate keyword in the following syntax for defining nested table as a pl/sql structure : type t1 is _____ of varchar2(20);
  6. 13. User defined complex datatype and capable of storing more than one row of data
  7. 15. The following is the syntax for creating a VARRAY as a database object. Fill the appropriate missing keyword: create or replace _____ t1 as varray(10) of varchar2(20);
  8. 16. Collection method _____(n) can be used to remove n elements from the end of the collection
  9. 17. Collection method that is used to return the largest index number in a collection
Down
  1. 1. Delete method which accepts one parameter (which is an index value) when applied on this collection type, throws an error
  2. 2. _________ array is the keyword that can be used instead of the keyword VARRAY
  3. 3. _______ is a function which accepts one parameter which is an Index value and returns the Index value prior to the specified parameter.If there is no prior index value for the specified parameter, the function will return a NULL value
  4. 4. One of the way to initialize a VARRAY is by using the default constructor and then use the ______ method
  5. 5. A collection type that does not support limit method since it is dynamically extendable
  6. 10. Extend Method is used to allocate ______ for new elements in a collection
  7. 12. Collection Method that returns the max number of elements that a VARRAY can contain
  8. 14. Collection Method that returns the number of elements in a collection