Friday, August 12, 2016

CapGemini - PLSQL Interview Questions

Capgemini 1st round

Tell me about yourself
what are packages
what is explain plan
i have an sql statement which is well written, bit still very slow in fetching the data.
how do u read an awr report
by default what degree of parallalism will be used
explain bulk collect and forall
what it limit
how do u determine the limit of a bulk collect fetch.
how can i use commit in a trigger.
what are different types of triggers.

No comments :

Post a Comment