MothersonSumi INfotech & Designs Senior Software Engineer 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

Official good interview

First round moral and second round machine test

Q1. Core ABAP DDIC basics ALV New ABAP syntax Debugging Performance tuning techniques ABAP RICEFW Advanced ABAP OO concepts Proxy Web services BAPI SEGW SAP ABAP on HANA CDS UI An...read more
Add your answer

Q1. Project specific questions on ABAP on HANA
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Tell me about yourself.
Ans. 
I am a Senior Software Engineer with 10+ years of experience in developing and implementing software solutions.
• 10+ years of experience in software development

• Expertise in multiple programming languages such as Java, C++, and Python

• Strong knowledge of software architecture and design patterns

• Experience in leading and mentoring development teams

• Proven track record of delivering high-quality software products on time

• Excel
Answered by AI
Add your answer