i
TCS
Filter interviews by
I appeared for an interview in Feb 2023.
Overview of PL/SQL concepts including triggers, views, indexes, and more.
Triggers are database procedures that automatically execute in response to certain events on a table or view.
Types of triggers: BEFORE, AFTER, INSTEAD OF; e.g., BEFORE INSERT trigger to validate data before insertion.
Views are virtual tables based on the result of a query; Materialized Views store the result physically for faster access.
Indexes im...
I seek new challenges and opportunities for growth that align with my career goals and aspirations in PL/SQL development.
Desire for professional growth: I'm looking for a role that offers more opportunities for learning and advancement.
Seeking new challenges: I want to tackle more complex projects that can enhance my skills and experience.
Cultural fit: I'm looking for a company culture that aligns more closely with my ...
I appeared for an interview in Oct 2022.
I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.
What people are saying about TCS
I applied via Naukri.com and was interviewed in Feb 2022. There were 3 interview rounds.
A mutating table or mutating trigger occurs when a trigger tries to update a table that is currently being modified.
Mutating table occurs when a trigger references the table that is being modified.
It can happen when a trigger is fired by an INSERT, UPDATE, or DELETE statement on the table.
This can lead to unpredictable results or errors, such as ORA-04091: table is mutating, trigger/function may not see it.
To avoid mut...
Cursors are used to retrieve and manipulate data from a database in PL/SQL.
Cursors are like pointers to a result set, allowing us to fetch and process rows one by one.
There are two types of cursors: implicit and explicit.
Implicit cursors are automatically created by Oracle when executing a SQL statement.
Explicit cursors are declared and used by the programmer.
Explicit cursors provide more control and flexibility compar...
A procedure in PL/SQL is a named block of code that can be called and executed multiple times.
Syntax: CREATE [OR REPLACE] PROCEDURE procedure_name [(parameter1 [mode1] datatype1 [, parameter2 [mode2] datatype2]...)] IS
Difference between procedure and function: Procedures do not return a value, while functions return a value.
Procedures are used to perform an action, while functions are used to calculate and return a val...
To find if two tables have similar data, compare the records in both tables using a join or a subquery.
Use a join operation to compare the records in both tables based on a common column.
If the tables have a primary key, you can join them on that key to check for similar data.
Alternatively, you can use a subquery to compare the data in both tables and check for matching records.
Consider using the MINUS operator to find...
I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.
It is little bit easy
2 coding question in python
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.
Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.
Types are user-defined data structures that can be used to define new data types in PL/SQL.
Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...
The duration of TCS Plsql Developer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 3 interview experiences
Difficulty level
Duration
based on 99 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹3.9 L/yr - ₹8.3 L/yr |
IT Analyst
65.3k
salaries
| ₹8 L/yr - ₹14.5 L/yr |
AST Consultant
53.8k
salaries
| ₹12.2 L/yr - ₹20.7 L/yr |
Associate Consultant
33.2k
salaries
| ₹16.3 L/yr - ₹28.2 L/yr |
Assistant System Engineer
33.2k
salaries
| ₹2.4 L/yr - ₹6.3 L/yr |
Amazon
Wipro
Infosys
Accenture