140
87.7k

320+ Data Mining Solved MCQs

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Science in Computer Science TY (BSc CS) , Master of Science in Computer Science (MSc CS) , Bachelor of Science in Computer Science (BSc CS) .

201.

Data mining methodology states that in optimal situation data mining is an _____.

A. standard process.
B. complete process.
C. creative process.
D. ongoing process.
Answer» D. ongoing process.
202.

The ___ algorithm can be applied in cleaning data.

A. search.
B. pattern recognition.
C. learning.
D. clustering.
Answer» B. pattern recognition.
203.

________ is the type of pollution that is difficult to trace.

A. Duplication of records.
B. Ambiguition.
C. Lack of domain consistency.
D. Lack of information.
Answer» C. Lack of domain consistency.
204.

In coding stage of KDD process one should be conscious in ______.

A. adding the data.
B. deleting the data.
C. coding.
D. discovering patterns.
Answer» B. deleting the data.
205.

The statement that is true about data mining is ______.

A. data mining is not a single technique.
B. it finds the hidden patterns from data set.
C. it is a real discovery process.
D. all forms of pollutions are found during the data mining stage itself.
Answer» D. all forms of pollutions are found during the data mining stage itself.
206.

The first step in data mining project is ________.

A. rough analysis of data set using traditional query tools.
B. cleaning the data.
C. recognizing the patterns.
D. visualizing the patterns.
Answer» A. rough analysis of data set using traditional query tools.
207.

SQL can find ________ type of data.

A. narrow data.
B. multidimensional data.
C. shallow data.
D. hidden data.
Answer» C. shallow data.
208.

_______ is used to find relationship between multidimensional data.

A. K-nearest neighbor.
B. Decision trees.
C. Association rules.
D. OLAP tools.
Answer» D. OLAP tools.
209.

Which one of the following is not true about OLAP?

A. They create no new knowledge.
B. OLAP is powerful that data mining tool.
C. They cannot search for new solution.
D. OLAP tool store their data in special multidimensional format.
Answer» B. OLAP is powerful that data mining tool.
210.

Association rules are always defined on________.

A. binary attribute.
B. single attribute.
C. relational database.
D. multidimensional attribute.
Answer» A. binary attribute.
211.

Neural network are modeled on the ___________.

A. neuron.
B. network.
C. human brain.
D. machines.
Answer» C. human brain.
212.

______ built perceptron.

A. Kohenon.
B. Frank Rosenblatt.
C. Minsley.
D. Papert.
Answer» B. Frank Rosenblatt.
213.

The input unit of perceptron is called as_______.

A. associators.
B. responders.
C. neuron.
D. photo receptors.
Answer» D. photo receptors.
214.

The intermediate layers in a back-propagation network consists of__________.

A. photo receptors.
B. responders.
C. hidden nodes.
D. associators.
Answer» C. hidden nodes.
215.

The area for exchange of views between biology and computer science is called as__________.

A. evolutionary programming.
B. evolutionary computing.
C. evolutionary strategies.
D. genetic algorithm.
Answer» B. evolutionary computing.
216.

Genetic algorithm is viewed as a kind of______.

A. meta learning strategy.
B. machine learning.
C. evolution.
D. OLAP tool.
Answer» A. meta learning strategy.
217.

The _________is a knowledge that can be found by using pattern recognition algorithm.

A. hidden knowledge.
B. deep.
C. shallow.
D. multidimensional.
Answer» A. hidden knowledge.
218.

The process of finding the right formal representing of a certain body of knowledge in order to represent it in knowledge based system is__________.

A. re-engineering.
B. replication.
C. knowledge engineering.
D. reverse engineering.
Answer» C. knowledge engineering.
219.

The performance of _______is better at problem solving techniques

A. neural network.
B. classification trees.
C. decision tree.
D. genetic knowledge.
Answer» D. genetic knowledge.
220.

The quality of output depends on ____________.

A. algorithm that is capable of learning rules.
B. algorithm that can handle large data sets.
C. algorithm that can learn incrementally.
D. algorithm that performs well.
Answer» A. algorithm that is capable of learning rules.
221.

In CAPITANS _________ algorithm is used to predict the pilots behavior.

A. neural network.
B. genetic algorithm.
C. association.
D. decision tree.
Answer» B. genetic algorithm.
222.

OR methods deals with _______type of data.

A. quantitative.
B. qualitative.
C. standard.
D. predict.
Answer» A. quantitative.
223.

Shannons notation of information content of message is_______.

A. Log 1divided by n equals log n.
B. log n equals log 1divided by n.
C. log 1divided by n equals minus log n.
D. log minus n =log 1divided by n.
Answer» C. log 1divided by n equals minus log n.
224.

Which of the following features usually applies to data in a data warehouse

A. Data are often deleted.
B. Most applications consist of transactions.
C. Data are rarely deleted.
D. Relatively few records are processed by applications.
Answer» C. Data are rarely deleted.
225.

Which of the following is true

A. The data warehouse consists of data marts and operational data
B. The Data Warehouse consists of data marts and application data.
C. The Data Warehouse is used as a source for the operational data.
D. The operational data are used as a source for the data warehouse
Answer» D. The operational data are used as a source for the data warehouse
226.

