Anand Rathi Information Technology Interview Questions and Answers

Different types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN: Returns rows when there is at least one 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.

Stored Procedures are used to perform a set of actions, while Functions return a value.

• Stored Procedures can perform multiple actions and may or may not return a value

• Functions always return a value and are used for calculations or data retrieval

• Stored Procedures can have input/output parameters, while Functions only have input parameters

• Stored Procedures are called using EXECUTE command, while Functions are called in

MVC is a software architecture pattern. Routing is the process of directing HTTP requests to the appropriate controller. Finally block is used to execute code after a try-catch block.

• MVC stands for Model-View-Controller

• Routing is used to map URLs to specific actions in a controller

• Finally block is used to ensure that a section of code is always executed, even if an exception is thrown