TCS Interview Questions, Process, and Tips for Freshers

Aptitude consists of quantitative , logical questions

Q1. What is difference between where and having ?
Ans. 
WHERE is used to filter rows before grouping or aggregating, while HAVING is used to filter groups after grouping or aggregating.
• WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• HAVING is used with GROUP BY clause to filter groups based on a condition

• WHERE is applied before grouping or aggregating data

• HAVING is applied after grouping or aggregating data

• Example: SELECT * FROM table...read more
Answered by AI
Add your answer
Q2. Explain me about your projects
Ans. 
I have worked on various projects including a web development project, a data analysis project, and a machine learning project.
• Developed a website for a local business using HTML, CSS, and JavaScript

• Conducted data analysis on customer feedback data to identify trends and insights

• Implemented a machine learning model to predict customer churn for a telecom company
Answered by AI
Add your answer

Q1. What is global state management?
Ans. 
Global state management is a way to manage and share state data across multiple components in a React application.
• It helps in avoiding prop drilling by providing a centralized location for storing and updating state.

• Common libraries for global state management in React include Redux, Context API, and MobX.

• Global state management allows for easier state synchronization between components and can improve performance.

• Exam...read more
Answered by AI
Add your answer

Q1. 1. What are the selenium exceptions you’ve faced
Ans. 
I have faced exceptions like ElementNotVisibleException, NoSuchElementException, TimeoutException, StaleElementReferenceException, etc.
• ElementNotVisibleException occurs when an element is present in the DOM but not visible on the page

• NoSuchElementException is thrown when an element could not be found in the DOM

• TimeoutException occurs when a command does not complete in the specified time

• StaleElementReferenceException i...read more
Answered by AI
Add your answer
Q2. Different types of waits
Ans. 
Different types of waits in IT include CPU wait, I/O wait, and lock wait.
• CPU wait occurs when a process is waiting for the CPU to become available.

• I/O wait happens when a process is waiting for input/output operations to complete.

• Lock wait occurs when a process is waiting for a lock to be released by another process.
Answered by AI
Add your answer

Q1. Get and navigate difference
Ans. 
Get and navigate difference
• Get refers to retrieving data or information from a source

• Navigate refers to moving through a system or interface to access different sections or features

• Get is about obtaining specific data, while navigate is about moving around within a system
Answered by AI
Add your answer
Q2. Scenario and scenario outline
Add your answer

Q1. Dbms dsa oops react
Add your answer
Q2. Relational database question and answers
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Resume project based question
Add your answer