AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
mPHATEK Systems Junior Software Engineer Interview Questions and Answers
mPHATEK Systems Junior Software Engineer Interview Experiences
1 interview found
Sv Kamble
Selected
I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.
(4 Questions)
- Q1. SQL aggregate function
- Q2. Difference between delete, truncate and drop
- Ans.
Delete removes rows from a table, truncate removes all rows from a table, drop removes a table from the database.
Delete is a DML command which removes specific rows from a table.
Truncate is a DDL command which removes all rows from a table but keeps the table structure.
Drop is a DDL command which removes an entire table from the database.
Delete can be rolled back, truncate cannot be rolled back, drop cannot be rolled b...
- Q3. What are types of joins and use of join with example
- Ans.
Types of joins in SQL include inner join, outer join, left join, and right join.
Inner join: returns rows when there is a match in both tables
Outer join: returns all rows when there is a match in one of the 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
- Q4. What is normalization
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by storing data in a structured way
Normalization ensures data integrity by avoiding update anomalies
There are different normal forms like 1NF, 2NF, 3NF, etc.
Example: In a database, instead of stori...
(2 Questions)
- Q1. Details about the company
- Q2. Salary expectations and other things
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
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
I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.
Aptitude test
Current affairs
(1 Question)
- Q1. Puzzle , sql related questions
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
(1 Question)
- Q1. Print unique numbers in list
- Ans.
Print unique numbers in list
Iterate through the list and store each number in a set to keep track of unique numbers
Print out the numbers in the set to display the unique numbers
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
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
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
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
- Junior Software Developer Interview Questions
- Junior Engineer Interview Questions
- Junior Developer Interview Questions
- Junior Executive Interview Questions
- Junior Web Developer Interview Questions
- Junior Officer Interview Questions
- Junior Engineer Civil Interview Questions
- Junior Business Analyst Interview Questions
- Show more
mPHATEK Systems Junior Software Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
mPHATEK Systems Junior Software Engineer Reviews and Ratings
based on 9 reviews
Rating in categories
|
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 Junior Software Engineer Interview Questions
