Dev Technosys Interview Questions and Answers

CTE is a temporary result set that can be referenced within a query, while a subquery is a query nested within another query.

• CTE stands for Common Table Expression and is defined using the WITH keyword.

• CTEs can be referenced multiple times within a query.

• Subqueries are enclosed in parentheses and can only be referenced once in a query.

• Subqueries can be correlated or non-correlated.

• CTEs are generally used for readabilit...read more

Middleware in MVC Core is software components that are used to handle requests and responses in the application pipeline.

• Middleware components are added to the application pipeline in the Startup class using the UseMiddleware method.

• Each middleware component in the pipeline can inspect, modify, or short-circuit the request pipeline.

• Middleware components can perform tasks such as authentication, logging, error handling,...read more

I will prioritize clear communication, document changes, assess impact, and adjust project plan accordingly.

• Prioritize clear communication with the client to understand the reasons behind the frequent changes

• Document all changes in requirements to maintain a clear record of the evolving project scope

• Assess the impact of each change on project timeline, budget, and resources

• Adjust the project plan accordingly to accommo...read more