i
TCS
Filter interviews by
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
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 at National Institute of Technology,(NIT), Agartala 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 Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
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.
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
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Custom hooks in React are reusable functions that allow you to extract component logic into separate functions for better code organization and reusability.
Custom hooks are created using the 'use' prefix and can be used to share logic between components.
Use cases for custom hooks include fetching data from an API, handling form state, managing local storage, and more.
Example of a custom hook for API call: const useFetc...
useMemo is used to memoize a value, while useCallback is used to memoize a function.
useMemo is used to memoize a value and recompute it only when its dependencies change.
useCallback is used to memoize a callback function and prevent unnecessary re-renders.
Example: useMemo can be used to memoize the result of a complex computation, while useCallback can be used to memoize an event handler function.
Class-based components use ES6 classes and have lifecycle methods, while functional components are simpler and use functions.
Class-based components use ES6 classes to create components, while functional components are created using functions.
Class-based components have lifecycle methods like componentDidMount and componentDidUpdate, while functional components do not.
Functional components are simpler and more lightweig...
Implementing the lifecycle of a React component in a functional component
Use the useEffect hook to replicate lifecycle methods like componentDidMount, componentDidUpdate, and componentWillUnmount
Pass an empty array as the second argument to useEffect to mimic componentDidMount
Pass a variable or state as the second argument to useEffect to mimic componentDidUpdate
Return a cleanup function inside useEffect to mimic compo
Various state management techniques in React include Context API, Redux, and local state.
Context API: React's built-in solution for passing data through the component tree without having to pass props down manually at every level.
Redux: A popular state management library for React applications, allowing for a centralized store to manage application state.
Local state: Managing state within individual components using us
Redux is a predictable state container for JavaScript apps. Middlewares are functions that intercept actions before they reach the reducer.
Redux follows a unidirectional data flow architecture.
Middlewares in Redux are functions that can intercept, modify, or dispatch actions.
Common use cases for middlewares include logging, asynchronous API calls, and handling side effects.
Examples of popular Redux middlewares are Redu...
Hoisting in JavaScript is the behavior where variable and function declarations are moved to the top of their containing scope during the compilation phase.
Variable declarations are hoisted to the top of their scope, but not their initializations.
Function declarations are fully hoisted, meaning they can be called before they are declared.
Hoisting can lead to unexpected behavior if not understood properly.
Event bubbling is the propagation of events from the target element up through its ancestors in the DOM tree.
Events triggered on a child element will 'bubble up' and trigger on parent elements.
Event listeners can be attached to parent elements to handle events from multiple child elements.
Stopping event propagation can be done using event.stopPropagation() or event.stopImmediatePropagation().
Block scope and function scope are two types of scopes in JavaScript that determine the visibility and accessibility of variables.
Block scope refers to the visibility of variables within a block of code enclosed by curly braces. Variables declared with 'let' and 'const' have block scope.
Function scope refers to the visibility of variables within a function. Variables declared with 'var' have function scope.
Variables de...
Yes, I have experience working with semantic tags in HTML.
Used semantic tags like <header>, <nav>, <main>, <section>, <article>, <aside>, <footer> for better structure and SEO.
Understand the importance of using semantic tags for accessibility and search engine optimization.
Semantic tags help in organizing content and making it more readable for developers and browsers.
Various methods for creating an object in JavaScript include object literals, constructor functions, ES6 classes, and Object.create() method.
Object literals: var obj = { key: value };
Constructor functions: function ObjectName() { this.key = value; } var obj = new ObjectName();
ES6 classes: class ClassName { constructor() { this.key = value; } } var obj = new ClassName();
Object.create() method: var obj = Object.create(pr
Shallow copy only copies the references of nested objects, while deep copy creates new copies of nested objects.
Shallow copy creates a new object but does not create copies of nested objects, only copies their references.
Deep copy creates a new object and also creates new copies of all nested objects.
Shallow copy can be achieved using Object.assign() or spread operator, while deep copy can be achieved using JSON.parse(
The code will throw an error because 'a' is declared but not initialized.
The code will result in a ReferenceError because 'a' is declared but not assigned a value.
Variables declared with 'const' must be initialized at the time of declaration.
Initializing 'a' with a value before calling test() will prevent the error.
CSS can be used to arrange elements in a row and column layout using flexbox or grid layout properties.
Use display: flex; for a row layout and display: flex; flex-direction: column; for a column layout
Use justify-content and align-items properties to align items in the main axis and cross axis respectively
For grid layout, use display: grid; and grid-template-columns or grid-template-rows to define the layout
Yes, I have utilized CSS preprocessors such as SASS and LESS.
I have experience using SASS to streamline my CSS workflow by utilizing variables, mixins, and nesting.
I have also worked with LESS to improve code organization and maintainability through features like variables and functions.
The color applied will be based on the specificity of the selector, with ID having higher specificity than class.
ID has higher specificity than class in CSS
Color applied will be based on the selector with higher specificity
Example: If ID selector has color red and class selector has color blue, the color applied will be red
I applied via Company Website and was interviewed in Oct 2024. There were 2 interview rounds.
Pricing Rule & Product Rule are mathematical concepts used in calculus to find derivatives of functions.
Pricing Rule is used to find the derivative of a function that involves a product of two functions.
Product Rule is used to find the derivative of a function that involves the product of two functions.
Pricing Rule: (f(x)g(x))' = f'(x)g(x) + f(x)g'(x)
Product Rule: (fg)' = f'g + fg'
Option constraints are restrictions placed on the values that can be assigned to an option in a software system.
Option constraints define the valid range of values for an option.
They can include minimum and maximum values, allowed data types, and specific values.
For example, an option for selecting a color may have constraints that limit the choices to 'red', 'blue', or 'green'.
Configuration attributes are settings that define the behavior of a software system.
Configuration attributes can include parameters such as database connection strings, logging levels, and feature toggles.
They are typically stored in configuration files or databases.
Changing configuration attributes can alter the behavior of the software without modifying its code.
Configuration attributes are used to customize the soft...
Record Triggered Flow is a type of Flow in Salesforce that is triggered when a record is created or updated.
Record Triggered Flow is used to automate processes in Salesforce based on changes to records.
It can be set to run before or after the record is saved.
Record Triggered Flow can access and update related records as well.
It is a powerful tool for automating complex business processes in Salesforce.
MDQ (Multi Dimensional Quote) is a tool used in software development to estimate the effort required for a project by considering multiple dimensions.
MDQ takes into account various factors such as complexity, team experience, technology stack, and project scope.
It helps in providing a more accurate estimation of the time and resources needed for a project.
For example, a project with a high complexity level and a new te...
Pricing waterfall is a method used to analyze and optimize pricing strategies by breaking down the pricing process into different components.
Pricing waterfall helps in understanding the impact of various factors on pricing decisions.
It involves analyzing costs, competition, customer demand, and other market factors to determine the optimal pricing strategy.
Examples of components in a pricing waterfall include fixed cos...
A discount schedule is a set of rules or guidelines that determine the amount of discount a customer receives based on various factors.
Discount schedules can be based on factors such as quantity purchased, customer loyalty, or promotional events.
For example, a discount schedule may offer a 10% discount for purchases of 10 items or more.
Another example could be a loyalty program where customers receive increasing discou...
Different pricing methods include cost-plus pricing, value-based pricing, competition-based pricing, and dynamic pricing.
Cost-plus pricing involves adding a markup to the cost of production.
Value-based pricing sets prices based on the perceived value to the customer.
Competition-based pricing involves setting prices based on competitors' prices.
Dynamic pricing adjusts prices in real-time based on demand and other factor
CPQ offers multiple products including Configure, Price, Quote, Contract Management, and Billing.
Configure: Allows users to customize products based on customer needs
Price: Calculates pricing based on configurations and discounts
Quote: Generates quotes for customers based on configured products
Contract Management: Manages contracts and agreements with customers
Billing: Handles invoicing and payment processing
QCP is a software plugin used for calculating quotes for products or services.
QCP is a tool used in sales or e-commerce platforms to provide accurate pricing information to customers.
It can factor in variables such as quantity, discounts, taxes, and shipping costs to generate a final quote.
QCP can be customized to fit the specific pricing structure and rules of a business.
Examples of QCP include plugins for online shop...
Special Field in CPQ refers to a custom field that is unique to a specific use case or industry.
Special fields can be used to capture industry-specific data or unique requirements.
Examples include fields for pricing rules in the manufacturing industry or contract terms in the telecommunications industry.
Yes, I have worked on Amendment. It involves making changes to existing software code or documentation.
Amendment involves modifying existing code or documentation to improve functionality or fix issues.
Examples include updating a software feature to meet new requirements, fixing bugs in the code, or enhancing performance.
Amendment may also involve revising documentation to reflect changes made to the software.
Renewal in CPQ refers to the process of renewing a contract or subscription for a product or service.
Renewal in CPQ involves generating a renewal quote for an existing contract or subscription.
The renewal flow typically includes reviewing the terms of the existing contract, making any necessary adjustments, and generating a new quote for the renewed contract.
Customers may have the option to renew their contract for a s...
Quote to Cash Flow is the process of generating revenue from the initial quote to the final payment.
Quote to Cash Flow involves the entire sales process from creating a quote for a product or service to receiving payment for that product or service.
It includes activities such as quoting, invoicing, order fulfillment, and payment collection.
The goal of Quote to Cash Flow is to streamline the sales process and improve ca...
Package level setting refers to configuration settings that apply to an entire package of software components.
Package level settings are configuration options that affect all components within a software package.
These settings are typically defined at the package level and apply globally.
Examples include setting default values for variables, defining access control rules, or specifying logging levels.
Package level sett...
Bundle product is a group of related products sold together, while nested bundle is a bundle within a bundle.
Bundle product is a collection of multiple products sold together as a single unit.
Nested bundle is a bundle that contains another bundle within it.
Example: A laptop bundle may include a laptop, a laptop bag, and a mouse. Within this bundle, there could be a nested bundle for extended warranty options.
Guided selling is a sales technique where the salesperson guides the customer through the buying process, offering personalized recommendations and advice.
Involves salesperson providing personalized recommendations to customers
Helps customers make informed decisions during the buying process
Often used in e-commerce websites to suggest products based on customer preferences
Usages based product refers to a pricing model where customers are charged based on their usage of the product or service.
Customers are charged based on the amount or frequency of their usage.
Common in industries like cloud computing, SaaS, and utilities.
Examples include pay-as-you-go cloud services, metered electricity usage, and usage-based insurance.
Batch APEX is a feature in Salesforce that allows developers to process records in bulk using Apex code.
Batch APEX is used to handle large volumes of data in Salesforce.
It is commonly used for tasks like data cleansing, data migration, and data processing.
Batch APEX classes implement the Database.Batchable interface and are executed asynchronously.
Developers can monitor and manage Batch APEX jobs through the Salesforce
Interview experience
based on 9 reviews
Rating in categories
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
67.6k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.3k
salaries
| ₹8 L/yr - ₹25 L/yr |
Assistant System Engineer
29.9k
salaries
| ₹2.2 L/yr - ₹5.6 L/yr |
Associate Consultant
28.9k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture