Data mining interview questions and answers

Data mining interview questions and answers for freshers and experienced candidates. These interview questions and answers on data mining will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. Many candidates appear for the interview for one role - many of the them give the right answers to the questions asked. The one who provides the best answer with a perfect presentation is the one who wins the interview race. The set of data mining interview questions here ensures that you offer a perfect answer to the interview questions posed to you.
          

Data Mining interview questions and answers

 <<Previous  Next>>
Explain the storage models of OLAP.

MOLAP Multidimensional Online Analytical processing -  In MOLAP data is stored in form of multidimensional cubes and not in relational databases....................
Read answer

Differentiate between Data Mining and Data warehousing.

Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse. Where as data mining aims to examine or explore the data using queries...................
Read answer

Data mining interview test (50 questions)
Data mining interview test (15 questions)

What is Data purging?

The process of cleaning junk data is termed as data purging. Purging data would mean getting rid of unnecessary NULL values of columns.................
Read answer

What are CUBES?

A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily..................
Read answer

What are OLAP and OLTP?

OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data..................
Read answer

What are the different problems that “Data mining” can solve?

Data mining helps analysts in making faster business decisions which increases revenue with lower costs..............
Read answer

What are different stages of “Data mining”?

Exploration: This stage involves preparation and collection of data. it also involves data cleaning, transformation. Based on size of data, different tools to analyze the data may be required. This stage helps to determine different variables of the data to determine their behavior...................
Read answer

What is Discrete and Continuous data in Data mining world?

Discreet data can be considered as defined or finite data. E.g. Mobile numbers, gender. Continuous data can be considered as...............
Read answer

What is MODEL in Data mining world?

Models in Data mining help the different algorithms in decision making or pattern matching. The second stage of data mining....................
Read answer

How does the data mining and data warehousing work together?

Data warehousing can be used for analyzing the business needs by storing data in a meaningful form. Using Data mining,...............
Read answer

What is a Decision Tree Algorithm?

A decision tree is a tree in which every node is either a leaf node or a decision node. This tree takes an input an object and outputs some decision................
Read answer

What is Naïve Bayes Algorithm?

Naïve Bayes Algorithm is used to generate mining models. These models help to identify relationships between input columns and the predictable columns................
Read answer

Explain clustering algorithm.

Clustering algorithm is used to group sets of data with similar characteristics also called as clusters......................
Read answer

What is Time Series algorithm in data mining?

Time series algorithm can be used to predict continuous values of data. Once the algorithm is skilled to predict a series of data, it can predict the outcome of other series....................
Read answer

Explain Association algorithm in Data mining

Association algorithm is used for recommendation engine that is based on a market based analysis. This engine suggests products to customers based on what they bought earlier. The model is built on a dataset containing identifiers......................
Read answer

What is Sequence clustering algorithm?

Sequence clustering algorithm collects similar or related paths, sequences of data containing events.......................
Read answer

Explain the concepts and capabilities of data mining.

Data mining is used to examine or explore the data using queries. These queries can be fired on the data warehouse. Explore the data in data mining helps in reporting,....................
Read answer

Explain how to work with the data mining algorithms included in SQL Server data mining.

SQL Server data mining offers Data Mining Add-ins for office 2007 that allows discovering the patterns and relationships of the data.................
Read answer

Explain how to use DMX-the data mining query language.

Data mining extension is based on the syntax of SQL. It is based on relational concepts and mainly used to create and manage the data mining models.............................
Read answer

Explain how to mine an OLAP cube.

A data mining extension can be used to slice the data the source cube in the order as discovered by data mining........................    
Read answer

Data mining Test (15 questions)

<<Previous  Next>>

Also read

Question: Explain Full-Text Query in SQL Server.

Answer - SQL Server supports searches on character string columns using Full-Text Query......

Question: Ex\
plain the phases a transaction has to undergo.

Answer - The several phases a transaction has to go through are listed here. Database.....

Question: What is XPath?

Answer - XPath is a language defined by the W3C, used to select nodes from XML documents. ....

Question: Define the rules for designing Files and File groups in SQL Server.

Answer - A file or file group can only be used by one database. For example, the files abc.mdf and abc.ndf contains....

Question: What are the Authentication Modes in SQL Server?

Answer - SQL Server supports two security (authentication) modes....

Question: Explain Data Definition Language, Data Control Language and Data Manipulation Language.

Answer - Data definition language is used to define and manage all attributes and properties of a database.....

  1. Differentiate between Data Mining and Data warehousing.
  2. Define Data purging.
  3. Define Analysis services
  4. What are CUBES?
  5. What are OLAP and OLTP?
  6. Differentiate between Data Mining and Data warehousing.
  7. What is Data purging?
  8. What are CUBES?
  9. What are OLAP and OLTP?
  10. What are the different problems that “Data mining” can solve?
  11. What are different stages of “Data mining”?
  12. What is Discrete and Continuous data in Data mining world?
  13. What is MODEL is Data mining world?
  14. How does the data mining and data warehousing work together?
  15. What is a Decision Tree Algorithm?
  16. What is Naïve Bayes Algorithm?
  17. Explain clustering algorithm.
  18. What is Time Series algorithm in data mining?
  19. Explain Association algorithm in Data mining?
  20. What is Sequence clustering algorithm?
  21. How does data mining and data warehousing work together?

Write your comment - Share Knowledge and Experience

Discussion Board
select the best field in id3

Hi
I had a question about ID3 trees.
If the same information gain in multiple fields, then which field is used to draw the tree?

jalal alipoor 09-15-2012 09:01 AM

 


 



 
Interview questions
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us