i
TEKsystems
Filter interviews by
I applied via LinkedIn and was interviewed before Jun 2023. There were 3 interview rounds.
Easy questions related to DSA and Python and SQL
Query to join two tables using different joins
Use INNER JOIN to return rows that have matching values in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
Delete removes rows from a table while truncate removes all rows from a table.
Delete is a DML command while truncate is a DDL command.
Delete operation can be rolled back while truncate operation cannot be rolled back.
Delete operation is slower than truncate operation.
Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;
Top trending discussions
I applied via Naukri.com
I appeared for an interview in Jun 2017.
I applied via Naukri.com and was interviewed before Apr 2020. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Company Website and was interviewed before Jan 2022. There were 2 interview rounds.
My goal is to become a highly skilled software engineer and contribute to innovative projects. My family background is supportive and has encouraged my pursuit of a career in technology.
Goal: Become a highly skilled software engineer
Contribute to innovative projects
Family background: Supportive and encouraging
Pursuit of a career in technology
I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before Sep 2021. There were 5 interview rounds.
This round consisted of flow diagram based aptitude questions. No multiple choices were present.
A simple group discussion on topics related to current affairs.
based on 1 interview
Interview experience
based on 13 reviews
Rating in categories
Senior Software Engineer
1.2k
salaries
| ₹6.8 L/yr - ₹27 L/yr |
Software Engineer
866
salaries
| ₹3.7 L/yr - ₹13.5 L/yr |
Technical Lead
305
salaries
| ₹11.9 L/yr - ₹38 L/yr |
Module Lead
261
salaries
| ₹8.4 L/yr - ₹30 L/yr |
Software Developer
181
salaries
| ₹4.2 L/yr - ₹16.4 L/yr |
Synechron
Movate
Sopra Steria
SS&C TECHNOLOGIES