Insight Direct India 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
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