Answer Posted / shishir
For each will process the statements for each row of the
bulk collect ,whereas for all will process all the records
in a single shot. These key work is generally used with the
bulk collections to enhance the preformance by minimizing
the I/O operations
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Where do we use semi and non additive facts?
explain about balanced dimension,
Explain difference between view and materialized view?
How to provide security in frame work manager for a query subject?
What is critical column?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the difference between er modeling and dimensional modeling?
How to create different types of templates?
What is Active Datawarehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between agglomerative and divisive hierarchical clustering?
Why facts table is useful in representing the data?
Why we use repository connectivity?
Explain meta data?