Interview Questions

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

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.

The primary keys of entity tables are the foreign keys of dimension tables.

The Primary keys of fact dimensional table are the foreign keys of fact tablels.

Investment and asset are really close in meaning. Investment is when you put your money in stock, bond or other financial instruments. Whereas Asset is what you own generally reffered to land, proprietorship , factory, etc.

a.Direct interaction with customers: The retailer acts as the final link between the organisation and its customer. The retailer knows his customer better than anyone. He even suggests the customer what to purchase and allows him credit facilities to encourage frequent buying behaviour in the customer.

b.Small purchases: The customer purchases goods in small lots from the retail stores. So there are frequent visits to the retail store by the customer.

c.Instrument of marketing communication: via which information about the product is disseminated to the needy customers

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required

The process of arranging any items in a systematic manner in a logical sequence is called as Sorting. It can be of two types :

1. Ordering

Arranging items following some criterion like ascending or descending order

2. Categorizing

Grouping items with similar properties together.

Visual Foxpro was part of Visual Studio 6.0.

It was excluded in the .Net version and was released as an independent programming language.