Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso TCS (Mumbai)
Colloquio
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.
Domande di colloquio [1]
Domanda 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
Ho presentato la mia candidatura online. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso TCS
Colloquio
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.
Domande di colloquio [1]
Domanda 1
was asked questions on basics of plsql like cursor, procedures etc
