MASAI School Full Stack Software Developer Interview Questions and Answers

Question was moderate.based on logical reasoning and math.

Coding test question based on sql and python.

Q1. Find duplicates in an array
Ans. 
Use a hash set to find duplicates in an array of strings.
• Create a hash set to store unique elements.

• Iterate through the array and check if the element is already in the hash set.

• If it is, then it is a duplicate. If not, add it to the hash set.
Answered by AI
Add your answer
Q2. Find single duplicate element in an array where contents of the array are length of array - 1
Ans. 
Find the single duplicate element in an array of strings with length n-1.
• Iterate through the array and use a HashSet to keep track of elements seen so far.

• If an element is already in the HashSet, that is the duplicate element.

• Return the duplicate element once found.
Answered by AI
Add your answer

Create a student support system

Q1. Design an order and payments system for an EdTech company
Ans. 
Design an order and payments system for an EdTech company
• Allow users to browse and select courses

• Implement a shopping cart for users to add courses

• Integrate payment gateways for secure transactions

• Provide order confirmation and receipt to users

• Allow users to track their order status
Answered by AI
Add your answer

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Q1. About Myself in details
Add your answer
Q2. Past internships and work experiences
Add your answer

Q1. Primary keys, Unique key
Add your answer
Q2. Usage advantages and disadvantages of Indexing
Add your answer

SQL- 1 departments with no users
2 dept_id and their respective no. of users

DSA1: Most frequent no. in an array
DSA2: Zero Sum subarray exists

Q1. What is indexing in dbms and oops qrelated questions
Add your answer
Q2. Indexing is way to optimize data retrival process
Add your answer

Q1. About Lighnting Web componet
Add your answer

Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Add your answer

Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...read more
Add your answer

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer