i
TCS
Filter interviews by
I was interviewed in Oct 2022.
I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.
I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.
A cursor is a database object used to retrieve data from a result set one row at a time.
Types of cursors: Implicit, Explicit, Ref, and Dynamic
Implicit cursor is used for single row queries
Explicit cursor is used for multi-row queries
Ref cursor is used to point to a cursor variable
Dynamic cursor is used to execute dynamic SQL statements
Explanation of triggers and their types in PL/SQL
Triggers are database objects that are automatically executed in response to certain events
Types of triggers include DML, DDL, and system triggers
Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;
SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.
SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Pragma is a compiler directive that provides additional information ...
What people are saying about TCS
I applied via Naukri.com and was interviewed in Feb 2022. There were 3 interview rounds.
Temp table is a table created temporarily in memory. Temp variable is a variable that holds temporary data.
Temp table is used to store data temporarily during a session
Temp variable is used to hold temporary data that is not needed after a certain point
Temp table and variable are created using the 'CREATE GLOBAL TEMPORARY' and 'DECLARE' statements respectively
Example: CREATE GLOBAL TEMPORARY TABLE temp_table (id NUMBER...
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...
Autonomous transaction is a separate transaction initiated by a parent transaction.
It allows a subtransaction to commit or rollback independently of the parent transaction.
It is useful for logging or auditing purposes.
It can be created using the PRAGMA AUTONOMOUS_TRANSACTION statement.
Example: A parent transaction updates a table, while an autonomous transaction logs the changes made.
Example: An autonomous transaction ...
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...
Triggers are database objects that automatically execute in response to certain events.
Triggers can be used to enforce business rules, audit data changes, and maintain referential integrity.
They can be defined to execute before or after an event, such as a row being inserted, updated, or deleted.
Triggers can also be nested, meaning one trigger can execute another trigger.
Examples of triggers include automatically updat...
Truncate removes all data, delete removes selected data.
Truncate is faster than delete as it doesn't log individual row deletions.
Truncate cannot be rolled back, delete can be.
Truncate resets identity columns, delete doesn't.
Truncate doesn't fire triggers, delete does.
Truncate is a DDL operation, delete is a DML operation.
PL/SQL program to print numbers in descending order from 103 to 3
Use a loop to iterate from 103 to 3
Print each number in the loop
Decrement the loop counter by 3 in each iteration
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...
HAVING is used to filter groups while GROUP BY is used to group rows based on a column.
HAVING is used with GROUP BY to filter groups based on a condition
GROUP BY is used to group rows based on a column
HAVING is used after GROUP BY in a query
GROUP BY is used before HAVING in a query
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;
TCS interview questions for designations
I applied via LinkedIn and was interviewed in May 2022. There were 2 interview rounds.
I have a strong ability to learn new software quickly.
I am a self-motivated learner and enjoy exploring new technologies.
I am comfortable with online tutorials, documentation, and experimenting with new software.
I have experience learning new software such as Oracle SQL Developer, Toad, and PL/SQL Developer.
I am able to adapt to new software quickly and efficiently.
Get interview-ready with Top TCS Interview Questions
The duration of TCS Plsql Developer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 12 interviews
3 Interview rounds
based on 90 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
66.7k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.5k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹5.8 L/yr |
Associate Consultant
29.4k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture