Data Mining Interview Questions

Q31. The time horizon in operational environment is
(a) 10-30 days
(b) 30-60 days
(c) 60-90 days
(d) 90-120 days

Q32. Which databases are owned by particular departments or business groups
(a) Operational
(b) Transactional
(c) Rational
(d) Informational

Q33. State true or false : 'Data can be updated in operational environment'
(a) True
(b) False

Q34. Which one is not a Knowledge Discovery in Databases (KDD) process
(a) Selection
(b) Transformation
(c) Data Mining
(d) Understanding

Q35. Total number of stages in KDD is
(a) 3
(b) 4
(c) 5
(d) 6

Q36. In the data warehouse, which data have the greatest level of details stored
(a) Micro Data
(b) Atomic Data
(c) Macro Data
(d) Dimensional Data

Q37. In Transient data, after changes with the the records, the previous version of the records will be
(a) Added
(b) Eliminated
(c) Separately stored
(d) Remain same

Q38. The process of upgrading the existing quality of data before it is moved into a data warehouse is known as
(a) Data Scrubbing
(b) Data Polishing
(c) Data Auditing
(d) Data Aggregation

Q39. Which one is true about a Fact Table
(a) Contains Hierarchies
(b) Contains Descriptive attributes
(c) Contains Quantitative information
(d) Located at the edges of the star schema

Q40. A decision tree where the target variable takes a continuous value, usually numbers, are called
(a) Classification Trees
(b) Regression Trees
(c) Agression Tree
(d) Expanded Tree

Q41. Which one is a method of incremental conceptual clustering
(a) DBWEB
(b) OLAD
(c) COBWEB
(d) CATWEB

Q42. Data warehouse architecture is based on
(a) DBMS
(b) RDBMS
(c) SQL
(d) ORACLE

Q43. In OLAP cubes, data (measures) are categorized by
(a) Length
(b) Angles
(c) Dimensions
(d) Breadth

Q44. Which type of database can be used for optimizing data warehousing and OLAP (online analytical processing)
(a) Retional
(b) Relational
(c) Structural
(d) Multidimensional

Q45. ODS stands for
(a) Online Data Store
(b) Online Data Storage
(c) Operational Data Stand
(d) Operational Data Store

___________________________________________________________________________