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.

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts