COVETUS Interview Questions and Answers

GET is used to retrieve data, PUT is used to update data, and POST is used to create new data.

• GET method is used to retrieve data from a server.

• PUT method is used to update existing data on a server.

• POST method is used to create new data on a server.

• GET requests are idempotent, while PUT and POST requests are not.

• GET requests should not have side effects, while PUT and POST requests can.

• Example: GET method can be used ...read more

SQL or stored procedure optimization techniques aim to improve performance by reducing execution time and resource usage.

• Use indexes to speed up data retrieval

• Avoid using SELECT * and instead specify only the necessary columns

• Minimize the use of functions in WHERE clauses

• Avoid using cursors and opt for set-based operations

• Regularly analyze query execution plans for potential optimizations

Stored procedures are precompiled SQL queries stored in the database, while functions are user-defined routines that return a value.

• Stored procedures can perform DML operations, while functions are used to compute and return a value.

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

• Stored procedures can call functions, but functions cannot call stored procedures.

ViewData, ViewBag, and TempData are used to pass data from controller to view in ASP.NET MVC.

• ViewData is a dictionary object used to pass data from controller to view. It requires typecasting to retrieve data.

• ViewBag is a dynamic property used to pass data from controller to view. No typecasting is required.

• TempData is a dictionary object used to pass data from one controller to another or from one action to another.

• Ex...read more

Triggers in SQL server are special stored procedures that are automatically executed in response to certain events on a particular table or view.

• Triggers can be used to enforce business rules, audit changes, or maintain referential integrity.

• There are two main types of triggers in SQL server: DML triggers and DDL triggers.

• DML triggers are fired in response to data manipulation language (DML) events like INSERT, UPDATE,...read more