TCS Interview Questions, Process, and Tips

Basic SW n hw questions

Q1. Technical and practical questions asked
Add your answer
Q2. Write a query to join two db tables
Ans. 
Query to join two database tables
• Use the JOIN keyword in SQL to combine rows from two tables based on a related column

• Specify the columns to be joined on using the ON keyword

• Common types of joins include INNER JOIN, LEFT JOIN, and RIGHT JOIN
Answered by AI
Add your answer
Q3. How to install os on server
Ans. 
To install an OS on a server, you need to boot from the installation media and follow the on-screen instructions.
• Insert the installation media (such as a USB drive or DVD) into the server

• Boot the server from the installation media

• Follow the on-screen instructions to select the OS version, partition the disk, and complete the installation process
Answered by AI
Add your answer
Q4. Java Oops concepts
Add your answer

Q1. Team work related questions
Add your answer
Q2. Communication test
Add your answer

Q1. Salary discussion
Ans. Nothing much they already had a threshold and it was a take it or leave it situation
Answered Anonymously
Add your answer

Q1. Joins, what Java is Platform Independent, Method overloading vs Method overriding,
Add your answer
Q2. Why Java is Object Oriented language, Inheritance
Ans. 
Java is an Object-Oriented language that uses concepts like inheritance to promote code reusability and modularity.
• Encapsulation: Java allows bundling of data and methods, e.g., using classes to hide implementation details.

• Inheritance: Enables a new class to inherit properties and methods from an existing class, e.g., class Dog extends Animal.

• Polymorphism: Allows methods to do different things based on the object it is...read more
Answered by AI
Add your answer
Q3. Why pointers is not used in Java,
Ans. 
Java does not use pointers to enhance security and simplify memory management, relying instead on references.
• Java uses references instead of pointers, which are safer and prevent direct memory access.

• Pointers can lead to complex memory management issues like dangling pointers; Java avoids this.

• Java's garbage collection automatically manages memory, reducing the need for manual pointer management.

• Using references in Jav...read more
Answered by AI
Add your answer

Q1. Technical round 1. Introduction 2. Interests 3. Python use in latest technologies 4. Machine learning and it's algorithms 5. Types of data 6. Classification Regression
Add your answer
Q2. Maneger round 1. Greatest achievement of your life 2. About your family
Add your answer

Q1. 1. For Location and shift 2. For Documentation
Add your answer

DSA, Apt, Coding , Hackerrank

Q1. OOPS , SQL questions
Add your answer

Apti round was not very tough we can say average questions were there, Don't worry if your aptitude is not good, take a pen and paper & think in which topic u r weak just practice those questions, including previous year try to solve as much as questions you can

Q1. Just be honest with your technical knowledge Try to showcase your knowledge try explain in simple words !! No need of Fancy English !!
Add your answer
Q2. There are some basic HR questions I would like to share with you just practice those questions I would recommend practice these with your friends 1) Where do you see yourself in next five year? Ans: (My p...read more
Add your answer

Q1. Focus on your communication skills and try to practice google searched HR questions
Add your answer

Q1. Please introduce yourself
Ans. 
I am a highly skilled System Engineer with experience in designing, implementing, and maintaining complex IT systems.
• I have a Bachelor's degree in Computer Science

• I have 5+ years of experience working with various operating systems such as Windows, Linux, and Unix

• I am proficient in programming languages like Python, Java, and C++

• I have experience in network configuration, troubleshooting, and security

• I have worked on p...read more
Answered by AI
Add your answer
Q2. What are the DML commands you have used
Ans. 
DML commands I have used include INSERT, UPDATE, DELETE in SQL databases.
• INSERT: Used to add new records to a table

• UPDATE: Used to modify existing records in a table

• DELETE: Used to remove records from a table
Answered by AI
Add your answer
Q3. What are stored procedures
Ans. 
Stored procedures are precompiled SQL queries stored in a database for reuse.
• Stored procedures are used to perform a specific task or set of tasks in a database.

• They can accept input parameters and return results.

• Stored procedures can improve performance by reducing network traffic and optimizing query execution.

• Examples include procedures for inserting, updating, or deleting data in a database.
Answered by AI
Add your answer
Q4. What are functions
Ans. 
Functions are blocks of code that perform a specific task and can be called multiple times within a program.
• Functions help in organizing code by breaking it into smaller, manageable parts.

• They improve code reusability by allowing the same block of code to be used in multiple places.

• Functions can take input parameters and return output values.

• Examples: summing two numbers, finding the maximum value in an array, printing
Answered by AI
Add your answer

Q1. What is your salary expectations
Ans. 
My salary expectations are based on my experience, skills, and the market rate for the position.
• Research the average salary range for System Engineers in the specific location and industry

• Consider your level of experience and expertise in the field

• Factor in any additional benefits or perks offered by the company

• Be prepared to negotiate based on the job responsibilities and requirements
Answered by AI
Add your answer