Interview Questions

Use SELECT DISTINCT ..... in DB2 query

The DISTINCT keyword can be used to return only distinct (different) values.

Syntax:

     SELECT DISTINCT column1,column2

      FROM table_name;

Most people say "Yes" and do not add more to it. Use this opportunity to market yourself and express interests and activities that are aligned with job role you are applying.

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

.NET’s Base class library exists in order to encapsulate huge number of common functions and makes them easily accessible to the developer. .NET base class library provides the functionality like ADO.NET, XML, Threading, IO, Security, Diagnostics, Resources, Globalization, collections etc. It serves as the main point of interaction between developer and runtime.

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

Yield to maturity is a concept for fixed rate bonds and is the internal rate of return i.e. the rate at which future flows are discounted on a compound basis to give the present value of the bond including accrued interest.

The object need to be serialized when it’s sent over a network and when it’s state is saved. Exceptions which occur during serialization are:

a. transient fields

b. when the base class is serialized then only base class fields are handled.

c. static fields are ignored because they are not part of any state.

Secondary market refers to market where securities are traded after being initially offered to the public in the primary market and/or listed on the stock exchange.