Data Mining Set 3
On This Page
This set of Data Mining Multiple Choice Questions & Answers (MCQs) focuses on Data Mining Set 3
Q1 | ............................. is the process of finding a model that describes and distinguishes data classes or concepts.
- data characterization
- data classification
- data discrimination
- data selection
Q2 | iv) Handling uncertainty, noise, or incompleteness of data
- i, ii and iv only
- ii, iii and iv only
- i, ii and iii only
- all i, ii, iii and iv
Q3 | The full form of KDD is ..................
- knowledge database
- knowledge discovery database
- knowledge data house
- knowledge data definition
Q4 | The out put of KDD is .............
- data
- information
- query
- useful information
Q5 | . The full form of OLAP is
- online analytical processing
- online advanced processing
- online advanced preparation
- online analytical performance
Q6 | ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
- data mining
- data warehousing
- document mining
- text mining
Q7 | The data is stored, retrieved and updated in ....................
- olap
- oltp
- smtp
- ftp
Q8 | An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
- olap
- oltp
- both of the above
- none of the above
Q9 | ........................ is a good alternative to the star schema.
- star schema
- snowflake schema
- fact constellation
- star-snowflake schema
Q10 | The ............................ exposes the information being captured, stored, and managed by operational systems.
- top-down view
- data warehouse view
- data source view
- business query view
Q11 | The type of relationship in star schema is ...............
- many to many
- one to one
- one to many
- many to one
Q12 | The .................. allows the selection of the relevant information necessary for the data warehouse.
- top-down view
- data warehouse view
- data source view
- business query view
Q13 | Which of the following is not a component of a data warehouse?
- metadata
- current detail data
- lightly summarized data
- component key
Q14 | Which of the following is not a kind of data warehouse application?
- information processing
- analytical processing
- data mining
- transaction processing
Q15 | Data warehouse architecture is based on .......................
- dbms
- rdbms
- sybase
- sql server
Q16 | .......................... supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.
- information processing
- analytical processing
- data mining
- transaction processing
Q17 | The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.
- multidimensional cube
- dimensions cube
- data cube
- data model
Q18 | The data from the operational environment enter ........................ of data warehouse.
- current detail data
- older detail data
- lightly summarized data
- highly summarized data
Q19 | A data warehouse is ......................
- updated by end users.
- contains numerous naming conventions and formats
- organized around important subject areas
- contain only current data
Q20 | Business Intelligence and data warehousing is used for ..............
- forecasting
- data mining
- analysis of large volumes of product sales data
- all of the above
Q21 | Data warehouse contains ................ data that is never found in the operational environment.
- normalized
- informational
- summary
- denormalized
Q22 | ................... are responsible for running queries and reports against data warehouse tables.
- hardware
- software
- end users
- middle ware
Q23 | The biggest drawback of the level indicator in the classic star schema is that is limits ............
- flexibility
- quantify
- qualify
- ability
Q24 | ............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.
- operational database
- relational database
- multidimensional database
- data repository