Upload Button Icon Add office photos

mPHATEK Systems

Compare button icon Compare button icon Compare

Filter interviews by

mPHATEK Systems SQL Developer Interview Questions and Answers

Updated 23 Oct 2021

mPHATEK Systems SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 23 Oct 2021

I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Study all types of joins, window function, DML, DDL commands, basic difference between function and SP, delete and Truncate.
  • Q2. Remove duplicate, third highest salry, Normalization, Indexes and their uses and drawbacks
  • Ans. 

    SQL Developer interview question on removing duplicates, finding third highest salary, normalization, and indexes.

    • To remove duplicates, use the DISTINCT keyword or GROUP BY clause

    • To find third highest salary, use the LIMIT keyword with OFFSET 2

    • Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity

    • Indexes are used to improve query performance by creating a data stru...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do all basic of Database.

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about mPHATEK Systems?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test

Round 2 - Group Discussion 

Current affairs

Round 3 - Technical 

(1 Question)

  • Q1. Puzzle , sql related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself, whatever you know just be confident

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How does the development team service a change request in the app ... read more
asked in BNP Paribas
Q2. Write a procedure to return the series (99, 96, 93, ..., 6, 3).
Q3. Write a query to join two tables and display the combined informa ... read more
asked in BNP Paribas
Q4. Given sample data on two tables, write down the result sets of al ... read more
asked in HCLTech
Q5. What are the differences between TRUNCATE and DROP statements, es ... read more

Interview Preparation Tips

Round: Technical Interview
Experience: this was a telephonic round : There I was asked basics of web development (e.g Session, hidden variable difference between POST and GET etc. ) and basics of PHP e.g global variables etc , little bit of mysql e.g joins , difference between left and right joins.

Round: Technical Interview
Experience: This was pretty much about interview rounds. I got the offer.

Skills: Core java, OOP, PHP
College Name: na

I applied via Job Fair and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - MCQ test 

(1 Question)

  • Q1. MCQ test. 20 questions were asked and attempted in 30 minutes.
Round 2 - Coding Test 

1hr duration, test can be attempted in any language. I have attempted in python.

Interview Preparation Tips

Topics to prepare for Raja Software Labs Software Developer interview:
  • Java
  • Python
Interview preparation tips for other job seekers - MCQ test based on loops and string, asked in java I think. I attempted and cleared. 20 questions/30 mins.

coding test was 1 hour and 5 questions were given. medium level questions.
Interview experience
3
Average
Difficulty level
-
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Basic coding question on array and string.

Interview Preparation Tips

Interview preparation tips for other job seekers - Do coding practices as much you can
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Code Snept question with 3-4 Reasoning question. Google form

Round 2 - Assignment 

Pen paper coding round. String , Array . Linkedlist , graph, questions

Round 3 - Technical 

(3 Questions)

  • Q1. Maximum Spaning
  • Q2. Nearest Prime number
  • Ans. 

    To find the nearest prime number, iterate from the given number in both directions until a prime number is found.

    • Start iterating from the given number in both directions to find the nearest prime number.

    • Check if a number is prime by dividing it by all numbers less than its square root.

    • Keep track of the closest prime number found during the iteration.

  • Answered by AI
  • Q3. Second Maximum Number in Array
  • Ans. 

    Find the second maximum number in an array of strings.

    • Convert the array of strings to an array of integers.

    • Sort the array in descending order.

    • Return the second element in the sorted array.

  • Answered by AI
Round 4 - Technical 

(4 Questions)

  • Q1. Project Question
  • Q2. Robot question of DSA
  • Q3. Stock Buy and sell - VI . Leetcode Hard
  • Ans. 

    Maximize profit by buying and selling stocks with at most k transactions.

    • Use dynamic programming to track profits for each transaction.

    • Maintain an array to store maximum profit for each day.

    • Example: For prices [3,2,6,5,0,3] and k=2, max profit is 7.

    • Consider edge cases like k=0 or prices being empty.

  • Answered by AI
  • Q4. Leetcode Medium

Skills evaluated in this interview

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 - Coding Test 

5 coding questions in the first round

Round 3 - One-on-one 

(2 Questions)

  • Q1. About yourself , about your project explaination.
  • Ans. Explianation about your project they'll ask fine details also.
  • Answered Anonymously
  • Q2. Find prime numbers value.
  • Ans. 

    A prime number is a number greater than 1 that is divisible only by 1 and itself.

    • Start with a loop to iterate through numbers

    • Check if each number is divisible by any number from 2 to its square root

    • If not divisible, add it to the list of prime numbers

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - just go through leet code question easy and medium.
Are these interview questions helpful?

I applied via Campus Placement and was interviewed in Jul 2022. There were 5 interview rounds.

Round 1 - Aptitude Test 

Basic Aptitude questions mainly on quantitative

Round 2 - Coding Test 

