AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
mPHATEK Systems SQL Developer Interview Questions and Answers
mPHATEK Systems SQL Developer Interview Experiences
1 interview found
Anonymous
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...
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Interview Preparation Tips
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
Software Developer Interview Questions & Answers
Raja Software Labs
Mayuresh Gujar
posted on 28 Nov 2024
DSA questions such as Map, linked list
Software Developer Interview Questions & Answers
Raja Software Labs
Amey Uplenchwar
posted on 29 Nov 2024
I applied via Campus Placement
Three were basic questions around strings and arrays
(1 Question)
- Q1. Detailed discussion on data structures and algorithms
Code Snept question with 3-4 Reasoning question. Google form
Pen paper coding round. String , Array . Linkedlist , graph, questions
(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.
- 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.
(4 Questions)
- Q1. Project Question
- Q2. Robot question of DSA
- Q3. Stock Buy and sell - VI . Leetcode Hard
- Q4. Leetcode Medium
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed in Sep 2022. There were 3 interview rounds.
One hour aptitude test, after clearing that, some basic coding questions were unlocked.
This one was face to face. Basically, the approach to the question was seeked by the HRs rather than the correct answer only.
(3 Questions)
- Q1. This included two rounds, one with HR and one with CEO. Questions were based on real life logics and basic mathematics
- Q2. Based on real life and quants with some HR Questions.
- Q3. Like: What salary do you expect
- Ans.
I expect a competitive salary based on my skills, experience, and the market rate for software developers.
Research the average salary range for software developers in your location and industry.
Consider your level of experience, education, and any specialized skills you possess.
Factor in the company's size, reputation, and financial stability.
Be prepared to negotiate and discuss benefits and perks in addition to salary...
Interview Preparation Tips
I applied via Referral and was interviewed in Apr 2023. There were 3 interview rounds.
Topics- APTITUDE, reasoning
Topic- reasoning and mathematical questions.
Interview Preparation Tips
Quantitative arithmetic,verbal reasoning,non-verbal reasoning,etc
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in Nov 2023. There were 3 interview rounds.
Mcq + dsa JavaScript questions
(1 Question)
- Q1. JavaScript advance topics and database design topics
(1 Question)
- Q1. Situation based question and behavioural questions
I applied via LinkedIn and was interviewed in Sep 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. 1. Explain difference between spring and spring boot
- Ans.
Spring is a framework for building Java applications, while Spring Boot is a tool for quickly creating Spring-based applications.
Spring provides a comprehensive framework for building Java applications, while Spring Boot is a tool that simplifies and accelerates the process of creating Spring-based applications.
Spring requires more configuration and setup, while Spring Boot provides a pre-configured environment that re...
- Q2. 2. String anagram program
- Ans.
A program to check if two strings are anagrams of each other.
Create two character arrays from the input strings
Sort the arrays
Compare the sorted arrays to check if they are equal
- Q3. 3. write small code using streams api
- Ans.
Using Streams API to filter and map an array of strings
Create a stream from the array using Arrays.stream()
Use filter() to select elements that meet a certain condition
Use map() to transform each element into a new value
Use toArray() to convert the stream back into an array
- Q4. 4. java 8 concepts
- Q5. 5. what is REST api
- Ans.
REST API is a web service that uses HTTP requests to access and manipulate data.
REST stands for Representational State Transfer
It is an architectural style for building web services
It uses HTTP methods like GET, POST, PUT, DELETE to perform operations on resources
It is stateless and can be cached
It returns data in various formats like JSON, XML, etc.
Interview Preparation Tips
Skills evaluated in this interview
mPHATEK Systems Interview FAQs
Tell us how to improve this page.
mPHATEK Systems Interviews By Designations
- mPHATEK Systems Software Developer Interview Questions
- mPHATEK Systems Engineer Trainee Interview Questions
- mPHATEK Systems Junior Software Engineer Interview Questions
- mPHATEK Systems Software Engineer Interview Questions
- mPHATEK Systems Market Executive Interview Questions
- mPHATEK Systems SQL Database Administrator Interview Questions
- mPHATEK Systems Senior Java Developer Interview Questions
- mPHATEK Systems SQL Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
SQL Developer Interview Questions from Similar Companies
Fast track your campus placements
|
Software Developer
95
salaries
|  ₹3.7 L/yr - ₹14.7 L/yr |
|
Software Engineer
74
salaries
| ₹1.8 L/yr - ₹9.9 L/yr |
|
Junior Software Engineer
53
salaries
| ₹1.8 L/yr - ₹4 L/yr |
|
Salesforce Developer
39
salaries
| ₹2.5 L/yr - ₹9.3 L/yr |
|
Junior Software Developer
34
salaries
| ₹2 L/yr - ₹7.9 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services
- Home >
- Interviews >
- mPHATEK Systems Interview Questions >
- mPHATEK Systems SQL Developer Interview Questions
