Instinct Innovations Software Developer Interview Questions and Answers

Basic Aptitude question were asked around 20 Question of Aptitude and 20 of basic debugging of C language code. Before aptitude there was a essay writing on "factors which increases the market of E-commerce platforms"

There were 4 coding question and 2 SQL questions. Basic pattern printing question and easy question of leetcode were there in coding and in SQL from "joins" topic.

Same as the previous round more question of Coding and SQL, plus in the starting they would ask about your tech stack and then assign you a stack for the same.

Q1. How Selection Sort Works.
Ans. 
Selection Sort is a simple sorting algorithm that repeatedly selects the smallest element from an unsorted portion and swaps it.
• 1. Start with the first element as the minimum.

• 2. Compare this minimum with the rest of the array to find the smallest element.

• 3. Swap the smallest found element with the first element.

• 4. Move to the next position and repeat the process for the remaining unsorted elements.

• Example: For array [6...read more
Answered by AI
Add your answer
Q2. How JOINs work in MYSQL
Add your answer
Q3. Diffrence between Left JOIN and Inner JOIN
Add your answer

Basic knowledge required for the Aptitude Test. You need to understand the questions and their technicality and then each question is very easy.

Need to focus more on the SQL Queries and some average coding skills. This test is used to check the code understanding of the candidate.

Little more complex problems, need to understand the logic and some complex SQL Queries.
More Focus on JOINS in SQL.

40 Minutes. 40 Question in office Test.
20 Questions Programming related and 20 Questions Aptitude

Strong appitude knowledge is required.

Q1. String , arrays, oops
Add your answer

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple ...read more
Answered by AI
Add your answer

Mathematical and logical questions including distance -time, work -time, reasoning, blood relation etc

Q1. Database queries including joins.
Add your answer

DSA moderate question like string reverse, string rotation, frequency of letter in a string.

Simple questions of quant and coding output

3 coding question and one pattern question

Q1. Discussions on questions of prev round
Add your answer
Q2. One SQL query need to implement
Add your answer