Wipro DOT NET Developer Interview Questions, Process, and Tips

Filters in dot net are used to perform data manipulation and transformation operations on collections.

• Filters can be used to extract specific elements from a collection based on certain criteria.

• They can also be used to modify or transform the elements of a collection.

• Filters can be applied using LINQ (Language Integrated Query) in dot net.

• Examples of filters include Where, Select, OrderBy, and GroupBy.

• Filters can be c...read more

Indexes in SQL are database structures that improve the performance of data retrieval operations.

• Indexes are created on one or more columns of a table.

• They allow the database to quickly locate and retrieve specific data.

• Indexes can be created on primary keys, foreign keys, or any other frequently queried columns.

• They reduce the need for full table scans and improve query performance.

• Examples of indexes include clustere...read more

Constraints in SQL are rules that are applied to the columns or tables to maintain data integrity.

• Constraints ensure that the data in the database follows certain rules and conditions.

• Common types of constraints include primary key, foreign key, unique, not null, and check constraints.

• Constraints can be defined at the column level or table level.

• They help in preventing invalid or inconsistent data from being inserted o...read more

Delegate is a type that represents references to methods with a specific parameter list and return type.

• Delegates are similar to function pointers in C++ or pointers to member functions in C++.

• Delegates allow methods to be passed as parameters.

• Delegates can be used to define callback methods.

• Delegates can be multicast, meaning they can hold references to multiple methods.

• Example: delegate void MyDelegate(string message

Connection pool is a cache of database connections maintained so that the connections can be reused when needed.

• Connection pool helps in improving performance by reusing existing connections instead of creating new ones every time.

• It helps in reducing the overhead of establishing a new connection to the database.

• Connection pool size can be configured to control the maximum number of connections that can be opened at a ...read more