Reliance Jewels Interview Questions and Answers

A stored procedure is a precompiled set of SQL statements that can be called by name, while a function returns a value.

• Stored procedures are used to perform a specific task, such as inserting or updating data in a database.

• Functions return a value, while stored procedures do not necessarily return a value.

• Stored procedures can be called from within other SQL statements, while functions cannot.

• Stored procedures can have input and output parameters, while functions can only hav...read more

SQL joins are used to combine data from two or more tables based on a related column between them.

• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the right table

• Right join returns all rows from the right table and matching rows from the left table

• Full outer join returns all rows from both tables

• Cross join returns the Cartesian product of both tables

In MVC, we can redirect to a different page using the RedirectToAction method.

• Use the RedirectToAction method in the controller action method

• Pass the action name and controller name as parameters to the method

• Optionally, pass route values as a parameter to the method

• Example: return RedirectToAction("Index", "Home");

TempData stores data for a single request while Session stores data for multiple requests.

• TempData is used to store data temporarily for a single request.

• Session is used to store data for multiple requests.

• TempData is cleared after a single request while Session data persists until the session expires or is cleared.

• TempData is useful for passing data between actions while Session is useful for maintaining user-specific data across multiple requests.

Index is a pointer to a specific element in an array or database table.

• Indexes improve query performance by reducing the number of rows that need to be scanned.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes create a separate structure.

• Unique indexes ensure that each value in the index column is unique, while composite indexes combine multiple column...read more