Innova Solutions Full Stack Developer Interview Questions and Answers

Python SQL related questions

Python SQL related coding test

Q1. Why are you applying for this job
Add your answer
Q2. Why should we hire you
Add your answer
Q3. Why did you leave last job
Add your answer
Q4. What is more important to you the money or the work
Add your answer
Q5. Would do you know about this organization
Add your answer

Regarding To My Full Stack

Regarding To My Full Stack

Q1. What Is Python And Discuss With Some Questions
Add your answer
Q2. In that Case Studies
Add your answer

Q1. Cache implementation in spring boot
Ans. 
Spring Boot provides support for caching through annotations like @Cacheable, @CacheEvict, @CachePut.
• Use @EnableCaching annotation to enable caching in Spring Boot application

• Use @Cacheable annotation to cache the result of a method

• Use @CacheEvict annotation to remove entries from the cache

• Use @CachePut annotation to update the cache without interfering with the method execution
Answered by AI
Add your answer
Q2. Few coding questions
Add your answer

There are 4 coding questions in first round

Q1. Some basic statistics questions and data structure questions
Add your answer

Q1. Questions on full stack Devlopment
Add your answer
Q2. Questions asked on React,Nodejs
Add your answer

There will be machin test on best on MERN stack

Q1. Questions on OOPS mainly inheritance Questions on Core Java Tricky questions on collections Questions on Java 8
Add your answer
Q2. Questions on JavaScript What is a closure
Add your answer

Round duration - 100 minutes
Round difficulty - Hard

The test had 3 parts:
1. Aptitude - 20 questions to be done in 25 minutes. (Medium level)
2. Technical MCQs - 25 questions to be done in 35 minutes. (Medium-Hard level) (HTML, JS, CSS, SQL)
3. Coding - 2 out of 3 questions to be done in 40 minutes. 20 minutes were allotted for each question. No switching between the codes was allowed. (1-easy, 2-medium in total)

Q1. 
Count Set Bits Problem Statement
Given a positive integer N, compute the total number of '1's in the binary representation of all numbers from 1 to N. Return this count modulo 1e9+7 because the result can...read more
Ans. Brute Force
The key idea is to count the number of set bits in each number from 1 to n and return the sum of all set bits.
 
The algorithm will be -
 
• For each i from 1 to N -
  • We find the number of set bits for each i.
  • This can be done using a built-in function (for eg builtin_popcount in c++) or by simply using a loop and left shifting the number and finding if the last place is set or not.
• Finally we store the coun...read more
Answered Anonymously
Add your answer
Q2. 
Smallest Number with Given Digit Product
Given a positive integer 'N', find and return the smallest number 'M', such that the product of all the digits in 'M' is equal to 'N'. If such an 'M' is not possib...read more
Ans. Brute force
A simple approach will be to iterate through all possible ‘M’ values, i.e., from ‘1’ to ‘2147483647’ (the largest value that a signed 32-bit integer field can hold), and check if their digit multiplication is equal to ‘N’.
 
Algorithm:
• Run a loop where ‘i’ ranges from ‘1’ to ‘2147483647’:
  • Set ‘CUR = i’. The current ‘M’ value.
  • Set ‘MUL = 1’. Use it to store the digit multiplication of ‘M’.
  • Run a loop until ‘cu...read more
Answered Anonymously
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

It was the first face-to-face technical round. The medium was ModernHire. There was only 1 member in the interview panel. This round tested me on C fundaments, Operating System basics, and problem-solving skills.
Questions asked:
What are the TRUNCATE, DELETE and DROP statements?
What are void elements in HTML?
Define multipart form data?
1. How does the C compiler works?
2. What are deadlocks and why does it happen?
3. How to resolve deadlock?
4. What is a kernel?
5. How to dynamically allocate memory in C?
6. What is makefile?
7. What is multi-threading and why is it useful?
8. What is the need for synchronization in OS?
9. How do you run a program of 10 GB using 2 GB memory?
10. What are semaphores and mutex?
11. How is HashMap implemented?
12. Difference between linker and loader.
13. Importance of header files.
14. What is Dynamic binding?
15. What type of database should you use where transactions are involved?
16. Brief discussion on the Internship experience.

Q1. 
Merge Sort Problem Statement
You are given a sequence of numbers, ARR. Your task is to return a sorted sequence of ARR in non-descending order using the Merge Sort algorithm.
Explanation:
The Merge Sort...read more
Ans. Recursion
The basic idea is that we divide the given ‘ARR’ into two-part call them ‘leftHalves’ and ‘rightHalves’ and call the same function again with both the parts. In the end, we will get sorted ‘leftHaves’ and sorted ‘righthalves’ which we merge both of them and return a merged sorted ‘ARR’.
We implement this approach with a divide and conquer strategy.
 
Here is the algorithm : 
 
1. Divide ‘ARR’ into two-p...read more
Answered Anonymously
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

This was a managerial cum technical round. I was asked to introduce myself (both technical details and hobbies). Then I was asked about my internship experiences and what I learnt from them. After that, he asked me questions about the projects mentioned in my resume. He tested my in-depth knowledge of the technologies that I used. He also asked me about the alternative solutions and the drawbacks of my solution.
After that, he asked me to speak about Operating Systems for 5 minutes without giving a pause. Then he asked me to speak about the OSI model and the TCP/IP model for the next 5-10 minutes again without giving a pause. He appreciated my perfomance and gave me a coding question.
What is User-defined function? What are its various types in SQL. What is an Alias in SQL?
Then he asked me whether I had any questions.

Q1. 
Find a Node in Linked List
Given a singly linked list of integers, your task is to implement a function that returns the index/position of an integer value 'N' if it exists in the linked list. Return -1 i...read more
Ans. Recursive Approach
The steps are as follows:
 
1. If the head is null, return -1 since an empty list will obviously not contain the element that we need to look for.
2. Check whether the head’s data is equal to the element we want to search. Return 0 if it is.
3. Then recurse on the next node from the head and get its answer.
4. If the answer from the recursive call is -1, your answer is also -1 since you already check the head’s d...read more
Answered Anonymously
Add your answer

Round duration - 15 minutes
Round difficulty - Easy

Typical HR questions were asked in this round.