What is data mining?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is data mining?

Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high risk people to insure in a certain geographial area.

(Continued on next question...)

Other Job Interview Questions

• What is the definition of normalized and denormalized view and what are the differences between them?
• What type of Indexing mechanism do we need to use for a typical datawarehouse?
• What is a Star Schema?
• What is Dimensional Modelling? Why is it important ?
• What are Aggregate tables?
• What is the difference between Datawarehousing and BusinessIntelligence?
• What is Dimensional Modelling? Why is it important ?
• What is surrogate key ? where we use it expalin with examples
• Differences between star and snowflake schemas?
• What are the possible data marts in Retail sales.?
• More...