Tata Group Production Supervisor Interview Questions and Answers

Q1. Tell me about your self
Ans. 
I am a dedicated and experienced Production Engineer with a strong background in manufacturing processes and quality control.
• Bachelor's degree in Mechanical Engineering

• 5+ years of experience in production engineering

• Proficient in CAD software and manufacturing processes

• Implemented lean manufacturing principles to improve efficiency

• Led cross-functional teams to troubleshoot production issues
Answered by AI
Add your answer
Q2. Tell me what you know about Unix and SQL
Ans. 
Unix is a powerful operating system known for its multitasking and multi-user capabilities, while SQL is a language used for managing and querying databases.
• Unix is an operating system developed in the 1970s known for its command-line interface and flexibility.

• SQL (Structured Query Language) is a language used to communicate with databases to retrieve, update, and manage data.

• Unix commands are case-sensitive and often ...read more
Answered by AI
Add your answer

Q1. What is mutex and it's syntax?
Ans. 
A mutex is a synchronization primitive used to control access to shared resources in a multi-threaded environment.
• Mutex is typically used to protect critical sections of code to prevent race conditions.

• Syntax for using mutex in C++: std::mutex myMutex;

• To lock a mutex: myMutex.lock();

• To unlock a mutex: myMutex.unlock();
Answered by AI
Add your answer
Q2. What is a goroutine and how it's used?
Ans. 
A goroutine is a lightweight thread managed by the Go runtime. It allows concurrent execution of functions.
• Goroutines are created using the 'go' keyword followed by a function call.

• They are used for concurrent programming in Go, allowing multiple functions to run simultaneously.

• Goroutines are more efficient than traditional threads as they have lower memory overhead and can be multiplexed onto fewer OS threads.

• Example:...read more
Answered by AI
Add your answer

DSA, Queries and logical coding

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

Easy logical questions

Q1. Easy general questions asked
Add your answer
Q2. General questions
Add your answer
Q3. Strength and weaknesses, about project
Add your answer

Relating submit queries 30 minutes

Previous experience & now What you want to tell about your present job how to deal with your group team .. How you manage to complete yogiurs tasks within time bond