Data mining and warehousing mcq questions

Data mining and warehousing mcq

1. What is true about data mining?

1. Data Mining is defined as the procedure of extracting information from huge sets of data
2. Data mining also involves other processes such as Data Cleaning, Data Integration, Data Transformation
3. Data mining is the procedure of mining knowledge from data.
4. All of the above

Show Answer

2. How many categories of functions involved in Data Mining?

1. 1
2. 2
3. 3
4. 4

Show Answer

3. The mapping or classification of a class with some predefined group or class is known
as?

1. Data Characterization
2. Data Discrimination
3. Data Set
4. Data Sub Structure

Show Answer

4. The analysis performed to uncover interesting statistical correlations between
associated-attribute-value pairs is called?

1. Mining of Association
2. Mining of Clusters
3. Mining of Correlations
4. None of the above

Show Answer

5. ______ may be defined as the data objects that do not comply with the general
behavior or model of the data available.

1. Outlier Analysis
2. Evolution Analysis
3. Prediction
4. Classification

Show Answer

6. “Efficiency and scalability of data mining algorithms” issues comes under?

A. Mining Methodology and User Interaction Issues
B. Performance Issues
C. Diverse Data Types Issues
D. None of the above

Show Answer

7. To integrate heterogeneous databases, how many approaches are there in Data
Warehousing?

1. 1
2. 2
3. 3
4. 4

Show Answer

8. Which of the following is correct advantage of Update-Driven Approach in Data
Warehousing?

A. This approach provides high performance.
B. The data can be copied, processed, integrated, annotated, summarized and
restructured in the semantic data store in advance.
C. Both A and B
D. None Of the above

Show Answer

9. What is the use of data cleaning?

A. to remove the noisy data
B. correct the inconsistencies in data
C. transformations to correct the wrong data.
D. All of the above

Show Answer

10. Data Mining System Classification consists of?

A. Database Technology
B. Machine Learning
C. Information Science
D. All of the above

Show Answer

Data mining and warehousing mcq sppu

11. Which of the following is a good alternative to the star schema?

1. snow flake schema
2. star schema
3. star snow flake schema
4. fact constellation

Show Answer

12. Patterns that can be discovered from a given database are which type…

1. More than one type
2. Multiple type always
3. One type only
4. No specific type

Show Answer

13. Background knowledge is…

1. It is a form of automatic learning.
2. A neural network that makes use of a hidden layer
3. The additional acquaintance used by a learning algorithm to facilitate the learning process
4. None of these

Show Answer

14. Which of the following is true for Classification?

1. subdivision of a set
2. A measure of the accuracy
3. The task of assigning a classification
4. All of these

Show Answer

Data mining and Warehousing mcq

15. Data mining is?

1. time variant non-volatile collection of data
2. The actual discovery phase of a knowledge
3. The stage of selecting the right data
4. None of these

Show Answer

16. ——- is not a data mining functionality?

A) Clustering and Analysis
B) Selection and interpretation
C) Classification and regression
D) Characterization and Discrimination

Show Answer

17. Which of the following can also applied to other forms?

a) Data streams & Sequence data
b) Networked data
c) Text & Spatial data
d) All of these

Show Answer

18. ——– is the out put of KDD

a) Query
b) Useful Information
c) Data
d) information

Show Answer

19. What is noise?

a) component of a network
b) context of KDD and data mining
c) aspects of a data warehouse
d) None of these

Show Answer

data mining and warehousing mcq sppu

20. Firms that are engaged in sentiment mining are analyzing data collected from?

A. social media sites.
B. in-depth interviews.
C. focus groups.
D. experiments.

Show Answer

21. Which of the following forms of data mining assigns records to one of a
predefined set of classes?

(A). Classification
(B). Clustering
(C). Both A and B
(D). None

Show Answer

22. The learning which is used to find the hidden pattern in unlabeled data is called?

(A). Unsupervised learning
(B). Supervised learning
(C). Reinforcement learning

Show Answer

23. The learning which is the example of Self-organizing maps?

(A). Reinforcement learning
(B). Supervised learning
(C). Unsupervised learning
(D). Missing data imputation

Show Answer

24. According to storks’ population size, find the total number of babies from the
following example of predicting the number of babies.

(A). feature
(B). outcome
(C). attribute
(D). observation

Show Answer

25. Which of the following is not belong to data mining?

(A). Knowledge extraction
(B). Data transformation
(C). Data exploration
(D). Data archaeology

Show Answer

26. The learning which is used for inferring a model from labeled training data is
called?

(A). Unsupervised learning
(B). Reinforcement learning
(C). Supervised learning
(D). Missing data imputation

Show Answer

27. Which of the following is the right approach to Data Mining?

