Unthinkable Solutions Interview Questions and Answers

I participated in a coding round on their platform, which consisted of three coding questions in 60 min. however, their editor and compiler were quite inadequate. The event was held onsite, with 500 candidates arriving on January 11, 2024, at 9 AM. Approximately 100 candidates cleared that round.

I solved all three questions, yet we still had to participate in the second round, which included one coding question to be completed in 20 minutes. The question was poorly framed, leading to the rejection of most students. However, I managed to solve all the test cases.

The coding round comprised one question and was conducted on paper for a duration of 10 minutes.

Q1. It was the puzzle question involving five numbered fingers where you need to determine which finger corresponds to a given number in constant time complexity O(1)?
Add your answer
Q2. Write code for searching in a 2D matrix with a time complexity of O(mlogn)?
Ans. 
Implement a binary search in each row of a sorted 2D matrix to achieve O(mlogn) time complexity.
• Divide and conquer approach can be used to search in each row of the matrix.

• Perform binary search on each row to find the target element efficiently.

• Ensure the rows are sorted to apply binary search in each row.
Answered by AI
Add your answer
Q3. How would you design a store management system, including all relevant schema tables?
Ans. 
Design a store management system with relevant schema tables
• Create a 'Store' table with attributes like store_id, name, location, etc.

• Design a 'Product' table with attributes like product_id, name, price, quantity, etc.

• Include a 'Sales' table to track sales transactions with attributes like sale_id, date, total_amount, etc.

• Implement a 'Stock' table to manage product stock levels with attributes like stock_id, product_i...read more
Answered by AI
Add your answer
Q4. Design schema of your project
Ans. 
The schema of my project is designed to efficiently store and retrieve data for a web application.
• Use relational database to store structured data

• Create tables for different entities like users, products, orders

• Establish relationships between tables using foreign keys

• Use indexes to optimize query performance
Answered by AI
Add your answer
Q5. Design category schema where category can have multiple sub categories
Ans. 
Design a category schema with multiple subcategories
• Use a parent-child relationship to link categories and subcategories

• Implement a tree data structure to represent the hierarchy

• Each category can have multiple subcategories

• Example: Category - Electronics, Subcategories - Computers, Mobile Phones, TVs
Answered by AI
Add your answer

Q1. Questions related to javascript
Add your answer
Q2. Sql queries which consists of group and joins
Ans. 
SQL queries involving group by and joins are used to retrieve data from multiple tables and aggregate results.
• Use GROUP BY to group rows that have the same values in specified columns

• Use JOIN to combine rows from two or more tables based on a related column

• Examples: SELECT column1, SUM(column2) FROM table1 JOIN table2 ON table1.id = table2.id GROUP BY column1
Answered by AI
Add your answer

Q1. Can you provide your introduction?
Ans. 
I am a passionate software engineering student with experience in Java, Python, and web development.
• Currently pursuing a degree in Computer Science

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

• Completed internships at tech companies working on software projects

• Participated in coding competitions and hackathons
Answered by AI
Add your answer
Q2. Why do you want to join this company?
Ans. 
I am impressed by the company's innovative projects and collaborative work culture.
• Impressed by innovative projects

• Desire to work in collaborative environment

• Company's reputation in the industry
Answered by AI
Add your answer

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

Round 1 -> 3 easy coding questions (I did all three)
round2 -> 2 coding questions (1 was leetcode's trapping rainwater problem) (Did 1.5)

Q1. SQL query was asked on joins etc
Add your answer
Q2. What are Microservcies, solid principles, a pattern printing question, oops concepts
Add your answer

Q1. Designing dbms for a college website
Ans. 
Designing a DBMS for a college website involves creating tables for students, courses, faculty, and more.
• Create tables for students, courses, faculty, departments, etc.

• Establish relationships between tables using foreign keys.

• Include attributes like student ID, course ID, faculty ID, etc.

• Implement normalization to reduce redundancy and improve data integrity.

• Consider implementing views for complex queries or reports.
Answered by AI
Add your answer
Q2. Implement debouncing, create a nodejs server with a get / post api, a puzzle, javascript questions like clousers, let / var / const, event loop, output based questions etc.
Ans. 
Implement debouncing, create a nodejs server with get/post api, and answer JavaScript questions.
• Implement debouncing by using setTimeout and clearTimeout to limit the number of times a function is called.

• Create a nodejs server with Express framework to handle get and post requests.

• Answer JavaScript questions on closures, let/var/const, event loop, and output based questions.

• Provide examples for each concept to demonstr...read more
Answered by AI
Add your answer

Q1. MySQL questions
Add your answer
Q2. DSA and pattern printing
Add your answer