Innovaccer Software Engineer Interview Questions, Process, and Tips

Q1. What is the inheritance?
Ans. 
Inheritance is a mechanism in object-oriented programming where a class inherits properties and behaviors from another class.
• Allows a class to inherit attributes and methods from another class

• Promotes code reusability and reduces redundancy

• Creates a parent-child relationship between classes

• Derived class can override or extend the functionality of the base class
Answered by AI
Add your answer
Q2. What are the types of joins in mysql
Ans. 
Types of joins in MySQL include inner join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full join: Returns rows when there is a match in one of the tables.
Answered by AI
Add your answer

Q1. How to handle multiple api's
Ans. 
Use a centralized API gateway to manage and route requests to multiple APIs efficiently.
• Implement a centralized API gateway to handle incoming requests and route them to the appropriate API based on the endpoint.

• Utilize API management tools like Apigee, Kong, or AWS API Gateway to manage and monitor multiple APIs.

• Consider implementing a caching layer to improve performance and reduce the number of requests to external
Answered by AI
Add your answer
Q2. What does strstr function do?
Ans. 
strstr function searches for a substring within a string and returns a pointer to the first occurrence of the substring.
• Used in C programming language

• Syntax: char *strstr(const char *haystack, const char *needle)

• Example: char *str = strstr("hello world", "world")
Answered by AI
Add your answer

The topic given to me is AI is good or bad

Q1. Program to find prime number
Ans. 
A program to find prime numbers in a given range.
• Iterate through numbers in the given range

• Check if each number is divisible by any number other than 1 and itself

• If not divisible, then the number is prime
Answered by AI
Add your answer
Q2. Program to find the duplicates
Ans. 
Program to find duplicates in an array of strings
• Iterate through the array and store each element in a hash set

• If an element is already in the hash set, it is a duplicate

• Return a list of all duplicates found
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Explanation of project code
Ans. 
The project code is a web application that allows users to create and share interactive quizzes.
• The code uses HTML, CSS, and JavaScript to create the front-end interface.

• It utilizes Node.js and Express for the back-end server.

• MongoDB is used as the database to store user-generated quizzes.

• Socket.io is used for real-time communication between users during quiz sessions.
Answered by AI
Add your answer

Q1. They asked to design a database table
Add your answer

Q1. Why you want to join Amadeus
Add your answer
Q2. WHy left the previous company
Add your answer
Q3. What do you know about Amadeus
Add your answer
Q4. Why we should pay you this much
Add your answer

3 - 4 DSA questions from GeeksforGeeks

Q1. Describe OOPS concepts in java
Ans. 
OOPS concepts in Java are the principles of Object-Oriented Programming such as Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability of a method to do different things based on the object it is acting upon.

• Abstraction: Hiding th...read more
Answered by AI
Add your answer
Q2. DSA questions mostly easy to moderate
Add your answer

Good , just practice Leet code easy questions

Q1. LRU Cache question and couple on array
Add your answer

Q1. System Design question related to Lift
Add your answer

Q1. Managerial, project related and SQL
Add your answer

Q1. Will you be able to work in Rotational Shifts?
Add your answer
Q2. How much experience do you have in SQL and Node JS.
Ans. 
I have 5 years of experience in SQL and Node JS.
• I have worked extensively with SQL databases, writing complex queries and optimizing performance.

• I am proficient in using Node JS for server-side development, building RESTful APIs and handling database operations.

• I have experience in integrating SQL databases with Node JS applications using libraries like Sequelize or Knex.

• I have successfully delivered projects that invo...read more
Answered by AI
Add your answer

Q1. What is Index in SQL?
Ans. 
Indexes in SQL are data structures that improve the speed of data retrieval operations on database tables.
• Indexes are created on one or more columns of a table to allow faster searching and sorting of data.

• They work similar to the index of a book, allowing the database engine to quickly locate the data.

• Indexes can be created on primary keys, foreign keys, or any other frequently searched columns.

