Lilavati Hospital & Research Centre Interview Questions and Answers

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

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

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