Interview Questions

The purpose of garbage collection is to identify and discard those objects that are no longer needed by the application, in order for the resources to be reclaimed and reused.

SELECT statement has resulted in retrieval of more than one row.

Print third array element document.write(names[2]);

Note:- Array index starts with 0.

BUS topology:

In this each computer is directly connected to primary network cable in a single line.

STAR topology:

In this all computers are connected using a central hub.

We can say that sales promotion is a cost effective technique by which an organisation can achieve its sales volume or the marketing objectives by providing value added product and not just an ordinary product to the end user or even the intermediaries. It is short term by nature and is suitable enough for generating sales within a short span of time. Sales promotion techniques are being increasingly used by retailing organisations some of which include advertising, providing discounts and allowances or a 'buy one get one free offer' etc.

Consigner is the person who is the owner of the goods and who delivers the goods to others(consignee) Whereas Consignee is the person who receives the goods and just holds the goods and will not be the owner.

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.