I applied online. The process took 1 day. I interviewed at TCS
Interview
Interview comprised of two rounds. First it was a technical round, basic concepts of plsql were asked. Next on clearing the first round it was an HR round. It was a good experience. Topics like procedure, function, cursor, triggers and its types were asked.
Interview questions [1]
Question 1
was asked questions on basics of plsql like cursor, procedures etc
I have applied through TCS portal. Conducted 3 level of interview. It took 3 weeks for getting offer from them. I have applied through TCS portal. Conducted 3 level of interview. It took 3 weeks for getting offer from them.
Interview questions [1]
Question 1
Difference between primary key and unique key. Questions based on unique key and composite key. Write function to return multiple values. Sql queries to print values, update statement to update multiple rows in single command. Questions around package - Overloading, security wise etc. Question on procedures - Role of proc in package, input parameters etc. Collections questions - methods, scenerio based if delete is used, how to use trim with it. Assign value of one collection to anoth
