Seadrill Interview Questions and Answers

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 time.

• Example: In a web application, connection pool allows...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 clustered indexes, non-clustered indexes, and unique indexes.

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);

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 chained together to perform complex data manipulations.