How do you better define a data warehouse as

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.
Answer» C. Organized around important subject areas.
227.

Which of the following is an operational system

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.
Answer» B. A system that is used to run the business in real time and is based on current data.
228.

The generic two-level data warehouse architecture includes _______________.

A. at least one data mart.
B. data that can extracted from numerous internal and external sources.
C. near off-time updates.
D. historic data.
Answer» B. data that can extracted from numerous internal and external sources.
229.

Which of the following is reconciled data

A. Current data intended to be the single source for all decision support systems
B. Data stored in the various operational systems throughout the organization.
C. Data stored in one operational system in the organization.
D. Data that has been selected and formatted for end-user support applications.
Answer» A. Current data intended to be the single source for all decision support systems
230.

________analysis divides data into groups that are meaningful, useful, or both.

A. Cluster.
B. Association.
C. Classifiction.
D. Relation.
Answer» A. Cluster.
231.

Which of the following is an extract process

A. Capturing all of the data contained in various operational systems.
B. Capturing a subset of the data contained in various operational systems.
C. Capturing all of the data contained in various decision support systems.
D. Capturing a subset of the data contained in various decision support systems.
Answer» B. Capturing a subset of the data contained in various operational systems.
232.

Which of the following is the not a types of clustering?

A. K-means.
B. Hiearachical.
C. Partitional.
D. Splitting.
Answer» D. Splitting.
233.

The load and index is __________.

A. a process to upgrade the quality of data before it is moved into a data warehouse.
B. a process to upgrade the quality of data after it is moved into a data warehouse.
C. a process to reject data from the data warehouse and to create the necessary indexes.
D. a process to load the data in the data warehouse and to create the necessary indexes.
Answer» D. a process to load the data in the data warehouse and to create the necessary indexes.
234.

Data Transformation includes____________.

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.
Answer» A. a process to change data from a detailed level to a summary level.
235.

The _____________ is called a multi field transformation.

A. conversion of data from one field into multiple fields.
B. conversion of data from fields into field.
C. conversion of data from double fields into multiple fields
D. conversion of data from one field to one field.
Answer» A. conversion of data from one field into multiple fields.
236.

The type of relationship in star schema is ____________.

A. many-to-many.
B. one-to-one.
C. one-to-many.
D. many-to-one.
Answer» C. one-to-many.
237.

Fact tables are _____________.

A. completely demoralized.
B. partially demoralized.
C. completely normalized.
D. partially normalized.
Answer» C. completely normalized.
238.

Which of the following table type belongs to snowflake schema

A. Free.
B. Dimension.
C. Double.
D. Replicator.
Answer» B. Dimension.
239.

The goal of data mining is _________.

A. to explain some observed event or condition.
B. to confirm that data exists.
C. to analyze data for expected relationships.
D. to create a new data warehouse.
Answer» A. to explain some observed event or condition.
240.

Which of the following information systems are used in the daily running of the business

A. Operational planning systems.
B. Transaction processing systems (TPS).
C. Process control systems.
D. Office automation systems (OAS).
Answer» A. Operational planning systems.
241.

Which of the following is not one of the three Cs describing groupware

A. Collaboration.
B. Communication.
C. Co-ordination.
D. Compliance.
Answer» D. Compliance.
242.

Materials Requirements Planning (MRP) software is an example of an information systems application in which of the following areas

A. Operations Management.
B. Accounting.
C. Marketing.
D. Human Resource.
Answer» A. Operations Management.
243.

Which of the following is not one of the three main components in a decision support system

A. Model.
B. Communications.
C. Data.
D. Dialogue.
Answer» B. Communications.
244.

Business Intelligence and data warehousing is used for which of the following

A. Forecasting.
B. Data Mining.
C. Analysis of large volumes of product sales data.
D. All of the above.
Answer» D. All of the above.
245.

Which of the following is true about ERP software

A. Simplified support and maintenance through a supplier.
B. Extensive skills available for development.
C. Supplier costs kept low.
D. Always adaptable to how the business works.
Answer» A. Simplified support and maintenance through a supplier.
246.

Which of the following is an EIS

A. Electronic information system.
B. Executive information system.
C. Extended information system.
D. Electronic interface system.
Answer» B. Executive information system.
247.

What is the role of document image processing (DIP) systems

A. Cash flow forecasting.
B. Inventory control.
C. Conversion into digital format.
D. Producing customer invoices.
Answer» C. Conversion into digital format.
248.

Which of the following uses a series of logically related two-dimensional tables or files to store information in the form of a database

A. Database.
B. Database management system.
C. Data warehouse.
D. None of the above.
Answer» D. None of the above.
249.

What DBMS component contains facilities to help you develop transaction-intensive applications

A. DBMS engine.
B. Data definition subsystem.
C. Application generation subsystem.
D. Data administration subsystem.
Answer» C. Application generation subsystem.
250.

Which of the following is a data manipulation tool

A. File generators.
B. Query by example tool.
C. Structure question language.
D. Structure query language.
Answer» B. Query by example tool.

Done Studing? Take A Test.

Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.