Data Mining Interview Questions
Q1. ________ is a subject-oriented, integrated,time-varying, nonvolatile collection of data in support of management decisions –making process.
(a) Data structure
(b) Data warehouse
(c) Data base
(d) Data analytics
Answer: (b) Data warehouse
Q2. The full form of OLAP is
(a) Online Advanced Program
(b) Online Analytical Program
(c) Online Advanced Processing
(d) Online Analytical Processing
Answer: (d) Online Analytical Processing
Q3. What is the full form of OLTP
(a) Online Transaction Processing
(b) Online Transaction Program
(c) Oracle Transaction Processing
(d) Online Terminal Processing
Answer: (a) Online Transaction Processing
Q4. The data is stored, retrieved and updated in
(a) OLTP
(b) OLAP
(c) DBMS
(d) MPP
Answer: (a) OLTP
Q5. State true or false : "An OLAP system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts."
(a) True
(b) False
Answer: (a) True
Q6. Fact constellation is a good alternative to the
(a) Galaxy Schema
(b) Snowflake schema
(c) Star Schema
(d) None of the above
Answer: (c) Star Schema
Q7. Which operation mainly used to access the live data online and analyse it
(a) ROLAP
(b) OLAP
(c) MOLAP
(d) HOLAP
Answer: (b) OLAP
Q8. In data mining, the slice operation performs a selection on _______
(a) One dimension
(b) Two dimension
(c) Multi dimension
(d) None of the above
Answer: (a) One dimension
Q9. In data mining, the dice operation performs a selection on
(a) Single dimension
(b) Only on Two dimension
(c) Two or more dimension
(d) None of the above
Answer: (c) Two or more dimension
Q10. In star schema there is _________ relationship between fact table and dimension table
(a) M:N
(b) 1:N
(c) 2:N
(d) 3:N
Answer: (b) 1:N
Q11. Fact constellation is also known as
(a) Star Schema
(b) Snowflake Schema
(c) Micro Schema
(d) Galaxy Schema
Answer: (d) Galaxy Schema
Q12. __________ is the bridge between data warehouse and decision support application.
(a) Logical data
(b) Complex data
(c) Nominal data
(d) Metadata
Answer: (d) Metadata
Q13. Which one referes to the finding of relevant and useful information from databases
(a) Data mining
(b) Data warehouse
(c) Data management
(d) Data query
Answer: (a) Data mining
Q14. Preprocessing step is used in Data _______
(a) cleaning
(b) integration
(c) transformation
(d) reduction
Answer: (a) cleaning
Q15. True or False : "Selection and interpretation is a data mining functionality"
(a) True
(b) False
Answer: (b) False
Practice Test Exam