Technology Questions

A finally block will always be executed, whether or not an exception is actually thrown. Even in the case where the catch statement is missing and an exception is thrown, the finally block will still be executed. Last thing to mention is that the finally block is used to release resources like I/O buffers, database connections, etc.

Vectors are sequence containers representing arrays that can change in size.

SELECT YEAR(GETDATE()) as "Year";

The different implementations of LINQ are:

      =>  LINQ to SQL - Refers to a component of.NET Framework version 3.5 that    provides a run-time infrastructure to manage relational data as objects.

      =>   LINQ to DataSet - Refers to a component that makes it easier and faster to query over data cached in a DataSet object.

      =>   LINQ to XML - Provides an in-memory XML programming interface.

      =>  LINQ to Objects - Refers to the use of LINQ queries with any IEnumerable or IEnumerable(T) collection directly, without the use of an intermediate LINQ provider or API, such as LINQ to SQL or LINQ to XML.

Enumeration is twice as fast as compared to an Iterator and uses very less memory. However, the Iterator is much safer compared to Enumeration, because other threads are not able to modify the collection object that is currently traversed by the iterator. Also, Iteratorsallow the caller to remove elements from the underlying collection, something which is not possible with Enumerations.

- Debugging is esy.
- Reduces Development Time.
- LINQ offers IntelliSense which means writing more accurate queries easily.

It is a compilation error it should be X extends Y implements Z