Evarikina Idi Upayogapadutundemo..

[Cherry25]

My interview experiance on Oracle plsql;:[list]
[*]What is cursor, types of cursor, cursor attributes and y do u use cursor
[*]Given a scenario which is dynamic usage of result set, which cursor would u use ? explain
[*]Types of triggers, have u written any ??
[*]Advantages of arrays/collections over cursors
[*]Advantage of package?
[*]Can u define procedures in package body without defining in package specification?
[*]If u open a cursor in a PL/SQL block, then again u open the same cursor, what will happen?
[*]Asked a few questions on set operators.
[/list]
----Till here it was fine, then started trouble[list]
[*]U mentioned about writing tech specs. Can u send me a doc? Hw exactly u write a tech spec doc, pls explain in detail
[*]How do u exactly identify the bottlenecks in SQL query performance. (He needed a practical approach. I was telling him all the theory abt tracing, explain plan, tkprof)
[*]Suppose I am loading data using a package which has 1000 programs in it. Hw exactly u find which program ( or step) is taking more time?
[*]Hw exactly u do the ETL process using PL/SQL alone?
[*]Any idea about Incremental refresh/ full refresh??
[/list]
I totally screwed up in the last part. I think this post might help any one of u..

[kichalkushh]

ee post ippudu teesesi mallli eppudaina veyyi. ippudu veste mee cts vaadu chusadu anuko by mistake.. ur job will be at stake.

[Cherry25]

[quote name='kichalkushh' timestamp='1344865427' post='1302300856']
ee post ippudu teesesi mallli eppudaina veyyi. ippudu veste mee cts vaadu chusadu anuko by mistake.. ur job will be at stake.
[/quote]
Ok..I'll edit mama