Interview Questions

Profitability control is a mechanism of monitoring the sales made, profits earned and expenditure incurred by a company. The relative profit earning capacity of a firm’s products and consumer groups can be determined via profitability control. Sometimes surpisingly, it may be found out by companies how a small proportion of their products and even customers actually account for a significant percentage of the company’s profits. This can be achieved through profitability control. At times when the companies earn surplus profits, then such profits may even be ploughed back or reinvested. This also forms part of profitability control.

Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations.

Bitmap indexes are useful in the data warehousing applications.

Bitmap indexes have a significant space and performance advantage over other structures for such data.

Tables that have less number of insert or update operations can be good candidates.

The advantages of Bitmap indexes are:

   - They have a highly compressed structure, making them fast to read.

   - Their structure makes it possible for the system to combine multiple indexes together so that they can      access the underlying table faster.

The Disadvantage of Bitmap indexes is:

  - The overhead on maintaining them is enormous. 

Catalog views return information that is used by the SQL Server Database Engine. Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user- available catalog metadata is exposed through catalog views.

Personal financial planning is the process of creating and achieving financial goals.

True statements regarding personal financial planning:

As we age, the number and complexity of the financial decisions that we make increases.

There are two means for achieving financial goals—you either need to increase your savings or reduce spending.

A family's resources are limited.

The Singleton design pattern ensures a class only has one instance, and provides a global point of access to it. The class keeps track of its sole instance and ensures that no other instance can be created. Singleton classes are appropriate for situations where it makes sense for a single object to provide access to a global resource.Several Cocoa framework classes are singletons. They includeNSFileManager, NSWorkspace, NSApplication, and, in UIKit,UIApplication. A process is limited to one instance of these classes. When a client asks the class for an instance, it gets a shared instance, which is lazily created upon the first request.

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.

Some of the rules which should be followed while naming a variable in VB are as follows: 

1) Characters should be less than 255.

2) Space between characters should be allowed.

3) A variable should begin with a number.

4) Period may not be permitted.