AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
MothersonSumi INfotech & Designs
Compare
Filter interviews by
MothersonSumi INfotech & Designs Interview Questions, Process, and Tips
Top MothersonSumi INfotech & Designs Interview Questions and Answers
- Q1. WHAT IS SEALED CLASS AND WHAT IS EXTENSION METHOD?asked in Junior Developer Trainee interview
- Q2. What to find second highest salary find using sqlasked in Senior Software Engineer interview
- Q3. What happens if 80k records getting inserted into DB and connection dropsasked in Project Lead interview
MothersonSumi INfotech & Designs Interview Experiences
35 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.
Task based assignment
(1 Question)
- Q1. Design related questions on SAAS based application
(1 Question)
- Q1. Salary discussion
Senior UX Designer Interview Questions asked at other Companies
Selected
I was interviewed in Apr 2023.
(2 Questions)
- Q1. How to Data fetch in grid and do crud operation through it.
- Ans.
Data fetch in grid and perform CRUD operations through it involves retrieving data from a grid and manipulating it using create, read, update, and delete operations.
Use a data source to populate the grid with information
Implement functions to handle create, read, update, and delete operations on the grid data
Utilize grid events to trigger CRUD operations
Ensure proper validation and error handling for data operations
- Q2. How many types of SQL joins?
- Ans.
There are four types of SQL joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Skills evaluated in this interview
Senior Engineer Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.
(5 Questions)
- Q1. DIFFERENCE BETWEEN ABSTRACT AND INTERFACE?
- Ans.
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.
A class can only extend one abstract class, but can implement multiple interfaces.
Abstract classes are used to define common characteristics among subclasses, while interfaces are used to define a contract...
- Q2. WHAT IS MIDDLEWARE
- Ans.
Middleware is software that acts as a bridge between different applications or components, allowing them to communicate and share data.
Middleware helps in managing communication between different systems or components.
It can provide services such as authentication, logging, and caching.
Examples of middleware include web servers like Apache or Nginx, and frameworks like Express.js in Node.js.
- Q3. WHAT IS SEALED CLASS AND WHAT IS EXTENSION METHOD?
- Ans.
A sealed class is a class that cannot be inherited and an extension method is a method that allows adding new methods to existing types without modifying the original type.
Sealed class restricts inheritance, preventing other classes from deriving from it.
Extension methods allow adding new methods to existing types without modifying the original type.
Example of sealed class: 'sealed class MyClass { }'
Example of extensio...
- Q4. DIFFERENCE BETWEEN SESSION AND APPLICATION?
- Ans.
Session is specific to a user's interaction with a website, while application is global to all users.
Session stores user-specific data, while application stores data accessible to all users.
Session is temporary and expires after a period of inactivity, while application data persists.
Session is used for user authentication and personalization, while application data is used for global settings and configurations.
- Q5. WHAT IS DELEGATE?
- Ans.
A delegate is a type that represents references to methods with a specific parameter list and return type.
Delegates are similar to function pointers in C++ or pointers to member functions in C++/CLI.
Delegates allow methods to be passed as parameters.
Delegates can be used to define callback methods.
Delegates can invoke the methods they reference.
Delegates are type-safe and secure.
Interview Preparation Tips
Skills evaluated in this interview
Junior Developer Trainee Interview Questions asked at other Companies
Praveen Sharma
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.
(5 Questions)
- Q1. Core technology questions
- Q2. Ssl decryption and firewall question
- Q3. Ipsec vpn questions
- Q4. Routing questions
- Q5. Switchingquestions
Technology Engineer Interview Questions asked at other Companies
MothersonSumi INfotech & Designs interview questions for popular designations
Selected
I applied via Referral and was interviewed in Sep 2022. There was 1 interview round.
(2 Questions)
- Q1. Set Analysis questions
- Q2. Loads and Charts
Data Analyst Interview Questions asked at other Companies
Get interview-ready with Top MothersonSumi INfotech & Designs Interview Questions
(4 Questions)
- 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.
- 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.
- 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...
- 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
Interview Preparation Tips
Skills evaluated in this interview
Senior Software Engineer Interview Questions asked at other Companies
Jobs at MothersonSumi INfotech & Designs
(2 Questions)
- Q1. Test scenarios on real life scenarios
- Q2. Test cases on pencil
(2 Questions)
- Q1. Test cases format— design techniques
- Ans.
Test cases format can be designed using various techniques.
Test cases can be designed using boundary value analysis.
Equivalence partitioning can also be used to design test cases.
Decision table testing is another technique for designing test cases.
State transition testing can be used for testing systems with different states.
Use case testing can be used to test the system's functionality from the user's perspective.
- Q2. Bug life cycle , test data, sql queries
(4 Questions)
- Q1. Aptitude question , mental maths
- Q2. Experience in detail, different testing performed
- Ans.
I have experience in performing various types of testing such as functional, regression, integration, performance, and security testing.
Performed functional testing to ensure that the software meets the specified requirements
Conducted regression testing to ensure that the changes made to the software did not affect the existing functionality
Performed integration testing to ensure that the different modules of the softw...
- Q3. Why to join this company
- Q4. Test documentation, managerial skills questions
Interview Preparation Tips
Senior Test Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Dec 2021. There were 4 interview rounds.
(2 Questions)
- Q1. Technical discussion about role and responsibilities
- Q2. About technical & acedemic qualification
Group discussion about projects undertaken, which are developed & ongoing both
(2 Questions)
- Q1. About technical & acedemic qualification
- Q2. Salary discussion to finalize
Interview Preparation Tips
Technical Lead Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.
Official good interview
First round moral and second round machine test
Senior Software Engineer Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
(6 Questions)
- Q1. Tell me about yourself
- Q2. What is current CTC
- Ans.
My current CTC is $100,000 per year.
Current CTC is $100,000 per year
CTC includes salary, bonuses, and other benefits
CTC may vary based on experience and negotiation skills
- Q3. How much salary expectation
- Q4. How much notice period
- Q5. What is your current location
- Q6. What is your qualification
Technical Lead Interview Questions asked at other Companies
Top trending discussions
MothersonSumi INfotech & Designs Interview FAQs
The duration of MothersonSumi INfotech & Designs interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
MothersonSumi INfotech & Designs Interviews By Designations
- MothersonSumi INfotech & Designs Senior Software Engineer Interview Questions
- MothersonSumi INfotech & Designs Software Engineer Interview Questions
- MothersonSumi INfotech & Designs Software Developer Interview Questions
- MothersonSumi INfotech & Designs Senior Engineer Interview Questions
- MothersonSumi INfotech & Designs Technical Lead Interview Questions
- MothersonSumi INfotech & Designs Technology Engineer Interview Questions
- MothersonSumi INfotech & Designs SQL Developer Interview Questions
- MothersonSumi INfotech & Designs Design Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Software Engineer Interview Questions
- Software Engineer Interview Questions
- Associate Interview Questions
- Analyst Interview Questions
- Intern Interview Questions
- Senior Engineer Interview Questions
- Sales Executive Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Show more
MothersonSumi INfotech & Designs Interview Process
based on 40 interviews
Interview experience
Interview Questions from Similar Companies
MothersonSumi INfotech & Designs Reviews and Ratings
based on 565 reviews
Rating in categories
Noida,
Hyderabad / Secunderabad
3-6 Yrs
Not Disclosed
|
Software Engineer
543
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
393
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Module Lead
166
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Project Lead
115
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Design Engineer
83
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- MothersonSumi INfotech & Designs Interview Questions
