Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MothersonSumi INfotech & Designs Team. If you also belong to the team, you can get access from here

MothersonSumi INfotech & Designs Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

MothersonSumi INfotech & Designs SQL Developer Interview Questions and Answers

Updated 14 Feb 2024

MothersonSumi INfotech & Designs SQL Developer Interview Experiences

2 interviews found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 14 Feb 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Walk-in and was interviewed in Jan 2024. There were 5 interview rounds.

Round 1 - Coding Test 

Take MCQ based questions on postresql and SQL

Cleared

Round 2 - Technical 

(2 Questions)

  • Q1. Asking for some questions on your experience and gave some SQL query questions
  • Q2. Asking SQL questions on SQL this is face to face round I cleared that one Cleared
Round 3 - Technical 

(1 Question)

  • 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
Round 4 - Technical 

(1 Question)

  • 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
Round 5 - Technical 

(2 Questions)

  • 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
  • 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...

Interview Preparation Tips

Interview preparation tips for other job seekers - If they rescheduled your interview with different different project manager that means they are not selected you
Only waste of time

I applied via Naukri.com and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Prepare Sql query optimization, Performance Turing,Use of Index, Function, View, SSIS, SSRS, SSAS etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong knowledge of SQL will help you to crack interview.

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How is a change request in application serviced by development te ... read more
asked in BNP Paribas
Q2. Write down a procedure to return a certain series (99, 96, 93, .. ... read more
asked in BNP Paribas
Q3. Given sample data on two tables, write down the result sets of al ... read more
asked in Capgemini
Q4. 2. Query optimization techniques? 3. Types of schemas and differe ... read more
asked in HCLTech
Q5. Difference between truncate and drop with more details. eg: 'A' t ... read more

Interview questions from similar companies

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain

    • Handle edge cases like no fresh oranges or all oranges already rotten

    • Consider using a queue to efficiently process adjacent oranges

  • Answered by AI
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Ans. 

    Find the majority element in an array, return -1 if no majority element exists.

    • Iterate through the array and keep track of the count of each element using a hashmap.

    • Check if any element's count is greater than floor(N/2) to determine the majority element.

    • Return the majority element or -1 if no majority element exists.

  • Answered by AI
  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Ans. 

    Find the Lowest Common Ancestor (LCA) of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the LCA.

    • Handle cases where one node is an ancestor of the other or when one node is the LCA itself.

  • Answered by AI
  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

  • Ans. 

    Reverse words in a string while handling leading/trailing spaces and multiple spaces between words.

    • Split the input string by spaces to get individual words

    • Reverse the list of words

    • Join the reversed words with a single space in between

    • Handle leading/trailing spaces by stripping them before and after reversing

  • Answered by AI
Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Ans. 

    Assign subjects to friends to minimize maximum workload, find minimum time for most loaded friend.

    • Sort subjects in descending order

    • Assign subjects to friends one by one until all subjects are assigned

    • The maximum workload will be the sum of problems assigned to the friend with the most problems

    • Return the maximum workload as the minimum time required

  • Answered by AI
  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Ans. 

    Find the total sum of all root to leaf paths in a binary tree formed by concatenating node values.

    • Traverse the binary tree from root to leaf nodes, keeping track of the current path sum

    • Add the current path sum to the total sum when reaching a leaf node

    • Use modulo (10^9 + 7) to handle large outputs

  • Answered by AI
  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Java multithreading, oops

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. 1. If you given a no return its corresponding excel no.
  • Ans. 

    Convert given no to corresponding excel no.

    • Excel no starts from 1 and goes up to 16384

    • Excel no is calculated using column and row numbers

    • For example, 1 corresponds to A, 27 corresponds to AA, 28 corresponds to AB, and so on

  • Answered by AI
  • Q2. 2. find unique character in a window of k size in a string
  • Ans. 

    Find unique characters in a window of k size in a string.

    • Use a sliding window approach.

    • Maintain a hash table to keep track of character frequency.

    • Remove characters from hash table as the window slides.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Communication is very important. Give your solution from brute force to optimal. Interviewer has tell me to write code of both questions in any programming language.

Skills evaluated in this interview

Round 1 - Aptitude Test 

Normal aptitude questions

Round 2 - Coding Test 

Not exactly coding, it was an automata fixround

Round 3 - Technical 

(1 Question)

  • Q1. Basics of project, oops, sql
Round 4 - HR 

(1 Question)

  • Q1. It was a tehno managerial round. Consisting of puzzles, oops & situation based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place for freshers, learn & grow.
Pay is a bit less for freshers, which is in case of all service based company

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They asked me questions related to my project on which i had work in my last company. And there were questions from core java , database, collections, Spring framework ,

Interview Preparation Tips

Interview preparation tips for other job seekers - Just keep your basic clear , You must have a clear understanding of the topics which you prepare for interview.keep your basic very strong .
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Coding Test 

1 dsa , aptitude questions

Round 2 - Technical 

(2 Questions)

  • Q1. DSA medium level questions
  • Q2. Resume based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be through with dsa
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about spring boot
  • Ans. 

    Spring Boot is a framework that simplifies the development of Java applications by providing pre-configured settings and tools.

    • Spring Boot eliminates the need for manual configuration by providing defaults for most settings.

    • It allows developers to create stand-alone, production-grade Spring-based Applications.

    • Spring Boot includes an embedded Tomcat, Jetty, or Undertow server, making it easy to deploy web applications.

    • I...

  • Answered by AI
  • Q2. Tell me about last projects
Round 2 - Coding Test 

DP, Binary Search, Greedy, etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare DSA

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Scenario based question
  • Q2. Problem solving

MothersonSumi INfotech & Designs Interview FAQs

How many rounds are there in MothersonSumi INfotech & Designs SQL Developer interview?
MothersonSumi INfotech & Designs interview process usually has 3-4 rounds. The most common rounds in the MothersonSumi INfotech & Designs interview process are Technical, Resume Shortlist and One-on-one Round.
How to prepare for MothersonSumi INfotech & Designs SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at MothersonSumi INfotech & Designs. The most common topics and skills that interviewers at MothersonSumi INfotech & Designs expect are SQL, SQL Development, MVC, ASP.Net and C#.Net.
What are the top questions asked in MothersonSumi INfotech & Designs SQL Developer interview?

Some of the top questions asked at the MothersonSumi INfotech & Designs SQL Developer interview -

  1. But next day HR CALL me you are not selected because you are not cleared last r...read more
  2. This round with Team leader he was asking me some questions like first gave me ...read more
  3. In technical round number 3 with project manager they asking gour questions on ...read more

Tell us how to improve this page.

MothersonSumi INfotech & Designs SQL Developer Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 338 Interviews
CitiusTech Interview Questions
3.4
 • 274 Interviews
NeoSOFT Interview Questions
3.6
 • 268 Interviews
Tiger Analytics Interview Questions
3.7
 • 227 Interviews
Episource Interview Questions
3.9
 • 220 Interviews
Altimetrik Interview Questions
3.8
 • 219 Interviews
Xoriant Interview Questions
4.1
 • 183 Interviews
Incedo Interview Questions
3.1
 • 182 Interviews
View all
MothersonSumi INfotech & Designs SQL Developer Salary
based on 6 salaries
₹4 L/yr - ₹10 L/yr
21% more than the average SQL Developer Salary in India
View more details

MothersonSumi INfotech & Designs SQL Developer Reviews and Ratings

based on 3 reviews

3.9/5

Rating in categories

4.2

Skill development

4.2

Work-life balance

4.2

Salary

4.2

Job security

4.0

Company culture

3.9

Promotions

4.2

Work satisfaction

Explore 3 Reviews and Ratings
Software Engineer
538 salaries
unlock blur

₹2.4 L/yr - ₹9.1 L/yr

Senior Software Engineer
396 salaries
unlock blur

₹5.2 L/yr - ₹18.7 L/yr

Module Lead
166 salaries
unlock blur

₹7.4 L/yr - ₹30 L/yr

Project Lead
94 salaries
unlock blur

₹10.4 L/yr - ₹27 L/yr

Technology Specialist
74 salaries
unlock blur

₹5.4 L/yr - ₹21 L/yr

Explore more salaries
Compare MothersonSumi INfotech & Designs with

ITC Infotech

3.6
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview