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
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
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
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
Software Developer Interview Questions & Answers
Saama Technologies
mallikarjuna kukatikonda
posted on 19 Sep 2024
I applied via Job Portal
60mintues DSA level coding exam
Selected
I applied via Walk-in and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. React js, ReactHooks, es67 features, bootstrap
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
5 coding questions on google docs..duration 1 hour
(1 Question)
- Q1. Questions on string and array manipulation, leap year identification, second largest element of array, etc
Selected
I applied via Company Website and was interviewed before May 2023. There were 3 interview rounds.
5-6 questions were provided and a day was given.
(1 Question)
- Q1. DSA question related to array and string
(1 Question)
- Q1. Find the minimum number of coins to make a given value. (Coin Change)
- Ans.
Find minimum number of coins to make a given value using dynamic programming.
Use dynamic programming to find the minimum number of coins needed.
Create a dp array to store the minimum number of coins for each value up to the given value.
Iterate through each coin denomination and update the dp array accordingly.
Return the value at the given value index in the dp array.
Interview Preparation Tips
- DSA
Skills evaluated in this interview
Medium level question based on quantitative aptitude
Medium level leetcode questions
Interview Preparation Tips
Software Developer Interview Questions & Answers
Raja Software Labs
Sarvesh Barapatre
posted on 24 Sep 2024
Questions based on data structure
Questions based on Data structure
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
33
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
