Candidatei-me pessoalmente. Fui entrevistado pela Tata Consultancy Services (North America) (Chennai) em jan. de 2017
Entrevista
Stored procedures are nothing but named blocks which contains the group of SQL statements to achieve specific functionality.A stored procedure or in simple a proc is a named PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages.Stored Procedures accepts the different input parameters and gives the result as per requirement of user. PL/SQL is executed in the database, you can include SQL statements in your code without having to establish a separate connection.Stored Procedure reduces the network traffic and improves the system performance.Stored procedures are used to ensure the data integrity of database.
Fiz uma entrevista na empresa Tata Consultancy Services (North America).
Entrevista
There were 2 interviewers. I was asked multiple basic questions on Oracle SQL and PL/SQL as well as scenario-based questions moreover questions on my past experience based on the resume.
