Interview Questions

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. 

No problem. We can use network marketing as an alternative. The company already has its strong network of customers who can spread the word about its products. They can encourage referral rewards for say every three customers who will buy our product or avail our service.

We can also announce a contest for the customers to buy the product and win a chance to get himself broadcasted for the product advertisement. We can ask them to send in their photo along with the contest application form which they get alongwith the product they buy. So we don’t have to pay them as we would otherwise have to pay to a celebrity.

Debenture holder are those who provides long term loan at specific interest rate in term of cash and creditor provides only short term credit in term of cash for purchasing of goods.

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.

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.

Fixed Foreign Exchange rate can be changed by Reserve Bank Of India (RBI).

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.