V3M Technologies Interview Questions, Process, and Tips

Temporary table is a table that exists temporarily and is automatically deleted when the session ends.

• Temporary tables are used to store intermediate results during a complex query.

• Types of temporary tables include local temporary tables and global temporary tables.

• Local temporary tables are only visible to the current session and are automatically dropped when the session ends.

• Global temporary tables are visible to al...read more

Indexers allow objects to be indexed like arrays

• Indexers are special properties in C# that allow objects to be indexed like arrays

• They are defined using the 'this' keyword followed by square brackets containing the index parameters

• Indexers can be used to access elements in a class as if it were an array

Stored procedures offer improved performance, security, and code reusability in database operations.

• Improved performance by reducing network traffic and optimizing query execution

• Enhanced security by preventing SQL injection attacks and controlling access to data

• Code reusability by allowing multiple applications to use the same stored procedure

• Encapsulation of complex logic for easier maintenance and debugging

Joins are used to combine rows from two or more tables based on a related column between them.

• Types of 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 ...read more

ViewBag is a dynamic property that allows you to pass data from the controller to the view, while ViewData is a dictionary object.

• ViewBag is a dynamic property in MVC that uses the dynamic keyword to pass data from the controller to the view.

• ViewData is a dictionary object that is used to pass data from the controller to the view.

• ViewBag is a wrapper around ViewData, providing a more concise syntax for passing data.

Subquery is a query nested within another query, while correlated query is a subquery that depends on the outer query.

• Subquery is independent of the outer query, while correlated query is dependent on the outer query

• Subquery is executed first and its result is passed to the outer query, while correlated query is executed for each row of the outer query

• Subquery can be used to return a single value or a list of values, w...read more