Upload Button Icon Add office photos

Filter interviews by

mPHATEK Systems SQL Developer Interview Questions and Answers

Updated 23 Oct 2021

1 interview found

Sort by: Popular

SQL Developer Interview Questions

user image Anonymous

posted on 23 Oct 2021

I applied via Naukri.com and was interviewed before Oct 2020.

4 Interview Rounds

Interview Questions

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

Interview Preparation Tips

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

Interview questions from similar companies

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via campus placement at Krishna Institute of Engineering and Technology, Ghaziabad and was interviewed in Oct 2024.

3 Interview Rounds

1

Aptitude Test Round

Medium level questions asked

2

Coding Test Round

Simple easy to medium 2 questions asked of string and array

3

Technical Round (2 Questions)

  • Q1. Tell me about yourself
  • Q2. JavaScript like fetch axios and others
Interview experience
1
 Bad
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. I don't know why they rejected me
  • Q2. What ever they asked me for coding part the output is correct and logic is also correct
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via campus placement at KIIT University, Bhuvaneshwar and was interviewed in Apr 2024.

3 Interview Rounds

1

Coding Test Round

Medium level coding questions on hackerrank ,1:30hr, topic- Array , DP , Matrix , Binary Search

2

Technical Round (1 Question)

  • Q1. Was Asked to Implement Hashmap and Question on OOPS and Dbms , SQL and Indexing
3

Technical Round (2 Questions)

  • Q1. Brief Introduction
  • Q2. Rotten Oranges and basics of bfs and DFS
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Jan 2024.

3 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Javascript MCQs and one coding question
2

Technical Round (1 Question)

  • Q1. 3 coding questions, Questions on Resume and Node.js. Scenario based questions.
3

Behavioral Round (1 Question)

  • Q1. Questions on project. Behavioural questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be well prepared before attending the interview
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via campus placement at Centre for Development of Advanced Computing (CDAC) and was interviewed before Jun 2022.

3 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Related to front end technologies like HTML, CSS, JS
2

Technical Round (1 Question)

  • Q1. Basic questions on HTML, CSS, JS Focus on array questions and read methods of array before
3

Technical Round (1 Question)

  • Q1. Managerial round questions based on scenario to check how you think/react on the particular situation

I was interviewed in Feb 2021.

1 Interview Round

1

Coding Test Round (4 Questions)

Round duration - 90 minutes
Round difficulty - Medium

Timing was 10AM. The platform was quite good.

  • Q1. Maximum size rectangle sub-matrix with all 1's You are given an 'N' * 'M' sized binary-valued matrix 'MAT, where 'N' is the number o...read more
  • Q2. Binary Tree Maximum Path Sum You are given a binary tree with ‘N’ nodes. Your task is to find the “Maximum Path Sum” for any path. Note : 1. A ‘path’ is a seque...read more
  • Q3. Minimum number of swaps required to sort an array You have been given an array 'ARR' of 'N' distinct elements. Your task is to find the minimum ...read more
  • Q4. Infix to Postfix You are given a string EXP which is a valid infix expression. Convert the given infix expression to postfix expression. Infix expression is of ...read more

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - Intern in DelhiEligibility criteriaAbove 7 CGPAHike interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 2.5 monthsInterview preparation tips for other job seekers

Tip 1 : Do at least 1 project.
Tip 2 : Practice data structure questions.
Tip 3 : Dynamic programming is must.

Application resume tips for other job seekers

Tip 1 : Do not put false things.
Tip 2 : Keep it short and direct.

Final outcome of the interviewRejected

Skills evaluated in this interview

I was interviewed before Sep 2020.

3 Interview Rounds

1

Coding Test Round (4 Questions)

Round duration - 90 minutes
Round difficulty - Medium

They share doc file link which consist of 5 programming questions

  • Q1. Reverse Words in a String You are given a string of length N. You need to reverse the string word by word. There can be multiple spaces between two words and th...read more
  • Q2. Fibonacci Member Given a number N, figure out if it is a member of fibonacci series or not. Return true if the number is member of fibonacci series else false. ...read more
  • Q3. Maximum Difference You are given an array 'ARR' of the 'N' element. Your task is to find the maximum difference between any of the two elements ...read more
  • Q4. Remainder when divided by 11 You are given a number N. You need to find the remainder when N is divided by 11. Note : Number N may be very large. Input format ...read more
2

Video Call Round (3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

In this round interviewer asked me to solve 3 programming questions.

  • Q1. Selection Sort Selection sort is one of the sorting algorithms that works by repeatedly finding the minimum element from the unsorted part of the array and putt...read more
  • Q2. String Palindrome Given a string, determine if it is a palindrome, considering only alphanumeric characters. Palindrome A palindrome is a word, number, phrase, ...read more
  • Q3. Star Pattern Print the following pattern Pattern for N = 4 The dots represent spaces. Input Format : N (Total no. of rows) Output Format : Pattern in N lines ...read more
3

HR Round (2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This was the HR round. They asked me simple HR questions and 1 coding question.

  • Q1. Basic HR Questions

    What experience do you have that would be relevant to this role?

    What do you know about our company’s product/services?

  • Q2. Count characters Write a program to count and print the total number of characters (lowercase english alphabets only), digits (0 to 9) and white spaces (single ...read more

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - Intern in PuneEligibility criteriaabove 6 CGPARaja Software Labs interview preparation:Topics to prepare for the interview - Language - Java, Basic Coding questions like (star patterns, factorial of no, prime number or not, etc), Data Structure, Object Oriented Programming conceptsTime required to prepare for the interview - 1 MonthsInterview preparation tips for other job seekers

Tip 1 : Learn how to optimize the program. This will really help you during RSL interview. 
Tip 2 : Study all previously asked question by this company and try to find out best solution for it.
Tip 3 : Keep resume simple and authenticated.
Tip 4 : Practice how to handrun the program.

Application resume tips for other job seekers

Tip 1 : Resume should be authenticated. You should be able to answer all things on resume.
Tip 2 : Keep it simple.
Tip 3 : Having internship experience will help.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

5 Interview Rounds

1

Coding Test Round

They have their own platform

2

Assignment Round

Take home assignment

3

Technical Round (1 Question)

  • Q1. Live coding round of CRUD based small app.
4

Technical Round (1 Question)

  • Q1. More on HTML, CSS, JS
5

Technical Round (1 Question)

  • Q1. Promises, async/await, settimeout etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just keep your core knowledge strong

Web Developer Interview Questions

Affine user image Manasa jagadeesh

posted on 9 Apr 2020

Interview experience
5
 Excellent
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed before Apr 2019.

4 Interview Rounds

Interview Questions

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.

People are getting interviews through

based on 1 mPHATEK Systems interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

SQL Developer Interview Questions from Similar Companies

View all
mPHATEK Systems SQL Developer Salary
based on 6 salaries
₹3 L/yr - ₹6 L/yr
At par with the average SQL Developer Salary in India
View more details
Software Developer
93 salaries
unlock blur

₹3.8 L/yr - ₹15 L/yr

Software Engineer
75 salaries
unlock blur

₹1.2 L/yr - ₹9.9 L/yr

Junior Software Engineer
50 salaries
unlock blur

₹1.8 L/yr - ₹5.2 L/yr

Senior Software Engineer
39 salaries
unlock blur

₹6.8 L/yr - ₹24.8 L/yr

Salesforce Developer
39 salaries
unlock blur

₹2.5 L/yr - ₹9.3 L/yr

Explore more salaries
Compare mPHATEK Systems with

Infosys

3.7
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview