TCS Interview Questions, Process, and Tips

Q1. Difference between truncate and delete command
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.

• Example: TRUNCATE...read more
Answered by AI
Add your answer
Q2. Difference between clustering and grouping
Ans. 
Clustering is grouping similar data points together based on their characteristics, while grouping is organizing data into categories based on predefined criteria.
• Clustering is unsupervised learning, while grouping is typically done based on predefined rules or criteria.

• Clustering aims to find natural groupings in data, while grouping is more about organizing data for easier analysis.

• Example: Clustering can be used in ...read more
Answered by AI
Add your answer
Q3. What is encapsulation. Explain it with example
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents direct access to an object's attributes.

• Encapsulation also helps in achieving data abstraction, where only necessary details are exposed to the outside world.

• Example: In...read more
Answered by AI
Add your answer

First round is both aptitude and coding round
Even if we dont clear coding we will be selected for ninja process

Q1. Self intro Difference between SQL and MySQL OOPS concept DBMS question Write any code in recursion concept Fibonacci code
Add your answer
Q2. In HR round they verified the original documents
Add your answer

There was 20 questions of aptitude medium level

2 coding questions can be solved in language of our choice

Q1. Basic coding questions on prefered language
Add your answer

Q1. Questions about location of work, situation based questions
Add your answer

Common question with all aptitude topics- not tough but average

If your strong in coding you can crack it

Q1. Asking questions based on the resume and projects
Add your answer

Q1. They will ask about the shifts and normal hr discussions
Add your answer

Basic and advanced math and reasoning questions.

Q1. Basic Technical questions on oops, dbms, project. And basic simple hr questions.
Add your answer
Q2. Basic managerial questions
Add your answer