(A). Infrastructure, exploration, analysis, exploitation, interpretation
(B). Infrastructure, exploration, analysis, interpretation, exploitation
(C). Infrastructure, analysis, exploration, interpretation, exploitation
(D). None of these

Show Answer

28. Which of the following terms is used as a synonym for data mining?

(A). knowledge discovery in databases
(B). data warehousing
(C). regression analysis
(D). parallel processing in databases

Show Answer

29. …………………..is an essential process where intelligent methods are applied to
extract data patterns

A) Data Warehousing
B) Data Mining
C) Data Base
D) Data Structure

Show Answer

30. Data mining requires

1. Large quantities of operational data stored over a period of time
2. Lots of tactical data
3. Several tape drives to store archival data
4. Large mainframe computers

Show Answer

data mining and warehousing mcq questions

31. Data by itself is not useful unless

1. It is massive
2. It is processed to obtain information
3. It is collected as a raw data from diverse sources
4. It is properly stated

Show Answer

32. Which of the following is NOT example of ordinal attributes?

1. Zip codes
2. Ordered numbers
3. Ascending or descending names
4. Military ranks

Show Answer

33. In asymmetric attribute

1. Order of values is important
2. All values are equals
3. Only non-zero value is important
4. Range of values is important

Show Answer

34. Identify the example of Nominal attribute

1. Temperature
2. Mass
3. Salary
4. Gender

Show Answer

35. Which of the following is not a data pre-processing methods?

1. Data Visualization
2. Data Discretization
3. Data Cleaning
4. Data Reduction

Show Answer

36. Correlation analysis is used for __

1. Handling missing values
2. Identifying redundant attributes
3. Handling different data formats
4. Eliminating noise

Show Answer

37. ______combines data from multiple sources into a coherent store

1. Data Characterization
2. Data Classification
3. Data Integration
4. Data Selection

Show Answer

38. Which of the following is / are attribute subset selection criterion(s) ?

1. Forward selection
2. Backward elimination
3. Decision tree induction
4. All of the above

Show Answer

39. Data mining can also applied to other forms such as…………….

i) Data streams
ii) Sequence data
iii) Networked data
iv) Text data
v) Spatial data
A)i, ii, iii and v only
B) ii, iii, iv and v only
C) i, iii, iv and v only
D) All i, ii, iii, iv and v

Show Answer

40. ____ normalization is not very well efficient in handling the outliers
Min max

1. Min max
2. Z Score
3. Decimal Scaling
4. None of the above

Show Answer

Data mining and warehousing mcq with answers

41. The full form of KDD is………………

A) Knowledge Database
B) Knowledge Discovery Database
C) Knowledge Data House
D) Knowledge Data Definition

Show Answer

Data Analytics sppu mcq

42. A collection of interesting and useful patterns in database is called ___

A. knowledge.
B. information.
C. data.
D. algorithm

Show Answer

43. Data ………………. is the process of finding a model that describes and
distinguishes data classes or concepts.

a)Characterization
b)Mining
c) clustering
d )Classification

Show Answer

44. To remove noise and inconsistent data __ is needed

1. Data Transformation
2. Data Reduction
3. Data Integration
4. Data Cleaning

Show Answer

45.The terms equality and roll up are associated with _

1. OLTP
2. Visualization
3. Data mart
4. Decision Tree

Show Answer

46. An operational system is which of the following?

A. A system that is used to run the business in real time and is based on historical data.
B. A system that is used to run the business in real time and is based on current
data.
C. A system that is used to support decision making and is based on current data.
D. A system that is used to support decision making and is based on historical data.

Show Answer

47. Data warehouse is which of the following?

A. Can be updated by end users.
B. Contains numerous naming conventions and formats.
C. Organized around important subject areas.
D. Contains only current data.

Show Answer

48. Data transformation includes which of the following?

A. A process to change data from a detailed level to a summary level
B. A process to change data from a summary level to a detailed level
C. Joining data from one source into various sources of data
D. Separating data from one source into various sources of data

Show Answer

49. The ……………… allows the selection of the relevant information necessary for
the data warehouse.

A top-down view
B data warehouse view
C data source view
D business query view

Show Answer

50. Which of the following is not a component of a data warehouse?

A Metadata
B Current detail data
C Lightly summarized data
D Component Key

Show Answer

51. Which of the following is not a kind of data warehouse application?

A Information processing
B Analytical processing
C Data mining
D Transaction processing

Show Answer

52. ___ is not associated with data cleaning process.

1. Deduplication
2. Domain consistency
3. Segmentation
4. Disambiguation

Show Answer

53. Dimensionality refers to

