MothersonSumi INfotech & Designs Interview Questions, Process, and Tips

Q1. What to find second highest salary find using sql
Ans. 
To find the second highest salary using SQL.
• Use the SELECT statement to retrieve the salaries from the table.

• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the result set to the second row.

• Use the OFFSET clause to skip the first row.

• Combine the above clauses to get the second highest salary.
Answered by AI
Add your answer
Q2. What is trigger and why it used
Ans. 
A trigger is a special type of stored procedure that automatically executes in response to certain events.
• Triggers are used to enforce business rules or data integrity.

• They can be used to audit changes to data.

• Triggers can also be used to replicate data across multiple tables or databases.

• Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.
Answered by AI
Add your answer
Q3. What is join and how many times of joins
Ans. 
Join is a SQL operation that combines rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables in a single query.

• There are four types of joins: inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and matching rows from the right table.

• Right join r...read more
Answered by AI
Add your answer
Q4. What to optimise the code using sql
Ans. 
Optimizing SQL code involves identifying and removing bottlenecks to improve performance.
• Identify slow queries and optimize them using indexes or rewriting the query

• Reduce the amount of data being queried by using filters or limiting results

• Avoid using subqueries or joins when possible

• Use stored procedures or views to simplify complex queries

• Regularly analyze and optimize the database schema
Answered by AI
Add your answer

Q1. How soon can you join
Add your answer

Q1. Licensing, tool, work exp, mgmt
Add your answer

Q1. Team, stakeholders mgmt
Add your answer

Take MCQ based questions on postresql and SQL

Cleared

Q1. Asking for some questions on your experience and gave some SQL query questions
Add your answer
Q2. Asking SQL questions on SQL this is face to face round I cleared that one Cleared
Add your answer

Q1. In technical round number 3 with project manager they asking gour questions on SQL query and I gave 3 This round is on hold
Add your answer

Q1. After 5 days HR call me for further round with different Project manager They asking also some SQL questions and also asking regarding work experience This round I cleared
Add your answer

Q1. This round with Team leader he was asking me some questions like first gave me to design table , create proc,and asking some difference on SQL and SQL server I gave three right answer out of four
Add your answer
Q2. But next day HR CALL me you are not selected because you are not cleared last rounds I don't know why, Jb lena hi nhi tha toh mujhe last 1 month se kiyu preshan kr rahe the phle hi mna krdete sir, Pleas...read more
Add your answer

Q1. Explain closures
Ans. 
Closures are functions that have access to variables from their containing scope even after the scope has closed.
• Closures allow functions to 'remember' the environment in which they were created.

• They can access variables from their outer function even after the outer function has finished executing.

• Closures are commonly used in event handlers, callbacks, and asynchronous programming.
Answered by AI
Add your answer
Q2. Why redux is required
Ans. 
Redux is required in a React application to manage the application state in a predictable way.
• Helps in managing the state of the application in a centralized store

• Enables easier debugging and tracking of state changes

• Facilitates state management in complex applications with multiple components

• Allows for time-travel debugging by maintaining a history of state changes

• Helps in maintaining a single source of truth for the
Answered by AI
Add your answer