• They reduce the amount ...read more
Answered by AI
Add your answer
Q2. What are the different types of Normalization in DBMS?
Ans. 
Normalization is a process in DBMS that eliminates data redundancy and ensures data integrity.
• Normalization is used to organize data in a database efficiently.

• There are different normal forms, such as 1NF, 2NF, 3NF, BCNF, and 4NF.

• Each normal form has specific rules and dependencies to achieve data normalization.

• Normalization helps in reducing data duplication, improving data consistency, and simplifying database mainte...read more
Answered by AI
Add your answer
Q3. What do you know about Views in mySQL?
Ans. 
Views in mySQL are virtual tables that are based on the result of a query. They can be used to simplify complex queries and provide a layer of abstraction.
• Views are created using the CREATE VIEW statement.

• They are stored in the database and can be accessed like regular tables.

• Views can be used to hide complexity by encapsulating complex queries into a single view.

• They can also be used to restrict access to certain colu...read more
Answered by AI
Add your answer
Q4. What are Stored Procedures?
Ans. 
Stored Procedures are precompiled database objects that contain a set of SQL statements and can be executed with a single call.
• Stored Procedures are used to encapsulate and execute frequently used SQL statements.

• They improve performance by reducing network traffic and optimizing query execution.

• They can accept input parameters and return output values.

• Stored Procedures can be used for data manipulation, data retrieval,...read more
Answered by AI
Add your answer
Q5. Tell me something about Internet of Things.
Ans. 
Internet of Things (IoT) refers to the network of physical devices, vehicles, appliances, and other objects embedded with sensors, software, and connectivity.
• IoT enables devices to collect and exchange data over the internet.

• It allows for remote monitoring and control of devices and systems.

• IoT has applications in various industries such as healthcare, transportation, agriculture, and smart homes.

• Examples of IoT device...read more
Answered by AI
Add your answer

Q1. Questions about Past Experience, the projects I have worked on.
Add your answer
Q2. What does JWT stand for? How do we use them?
Ans. 
JWT stands for JSON Web Token. It is a compact, URL-safe means of representing claims between two parties.
• JWT is used for authentication and authorization purposes in web applications.

• It consists of three parts: header, payload, and signature.

• The header contains the algorithm used to sign the token.

• The payload contains the claims or information about the user.

• The signature is used to verify the integrity of the token.

• J...read more
Answered by AI
Add your answer
Q3. What is the difference between Webtokens and APIs?
Ans. 
Webtokens and APIs are both used in web development, but they serve different purposes.
• Webtokens are used for authentication and authorization, providing a secure way to transmit user information between client and server.

• APIs (Application Programming Interfaces) are sets of rules and protocols that allow different software applications to communicate and interact with each other.

• Webtokens are often used within APIs to...read more
Answered by AI
Add your answer
Q4. What is oAuth, what method did you use for Authentication/ Authorisation is your project?
Ans. 
oAuth is an open standard for authorization. In my project, I used the oAuth 2.0 protocol for authentication and authorization.
• oAuth is a protocol that allows users to grant limited access to their resources on one website to another website without sharing their credentials.

• It provides a secure way for users to authenticate and authorize third-party applications to access their data.

• oAuth 2.0 is the most widely used v...read more
Answered by AI
Add your answer
Q5. If the data in a table is already normalized, what can we do to further optimize is?
Ans. 
Further optimization of normalized data can be achieved through indexing, denormalization, and caching.
• Create appropriate indexes on frequently queried columns to improve query performance.

• Consider denormalizing the data by combining related tables to reduce the number of joins required.

• Implement caching mechanisms to store frequently accessed data in memory for faster retrieval.

• Use materialized views or summary tables...read more
Answered by AI
Add your answer
Q6. How do you perform indexing in a database, which column you use for indexing?
Ans. 
Indexing in a database improves query performance by creating a data structure that allows for faster data retrieval.
• Indexing involves creating an index on one or more columns of a database table.

• The column used for indexing should be chosen based on the frequency of data retrieval and the cardinality of the column.

• Columns with high selectivity and frequent data retrieval are good candidates for indexing.

• Examples of co...read more
Answered by AI
Add your answer