Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How collections are improve the performance?



How collections are improve the performance?..

Answer / kesava

COLLECTION:
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
collection Types:
index by Table
Nested Table
Varray

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  


what is the functionality of the function htmlentities? : Sql dba

0 Answers  


What is audit logout in sql profiler?

0 Answers  


Does execute immediate commit?

0 Answers  


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,






What is spool?

0 Answers  


What are types of joins?

0 Answers  


Which type of cursor is used to execute the dml statement?

0 Answers  


What is the difference between subquery and correlated query?

0 Answers  


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  


How do you modify a table in sql?

0 Answers  


What is the difference between rollback and rollback to statements?

0 Answers  


Categories