Unthinkable Solutions Software Developer Intern Interview Questions and Answers

3 coding test range from easy to hard.

Q1. About the project?
Add your answer
Q2. What are Joins?
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right ta...read more
Answered by AI
Add your answer
Q3. How JS works and nodeJs works
Ans. 
JavaScript is a scripting language used for web development, while Node.js is a runtime environment that allows JavaScript to run on the server side.
• JavaScript is a client-side scripting language used for creating interactive web pages.

• Node.js is a runtime environment that allows JavaScript to run on the server side.

• Node.js uses the V8 JavaScript engine from Google Chrome to execute code.

• Node.js provides a set of built...read more
Answered by AI
Add your answer

Q1. Can you provide details about your project and draw an ER diagram for an e-commerce website?
Ans. 
Developed an e-commerce website project
• Used MySQL database to store product information, customer details, and orders

• Implemented user authentication and authorization for secure login and access control

• Designed a user-friendly interface for browsing products, adding items to cart, and checking out

• Included features like search functionality, product categories, and payment gateway integration
Answered by AI
Add your answer

There were 3 questions:
1. Given a string check if it is possible to rearrange the elements of the string to form a palindrome. [Check GFG for the question]
2. Given an integer n, print n rows of following pattern.
Example :
n = 7
* * * * * * *
* *
* * * * *
* * * *
* * * * *
* *
* * * * * * *
3. Cut the sticks [Check hacker rank for the question desc.]
Total duration 90 mins.

I was directly shortlisted for PI. Hence did not sit for this round but I am aware that there were 2 DSA questions in 40 mins. One was pattern and other was is Anagram question on leetcode valid anagram question.

Q1. Resume discussion with basic questions on projects
Add your answer
Q2. Couple of SQL queries
Add your answer
Q3. Basics of DBMS, OOPS
Add your answer
Q4. 3 DSA questions
Add your answer

Q1. Basic programming question 1. Longest Palindromic Substring 2. Pattern : a b b c c c 3. Given a string "ccabdd" convert to "c2a1b1d2"
Add your answer
Q2. Thorough Resume Based questions each and every technology mentioned in resume was asked in great detail.
Add your answer

Q1. Introduce Yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java and Python programming languages

• Proficient in web development technologies like HTML, CSS, and JavaScript

• Completed multiple projects showcasing my skills
Answered by AI
Add your answer
Q2. Will you like to work in a team or Solo
Ans. 
I prefer working in a team as it allows for collaboration, diverse perspectives, and shared responsibilities.
• Collaboration with team members leads to better problem-solving and innovation

• Diverse perspectives can lead to more creative solutions

• Shared responsibilities help distribute workload and prevent burnout
Answered by AI
Add your answer
Q3. Explain your projects
Ans. 
Developed a web application for tracking personal fitness goals and progress
• Used HTML, CSS, and JavaScript for front-end development

• Implemented a RESTful API using Node.js and Express for back-end functionality

• Utilized MongoDB for database management

• Incorporated chart.js for visualizing progress data
Answered by AI
Add your answer

It was a DSA round which consisted of three questions.
1)longest substring without repeating characters
2)largest subarray with sum 0
3)String based question

Q1. 1)Largest Area of Histogram
Ans. 
The largest area of a histogram is the maximum area that can be enclosed by a rectangle within the histogram bars.
• Calculate the largest area of a histogram by finding the maximum area of rectangles that can be formed within the histogram bars.

• This can be done by iterating through each bar and calculating the area of rectangles that can be formed with that bar as the height.

• Keep track of the maximum area found so far an...read more
Answered by AI
Add your answer
Q2. Minimum effort in an array
Ans. 
Find the string with minimum length in an array of strings.
• Iterate through the array and keep track of the minimum length string

• Return the string with the minimum length
Answered by AI
Add your answer