Friday, August 12, 2016

TCS - PLSQL Interview Questions



TCS 1st round:


what is coreleated sub query.
I have a table emp with 10 rows and department 5 rows, inner query has 5 rows from dept and outer query will have 10 rows from 10 rows, how many times corelated subquery will execute.4
which is faster in or exists
why exists is faster.
what are different types of triggers
difference between row level and statement level
what is bulk collect and for all, limit. 
what are save exceptions
what is index. different types of indexs
what are pratitions, explain different types.

No comments :

Post a Comment