Rainbow Hospital Senior Manager Interview Questions and Answers

Q1. Technical questions based on my resume, coding, project architect, etc.
Add your answer

Q1. System design round. LLD and HLD.
Add your answer

Q1. Managerial with a little bit of technical. Work ethics, vision and ctc expectations.
Add your answer

Q1. Compensation discussion.
Add your answer

Q1. Previous Experience
Add your answer
Q2. Design Knowledge
Add your answer
Q3. Personally Based
Add your answer

Q1. Domain Knowledge Formal Testing
Add your answer
Q2. Lab Management Quality Assurance Design Assurance
Add your answer
Q3. Dv, TMV R&D Testing Mechanical
Add your answer

Q1. Salary Negotiation
Add your answer

Q1. Tell me about your self
Add your answer

Q1. What is the use of button when link can submit the form?
Ans. 
Buttons are used when an action needs to be performed, while links are used for navigation.
• Buttons are more suitable for actions like submitting a form, saving data, or triggering a function.

• Links are used to navigate to different pages or sections within a website.

• Buttons provide visual feedback when clicked, while links do not.

• Buttons can be styled and customized more easily than links.

• Buttons can have different stat
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

Q1. As per job profile experience
Add your answer
Q2. Knowledge of process of industry
Add your answer

Q1. Basic question asking about profile and qualification
Add your answer

Q1. Writing test was given to me
Add your answer

Q1. Hr round is there
Add your answer

Assignment is there

Q1. Technical interview with manager
Add your answer

Q1. Interview with higher management
Add your answer

Q1. Interview with higher management
Add your answer

Q1. Interview with ceo
Add your answer

Q1. Salary negotiation
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. You are perfect fit and you are hires
Add your answer