i
TCS
Filter interviews by
Clear (1)
SQL joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
F...
Delete removes a record entirely, while update modifies an existing record.
Delete removes the entire record from the database
Update modifies specific fields of an existing record
Delete is irreversible, while update can be undone by another update
Example: Deleting a user account vs updating the user's email address
Rate your
company
🤫 100% anonymous
How was your last interview experience?
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
Linear regression is a statistical method used to model the relationship between a dependent variable and one or more independent variables.
Linear regression aims to find the best-fitting straight line that describes the relationship between variables.
It is commonly used for predicting numerical values based on input features.
The equation for a simple linear regression model is y = mx + b, where y is the dependent vari...
Support Vector Machine (SVM) is a supervised machine learning algorithm used for classification and regression tasks.
SVM finds the hyperplane that best separates different classes in the feature space
It works by maximizing the margin between the closest data points from different classes
SVM can handle non-linear data by using kernel functions to map data into higher-dimensional space
Examples: classifying emails as spam...
Object detection identifies objects in an image, while segmentation assigns a label to each pixel in the image.
Object detection involves identifying and locating objects within an image, often using bounding boxes.
Segmentation assigns a class label to each pixel in the image, creating a pixel-wise mask for each object.
Object detection is typically used when the goal is to identify and locate multiple objects in an imag...
Camera sensors use various technologies such as CMOS and CCD to capture images.
CMOS (Complementary Metal-Oxide-Semiconductor) sensors are commonly used in modern digital cameras for their low power consumption and high image quality.
CCD (Charge-Coupled Device) sensors are another type of sensor used in some cameras, known for their high-quality images but higher power consumption.
Other technologies used in camera senso...
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Python decorators are functions that modify the behavior of other functions or methods.
Decorators are denoted by the @ symbol followed by the decorator function name.
They are commonly used for adding functionality to existing functions without modifying their code.
Decorators can be used for logging, timing, authentication, caching, etc.
Example: @staticmethod decorator in Python is used to define a method that is not bo
What people are saying about TCS
I applied via Job Portal and was interviewed in Aug 2021. There were 2 interview rounds.
TCS interview questions for designations
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
Implement a sorting algorithm to sort a list without using built-in functions.
Use a common sorting algorithm like bubble sort, selection sort, or insertion sort.
Iterate through the list and compare adjacent elements to swap them if necessary.
Repeat the process until the list is sorted in ascending order.
Web scraping is the process of extracting data from websites using code.
Identify the website and the specific data to be extracted
Use libraries like BeautifulSoup or Scrapy in Python to parse HTML
Inspect the website's HTML structure to locate the data
Write code to extract the data and store it in a desired format
Precision is the ratio of correctly predicted positive observations to the total predicted positive observations, while Recall is the ratio of correctly predicted positive observations to the all observations in actual class.
Precision focuses on the accuracy of positive predictions, while Recall focuses on the proportion of actual positives that were correctly identified.
Precision = TP / (TP + FP)
Recall = TP / (TP + FN...
Hyperparameters of Random Forest include number of trees, max depth of trees, minimum samples per leaf, and maximum features.
Number of trees: Determines the number of decision trees in the forest.
Max depth of trees: Controls the maximum depth of each decision tree.
Minimum samples per leaf: Specifies the minimum number of samples required to be at a leaf node.
Maximum features: Determines the maximum number of features t
LLAMA models are used for large language model adaptation.
LLAMA models are used for adapting large language models to specific tasks or domains.
They are commonly used in natural language processing tasks such as text generation, translation, and sentiment analysis.
Examples of LLAMA models include GPT-3, BERT, and RoBERTa.
I was interviewed before Sep 2020.
Round duration - 140 minutes
Round difficulty - Medium
Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...
Given two numbers represented as arrays, calculate their sum and return the result as an array.
Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros
Round duration - 20 minutes
Round difficulty - Easy
The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.
Round duration - 8 minutes
Round difficulty - Easy
This round was conducted right after finishing and clearing the technical round at the same place and on the same day.
Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.
Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
based on 3 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
based on 9 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹0 L/yr - ₹0 L/yr |
IT Analyst
66.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
AST Consultant
51.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
29.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Wipro
Infosys
Accenture