1. Cardinality of key values in a star schema
2. The data that describes the transactions in the fact table
3. The level of detail of data that is held in the fact table
4. The level of detail of data that is held in the dimension table

Show Answer

54. Expansion for DSS in DW is

1. Decisive Strategic System
2. Data Support System
3. Data Store System
4. Decision Support system

Show Answer

55. Data in a data warehouse

1. in a flat file format
2. can be normalised but often is not
3. must be in normalised form to at least 3NF
4. must be in normalised form to at least 2NF

Show Answer

56. Friendship structure of users in a social networking site can be considered as
an example of ____

1. Record data
2. Ordered data
3. Graph data
4. None of the above

Show Answer

57. A café owner wanted to compare how much revenue he gained from lattes
across different months of the year. What type of variable is ‘month’?

1. Continuous
2. Categorical
3. Discrete
4. Nominal

Show Answer

58. An outlier is a _

1. Description of records in the data
2. Data point which is considered different from other data points
3. Record with missing attributes
4. Duplicate record

Show Answer

59. Which of the following operations can be performed on ordinal attributes?

1. Distictness
2. Documents
3. Both of the above
4. None of the above

Show Answer

60. Height of a person, can be considered as an attribute of _____type?

1. Nominal
2. Ordinal
3. Interval
4. Ratio

Show Answer

61. The cosine similarity measure counts for _

1. The Euclidian distance between vectors
2. The Manhattan distance between vectors
3. The similarity of documents
4. The dissimilarity of vectors

Show Answer

62. Formula for dissimilarity computation between two objects for categorical
variable is – here p is categorical variable and m denotes number of matches

1. D ( i, j ) = p – m / p
2. D ( i, j ) = p – m / m
3. D ( i, j ) = m – p / p
4. D ( i, j ) = m – p / m

Show Answer

63. Euclidean and Manhattan distances between the objects P, Q and R (1, 2, 3) and
(2, 1, 0) are _

1. 3.32, 4 respectively
2. 3.32, 5 respectively
3. 5, 3.32 respectively
4. 3.30, 3 respectively

Show Answer

64. The main organisational justification for implementing a data warehouse is to
provide

1. ETL from operation systems to strategic systems
2. Large scale transaction processing
3. Storing large volumes of data
4. Decision support

Show Answer

65. A data warehouse

a. must import data from transactional systems whenever significant changes occur in the
transactional data
b. works on live transactional data to provide up to date and valid results
c. takes regular copies of transaction data
d. takes preprocessed transaction data and stores in a way that is optimised for
analysis

Show Answer

66. Data warehouse contains ________data that is seldom found in the operational environment

1. informational
2. normalized
3. denormalized
4. summary

Show Answer

67. In a snowflake schema which of the following types of tables is considered?

1. Fact
2. Dimension
3. Both (a) and (b)
4. None of the above

Show Answer

68. Which of the following statements about data warehouse is true?

1. A data warehouse is necessary to all those organisations that are using relational OLTP
2. A data warehouse is useful to all organisations that currently use OLTP
3. A data warehouse is valuable to the organisations that need to keep an audit trail of their activities
4. A data warehouse is valuable only if the organisation has an interest in analysing historical data

Show Answer

69. When you ____ the data, you are aggregating the data to a higher level

1. Slice
2. Roll Up
3. Roll Down
4. Drill Down

Show Answer

70. The process of viewing the cross-tab (Single dimensional) with a fixed value of
one attribute is _

1. Slicing
2. Dicing
3. Pivoting
4. Both Slicing and Dicing

Show Answer

71. What do data warehouses support?

1. OLAP
2. OLTP
3. OLAP and OLTP
4. Operational databases

Show Answer

72. A data cube consist of _

1. Dimensional data
2. Multidimensional data
3. No dimensional data
4. 1 dimensional data

Show Answer

73. Which type of data storage architecture gives fastest performance?

1. ROLAP
2. MOLAP
3. HOLAP
4. DOLAP

Show Answer

74. Dissimilarity can be defined as __

1. How much certain objects differ from each other
2. How much certain objects simillar from each other
3. Dissimilarities are non negative numbers d(i,j) that are small when i and j are close to each other and that become large when i and j are very different
4. Both (a) and (c)

Show Answer

75. ______supports basic OLAP operations, including slice and dice, drill-down,
roll-up and pivoting

1. Information processing
2. Analytical processing
3. Data processing
4. Transaction processing

Show Answer

data mining and warehousing mcq, data mining and warehousing mcq sppu, data mining and warehousing mcq questions, data mining and data warehousing mcq, data mining and warehouse mcq, dmw mcq, data mining and warehousing multiple choice questions, data mining and warehousing mcq pdf, data warehouse mcq questions and answers, data mining quiz