TCS Production Support Engineer Interview Questions and Answers

A good coding test will measure candidate capacity for problem solving skills and understanding of coding

Aptitude test plays important role of understanding the knowledge of the person

Q1. Tell about yourself , what are your strengths?
Add your answer
Q2. What do you know about our company?
Add your answer
Q3. What are your weakness?
Add your answer

It was Easy to medium . overall good

It was Medium to tough level

Q1. What is fifo lifo
Ans. 
FIFO (First In, First Out) and LIFO (Last In, First Out) are inventory management methods.
• FIFO: Items that are added first are the first to be removed. Like a queue.

• LIFO: Items that are added last are the first to be removed. Like a stack.
Answered by AI
Add your answer
Q2. Whole data structure concepts
Add your answer

Q1. What do you want to change in this country if you get a chance
Ans. 
I would focus on improving access to quality education for all citizens.
• Implementing policies to ensure equal opportunities for education

• Investing in infrastructure and resources for schools in underserved areas

• Providing scholarships and financial aid for students from low-income families

• Promoting vocational training programs to address skills gaps in the workforce
Answered by AI
Add your answer
Q2. I don't remember
Add your answer

Q1. Accounts Receivables. Flow
Add your answer
Q2. Hikbbhuu huijehbe iorjenfe
Add your answer

Q1. What do you see on the tree and explain it
Ans. 
I see a tree with green leaves, brown trunk, and branches extending outward.
• Green leaves

• Brown trunk

• Branches extending outward
Answered by AI
Add your answer
Q2. More on situational
Add your answer

Q1. What is ur strength
Ans. 
My strength lies in my ability to troubleshoot complex technical issues efficiently and effectively.
• Strong problem-solving skills

• Excellent communication skills to work with cross-functional teams

• Ability to prioritize and manage multiple tasks simultaneously

• Experience in analyzing logs and identifying root causes
Answered by AI
Add your answer
Q2. What is your weakness
Add your answer

Lots of mock call and situational questions

Q1. Self introduction
Add your answer
Q2. Work experience
Add your answer
Q3. Which department are u working
Add your answer
Q4. Timings and salary
Add your answer

Q1. Name and experience and quality and checking etc
Add your answer
Q2. How can handle ur problem and team work
Add your answer
Q3. Times and salary
Add your answer

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer

Q1. Online interview
Add your answer
Q2. Self introduction
Add your answer