Google docs was shared which has 5 coding questions mainly on array and string.

Round 3 - Technical 

(4 Questions)

  • Q1. Interviewer introduced himself , then told the flow of interview ie. 2 coding question will be asked then he asked to introduce myself
  • Q2. Occurance of characters in string
  • Q3. Angle between hour and minute hand of clock at a given time
  • Q4. Both question I was able to solve quickly interview was sheduled for one hour but i solved questions in 23 minutes so interview ended. I was called for second techinal round
Round 4 - Technical 

(4 Questions)

  • Q1. Same format as above introduction and 2 coding questions
  • Q2. 1 Integer to roman it took me some time to solve the question
  • Q3. 2 given sum and we have to print all the subsequences in array with given sum
  • Ans. 

    Printing all the subsequences in an array with a given sum.

    • Use recursion to generate all possible subsequences.

    • Check if the sum of each subsequence is equal to the given sum.

    • Print the subsequences that satisfy the condition.

    • Time complexity: O(2^n).

  • Answered by AI
  • Q4. The interview took almost 45 minutes and i was able to solve both questions so i was selected for third round ie technical + HR
Round 5 - HR 

(5 Questions)

  • Q1. First introduction then as all rounds 2 coding questions and then HR questions were asked
  • Q2. 1 print string without taking repeating characters eg helper - helpr
  • Q3. 2 sort array of 0s and 1s in only one loop solution was using two pointers
  • Ans. 

    Sort an array of 0s and 1s in one loop using two pointers.

    • Use two pointers, one starting from the beginning and the other from the end.

    • Swap the values at the pointers if the value at the beginning pointer is greater than the value at the end pointer.

    • Continue until the pointers meet in the middle.

    • Time complexity is O(n).

  • Answered by AI
  • Q4. I solved both the questions then questions were asked on projects
  • Q5. Difficulties in project how you learn new technology After two days I received mail and I was selected for software developer role

Interview Preparation Tips

Topics to prepare for Raja Software Labs Software Developer interview:
  • arrays
  • string
Interview preparation tips for other job seekers - - Practice questions on array and string
- Also see puzzles on GFG they are also asked frequently
- No need to revise DBMS , OS for RSL interviews only coding is necessary

Skills evaluated in this interview

I appeared for an interview in Aug 2022.

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 - Technical 

(2 Questions)

  • Q1. First non repeating character in a string
  • Ans. 

    Find the first non-repeating character in a string.

    • Create a hash table to store character frequency

    • Iterate through the string and update the hash table

    • Iterate through the string again and return the first character with frequency 1

  • Answered by AI
  • Q2. Longest substring pallandrome in a string
  • Ans. 

    Find the longest substring that is a palindrome in a given string.

    • Use dynamic programming to solve the problem efficiently.

    • Create a 2D boolean array to store the results of subproblems.

    • Check for palindromes of length 1 and 2 separately.

    • For substrings of length greater than 2, check if the first and last characters are the same and the substring between them is also a palindrome.

    • Update the result if a longer palindrome ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare easy to medium level DSA from GFG. And many times they ask questions which were asked earlier in previous years.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

DSA questions such as Map, linked list

mPHATEK Systems Interview FAQs

How to prepare for mPHATEK Systems 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 mPHATEK Systems. The most common topics and skills that interviewers at mPHATEK Systems expect are SSIS, SSRS, Communication Skills, Data Migration and Data Quality.
What are the top questions asked in mPHATEK Systems SQL Developer interview?

Some of the top questions asked at the mPHATEK Systems SQL Developer interview -

  1. Remove duplicate, third highest salry, Normalization, Indexes and their uses an...read more
  2. Study all types of joins, window function, DML, DDL commands, basic difference ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 51 Interviews
DotPe Interview Questions
3.1
 • 42 Interviews
IT By Design Interview Questions
3.6
 • 41 Interviews
View all
mPHATEK Systems SQL Developer Salary
based on 6 salaries
₹1.8 L/yr - ₹6 L/yr
15% less than the average SQL Developer Salary in India
View more details
Software Developer
98 salaries
unlock blur

₹5.5 L/yr - ₹12.5 L/yr

Software Engineer
75 salaries
unlock blur

₹3.3 L/yr - ₹8.7 L/yr

Junior Software Engineer
55 salaries
unlock blur

₹1.8 L/yr - ₹4.6 L/yr

Salesforce Developer
44 salaries
unlock blur

₹2.5 L/yr - ₹11.2 L/yr

Test Engineer
39 salaries
unlock blur

₹3.2 L/yr - ₹7.5 L/yr

Explore more salaries
Compare mPHATEK Systems with

Saama Technologies

3.7
Compare

Blenheim Chalcot

2.8
Compare

Indus Valley Partners

3.1
Compare

DotPe

3.1
Compare
write
Share an Interview