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;

In the light of competition, it may be seen that competitors may initiate price changes. If the cutting off on prices does not affect the company, then the current pricing strategy itself can be continued to maintain the profitability of the company. However if the price change on one firm is affecting the other, then it can:

a.reduce the product price at par with competitors’ price or below competitors’ price

or

b. Provide added advantage to the existing product like better quality, or ‘a buy one get one free’ offer.

or

c.Provide better quality of the product at a higher price thereby not being at par with the competitors.

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.

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.

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".
LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

Bank Rate is the interest rate at which the RBI allows finance to commercial banks. By Bank Rate, we mean bank can regulate the level of economic activity.

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

Managerial Accounting is also called as Management accounting or Cost accounting. It is the process of identifying, measuring, analyzing, interpreting, and communicating information to managers of an organization. Then that managers use the provisions of accounting information in order to better inform themselves before they decide matters within their organizations, which aids their management and performance of control functions.