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

Q2. The full form of OLAP is
(a) Online Advanced Program
(b) Online Analytical Program
(c) Online Advanced Processing
(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

Q4. The data is stored, retrieved and updated in
(a) OLTP
(b) OLAP
(c) DBMS
(d) MPP

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

Q6. Fact constellation is a good alternative to the
(a) Galaxy Schema
(b) Snowflake schema
(c) Star Schema
(d) None of the above

Q7. Which operation mainly used to access the live data online and analyse it
(a) ROLAP
(b) OLAP
(c) MOLAP
(d) HOLAP

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

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

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

Q11. Fact constellation is also known as
(a) Star Schema
(b) Snowflake Schema
(c) Micro Schema
(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

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

Q14. Preprocessing step is used in Data _______
(a) cleaning
(b) integration
(c) transformation
(d) reduction

Q15. True or False : "Selection and interpretation is a data mining functionality"
(a) True
(b) False

___________________________________________________________________________