Wayspire Ed-Tech Private Limited Interview Questions and Answers

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 all sessions and are dropped when the last session using the...read more

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, while correlated query is used to compare values from the o...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.

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 JOIN returns rows when there is a match in one of the tabl...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