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;

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.

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.

One of the interview questions you may be asked is what you are looking for in your next job. The interview wants to know whether your goals are a match for the companies needs.

You can begin your answer with this question: Tell me, Mr./Ms. Interviewer, what is a typical career path at OPL for someone with my skills and experience?

(Based on the answer you can then respond to the original question using the phrases from the answer to frame your response).

What is important to you? Two things are very important to me. One is my professionalism at work; the second is my family life.

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.

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.