Top 350+ Solved Data Mining and Data Warehouse MCQ Questions Answer
Q. Patterns that can be discovered from a given database are which type
a. more than one type
b. multiple types always
c. one type only
d. no specific type
Q. A snowflake schema is which of the following types of tables?
a. fact
b. dimension
c. helper
d. all of the above
Q. Expansion for DSS in DW is__________.
a. decision support system
b. decision single system
c. data storable system
d. data support system
Q. __________describes the data contained in the data warehouse
a. relational data
b. operational data
c. meta data
d. informational data
Q. Converting data from different sources into a common format for processing is called as________.
a. selection.
b. preprocessing
c. transformation
d. interpretation
Q. Data warehousing is used in_______________
a. transaction system
b. database management system
c. decision support system
d. expert system
Q. Data warehouse is based on_____________
a. two dimensional model
b. three dimensional model
c. multi dimensional model
d. unidimensional model
Q. Multidimensional model of data warehouse called as_____
a. data structure
b. table
c. tree
d. data cube
Q. In data warehousing what is time-variant data?
a. data in the warehouse is only accurate and valid at some point in time or over time interval
b. data in the warehouse is always accurate and valid
c. data in the warehouse is not accurate
d. data in the warehouse is only accurate sometimes
Q. What is a Star Schema?
a. a star schema consists of a fact table with a single table for each dimension
b. a star schema is a type of database system
c. a star schema is used when exporting data from the database
d. none of these
Q. What does the acronym ETL stands for?
a. explain,transfer and lead
b. extract,transform and load
c. extract,transfer and load
d. effect,transfer and load
Q. Which small logical units do data warehouses hold large amounts of information?
a. data storage
b. data marts
c. access layers
d. data miners
Q. Which one is correct for data warehousing?
a. it can be updated by end users
b. it can solve all business questions
c. it is designed for focus subject areas
d. it contains only current data