Nirvasa Healthcare Senior Manager Quality Interview Questions and Answers

Basic problem solving easy to medium level

Q1. Coding questions based on loops, arrays
Add your answer

Q1. Coding a sorting algorithm
Ans. 
Sorting algorithm arranges elements in a specific order.
• Choose an appropriate sorting algorithm based on the data size and type.

• Common sorting algorithms include bubble sort, insertion sort, merge sort, quicksort, and selection sort.

• Implement the chosen algorithm in the programming language of choice.

• Test the algorithm with various input sizes and types to ensure correctness and efficiency.
Answered by AI
Add your answer

Sorting, Arrays, String. Easy to medium level questions were asked

Q1. OOPs concepts, OS, DB questions
Add your answer

Q1. What is the use of button when link can submit the form?
Ans. 
Buttons are used for actions within the form, while links are used for navigation.
• Buttons can trigger JavaScript functions or perform form validation before submission

• Buttons can have different styles and behaviors compared to links

• Buttons are more accessible for users with disabilities
Answered by AI
View 1 more answer

Q1. How do you optimize a SQL procedure with 5000 lines in code?
Ans. 
Optimize a SQL procedure with 5000 lines of code by identifying bottlenecks and implementing performance improvements.
• Identify and analyze the most time-consuming parts of the procedure

• Optimize queries by adding appropriate indexes, rewriting queries, or using query hints

• Break down the procedure into smaller, more manageable parts

• Use temporary tables or table variables to reduce the amount of data processed at once

• Cons...read more
Answered by AI
Add your answer
Q2. Keep SQL procedures short, use multiple small procedure with specific functionality being used, avoid use of temp tables and Joins, use select statements wisely. do not use sub queries, do not use dynamic ...read more
Ans. 
To optimize SQL procedures, keep them short, use small procedures with specific functionality, avoid temp tables and joins, use select statements wisely, avoid subqueries and dynamic SQL.
• Break down complex procedures into smaller ones with specific functionality

• Avoid using temporary tables and joins whenever possible

• Use select statements wisely to retrieve only the necessary data

• Avoid subqueries and find alternative ap...read more
Answered by AI
Add your answer