What are the benefits of SQL ?
1. It is flexible, Powerful and easy to learn. 2. It is a non-procedural language. It a] Processes set of records rather than just one at a time and b] Provides... Read more »
Archive for June, 2006
What are the pros and cons of creating extended stored procedures?
The pros are that you can implement additional functionality and access data from DLLs from within SQL Server. If you need to do something that can be done only... Read more »
What is difference between ‘Count’ and ‘Count(*)’?
The Difference between ‘Count’ and ‘Count(*)’ A. ‘Count’: Counts the number of non-null values. ‘Count(*)’: Counts... Read more »
Why does my inline or embedded SQL run faster than my stored procedures?
Recompilations might be the source of the slower stored procedure speed. To find out for sure, you need to do some performance investigation, such as looking at... Read more »
What is SKAT?
Symbolic Knowledge Acquisition Technology (SKAT). A system based on SKAT develops an evolving model from a set of elementary blocks, sufficient to describe an arbitrarily... Read more »
What is Memory Based Reasoning (MBR)?
To forecast a future situation, or to make a correct decision, such systems find the closest past analogs of the present situation and choose the same solution which... Read more »
Give reasons for the growing popularity of Data Mining.
Reasons for the growing popularity of Data Mining Growing Data Volume The main reason for necessity of automated computer systems for intelligent data analysis is... Read more »
What is Market Basket Analysis?
Processing transactional data in order to find those groups of products that are sold together well. One also searches for directed association rules identifying... Read more »
What is Clustering?
Clustering. Sometimes called segmentation, clustering identifies people who share common characteristics, and averages those characteristics to form a “characteristic... Read more »
Who were the three famous amigos and what was their contribution to the object community?
The Three amigos namely, James Rumbaugh (OMT): A veteran in analysis who came up with an idea about the    objects and their Relationships (in particular Associations). Grady... Read more »
What is meant by “method-wars”?
Before 1994 there were different methodologies like Rumbaugh, Booch, Jacobson, Meyer etc who followed their own notations to model the systems. The developers were... Read more »
Differentiate Aggregation and containment?
Aggregation is the relationship between the whole and a part. We can add/subtract some    properties in the part (slave) side. It won’t affect the whole... Read more »
Differentiate persistent & non-persistent objects?
Persistent refers to an object’s ability to transcend time or space. A persistent object stores/saves its state in a permanent storage system with out losing... Read more »
List out some of the object-oriented methodologies.
Object Oriented Development (OOD) (Booch 1991,1994). Object Oriented Analysis and Design (OOA/D) (Coad and Yourdon 1991). Object Modelling Techniques (OMT)Â... Read more »
When does a name clash occur?
A name clash occurs when a name is defined in more than one place. For example., two different class libraries could give two different classes the same name. If... Read more »