Innovaccer Interview Questions, Process, and Tips for Experienced

Q1. SLQ basic questions
Add your answer
Q2. SQL Joins
Add your answer

Q1. SQL qeus to find 5th max salary of an employee from employee_table.
Ans. 
Use SQL query to find 5th max salary from employee_table.
• Use ORDER BY clause to sort salaries in descending order.

• Use LIMIT 1 OFFSET 4 to get the 5th highest salary.

• Example: SELECT salary FROM employee_table ORDER BY salary DESC LIMIT 1 OFFSET 4;
Answered by AI
Add your answer
Q2. Find avg salary of employees for each department & order employee within a department by age.
Ans. 
Calculate average salary of employees for each department and order employees within a department by age.
• Group employees by department and calculate average salary for each group

• Sort employees within each department by age

• Display the results
Answered by AI
Add your answer
Q3. Different between SLA & OLA
Ans. 
SLA is an agreement between a service provider and a customer, while OLA is an agreement between different teams within the same organization.
• SLA (Service Level Agreement) is an agreement between a service provider and a customer, outlining the level of service that is expected.

• OLA (Operational Level Agreement) is an agreement between different teams within the same organization, defining the responsibilities and expec...read more
Answered by AI
Add your answer
Q4. Views AND Triggers in SQL
Ans. 
Views and triggers are SQL database objects used for data manipulation and automation.
• Views are virtual tables that display data from one or more tables based on a query.

• Triggers are special stored procedures that are automatically executed in response to certain events on a table.

• Views can simplify complex queries by predefining joins and filters.

• Triggers can enforce data integrity rules or automate tasks like auditin...read more
Answered by AI
Add your answer

Q1. SQL Functions, Range, Rank, Dense Rank questions
Add your answer
Q2. Ticket Management
Add your answer

Q1. Managerial Round
Add your answer
Q2. Work Experience
Add your answer

Q1. Compensation Discussion
Add your answer

Q1. Solids conceps of oops , recurssion problem
Ans. 
Solid understanding of OOP concepts and recursion problem-solving skills are essential for a Senior SDET Software Engineer role.
• OOP concepts include encapsulation, inheritance, polymorphism, and abstraction.

• Recursion is a technique where a function calls itself to solve a problem.

• Understanding how to break down a problem into smaller subproblems and solve them recursively is key.

• Examples of recursion problems include f...read more
Answered by AI
Add your answer

In given array find sum of 3 number equal to targetsum

Q1. Dense rank, rank and row number
Add your answer
Q2. Self join HR data sql query
Add your answer

Q1. They asked Questions on join given two table A&B with one column each and u have to print out put for inner join, left join and correct join.
Add your answer
Q2. Then they asked medium level questions given , write query to print 2nd highest marks for each class using concept of windows function in SQL.
Add your answer

Q1. Managerial round
Add your answer
Q2. They asked all my project in my CV and deep discussion on each one. What is SCD type, what are composite key .
Add your answer

Q1. CTC negotiation
Add your answer
Q2. What u know about company and why u want to join company.
Add your answer