Data Mining

True/False
Question
A distinguishing feature of Clementine is its object oriented extended
module interface.
Correct Answer
True
Your Answer
True


Select The Blank
Question
Creating ________is violation of Normalization principles.
Correct Answer
Array
Your Answer
Array


True/False
Question
Data Mining refers to extracting knowledge from larger amount of data.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Which of the following of Grid based clustering method explorates
statistical information?
Correct Answer
STING
Your Answer
CLIQUE


Multiple Choice Multiple Answer
Question
The different definitions of metadata are :-
Correct Answer
Data about data , Catalog of data , Data warehouse roadmap
Your Answer
Catalog of data , Data warehouse roadmap , Brain of data


Select The Blank
Question
In ________ type smoothing, minimum and maximum values in given bin are
identified as bin boundaries.
Correct Answer
Smoothing by bin boundaries
Your Answer
Smoothing by medians


Multiple Choice Single Answer
Question
Query tool is meant for :-
Correct Answer
Data acquisition
Your Answer
Information delivery


True/False
Question
Data cube stores multidimensional aggregate information.
Correct Answer
True
Your Answer
False


Select The Blank
Question
________ can store aggregate and detail data at varying levels of resolution
or abstraction.
Correct Answer
Index tree
Your Answer
R-Tree


Select The Blank
Question
________ is the platform for complex data transformation for the purpose of
cleanse it
Correct Answer
Separate optimal Platform
Your Answer
Legacy platform


Multiple Choice Multiple Answer
Question
SMP provides the features like :-
Correct Answer
Each node has access to common set of disks , Controllers which are
accessible to all processors , Each processor has full access to the shared
memory though common bus
Your Answer
Controllers which are accessible to all processors , Each processor has full
access to the shared memory though common bus , It is cluster of nodes


Multiple Choice Single Answer
Question
In intermediate data extraction data capture through transaction log uses
transaction from :-
Correct Answer
Recovery from failure
Your Answer
Recovery from failure


Multiple Choice Multiple Answer
Question
In data storage area , DBA uses metadata for processes of :-
Correct Answer
Backup , Recovery , Tuning Database
Your Answer
Backup , Recovery , Management


Multiple Choice Multiple Answer
Question
Foundation infrastructure of warehouse includes many elements such as :-
Correct Answer
Basic Computing platform , Hardware and operating system , DBMS and Query
Your Answer
Basic Computing platform , DBMS and Query , Query processing components


Match The Following
Question
Correct Answer
Your Answer

Data producer
Responsible for data quality
Responsible for data quality

Domain values
Prevalent problem
Foreign key preserved

Update security
Prevention of unauthorized updates
Prevalent problem

Referential integrity
Foreign key preserved
Prevention of unauthorized updates



Select The Blank
Question
________ is density based clustering method which computes on augumented
clustering ordering for automic ordering for automatic and interactive
cluster analysis
Correct Answer
DBSCAN
Your Answer
DBSCAN


Multiple Choice Multiple Answer
Question
Data compression is to compress the given data by encoding in terms of :-
Correct Answer
Association rule , Decision tree , Cluster
Your Answer
Bytes , Association rule , Decision tree


Multiple Choice Multiple Answer
Question
Knowledge discovery process includes :-
Correct Answer
Data Cleaning , Data Intergration , Data Selectin
Your Answer
Data Cleaning , Data Intergration , Data movememnt


Multiple Choice Multiple Answer
Question
Building blocks of Data Warehouse are :-
Correct Answer
Source Data , Data Staging , Management and Control
Your Answer
Data Staging , Data Manager , Management and Control


True/False
Question
All data extraction, transformation, integration and staging jobs run on
selected hardware under chosen operating system.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Real world databases are highly susceptible to noisy, missing and
inconsistent data due to :-
Correct Answer
Huge size of data
Your Answer
Huge size of data


Match The Following
Question
Correct Answer
Your Answer

Clustering tool
To group different cases
To detect unusual attribute

Data visualization tool
Transaction activity using graph
To filter unrelated attributes

Linkage analysis tool
To identify links
To group different cases

Classification tool
To filter unrelated attributes
To identify links



Multiple Choice Multiple Answer
Question
Generalized linear model includes :-
Correct Answer
Logistic regression , Poisson regression
Your Answer
Poisson regression , Linear regression , Polynomial Regression


True/False
Question
Metadata acts like a nerve center.
Correct Answer
True
Your Answer
False


Multiple Choice Single Answer
Question
OLAP is used for :-
Correct Answer
Online Analytical Processing
Your Answer
Online Application Processing


Select The Blank
Question
________ includes Normalization and Aggregation as data preprocessing
procedures.
Correct Answer
Data transformation
Your Answer
Data integration


Multiple Choice Multiple Answer
Question
The dimensions of spatial data cube are :-
Correct Answer
Non- spatial dimension , Spatial to non spatial , Spatial to spatial
Your Answer
Non- spatial dimension , Spatial to non spatial , Spatial to spatial


Multiple Choice Single Answer
Question
Maintenance of cache consistency is the limitation of :-
Correct Answer
MPP
Your Answer
NUMA


Select The Blank
Question
In ________ duplicate sub trees exist within the tree.
Correct Answer
Repetition
Your Answer
Replication


Select The Blank
Question
Indexed ________ engines search index,web pages and build huge keyword based
indices which help to search sets of web pages containing certain keywords
Correct Answer
Web Search
Your Answer
Web Search


Multiple Choice Single Answer
Question
Redundancies can be deleted by :-
Correct Answer
Co-relational analysis
Your Answer
Coherent analysis


True/False
Question
To detect money laundering and other financial crimes, it is important to
integrate information for multiple databases.
Correct Answer
True
Your Answer
True


Multiple Choice Multiple Answer
Question
Common areas of application for mixed effect model includes :-
Correct Answer
Multiple data , Repeated measures data , Block designs
Your Answer
Multiple data , Dimensional data , Block designs


Select The Blank
Question
In data ________, data encoding or transformations are applied to obtain
reduced or compressed representation.
Correct Answer
Compression
Your Answer
Compression


Multiple Choice Single Answer
Question
Grouped data can be analyzed with the technique :-
Correct Answer
Mixed effect model
Your Answer
Factor analysis


Select The Blank
Question
________ is the navigational map of data warehouse.
Correct Answer
End user Metadata
Your Answer
Extraction Metadata


Multiple Choice Multiple Answer
Question
Business metadata is useful for :-
Correct Answer
Providing support to end users , For external view of data , Provides
technical support to search data
Your Answer
Providing support to end users , For external view of data , Provides
technical support to search data


True/False
Question
The elements of warehouse infrastructure are classified into operational and
physical infrastructure.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Data reduction by volume can be used for data representation using which
type of reduction?
Correct Answer
Numerosity reduction
Your Answer
Histograms


True/False
Question
Descriptive mining takes perform ingerence on current data which predictive
mining characterize the general properties of data in database
Correct Answer
False
Your Answer
False


Multiple Choice Single Answer
Question
Classification rules are extracted from
Correct Answer
Decision Tree
Your Answer
Decision Tree


Multiple Choice Single Answer
Question
Queries run faster to find exact match using which type of indexing?
Correct Answer
Clustered index
Your Answer
Sequential index


Multiple Choice Single Answer
Question
Data can be smoothed by filling the data to function such as :-
Correct Answer
Regression
Your Answer
Clustering


True/False
Question
Data classification is two step process in which first step includes
classfication of model and in second step model describes set of data.
Correct Answer
False
Your Answer
True


Select The Blank
Question
In data warehouse architecture, the ________ component interleaves with and
connects other components.
Correct Answer
Metadata
Your Answer
Metadata


True/False
Question
Legacy data resides on Hierarchical or Network database.
Correct Answer
True
Your Answer
True


Multiple Choice Multiple Answer
Question
Metadata in a data warehouse falls into following categories :-
Correct Answer
Operational Metadata , Extraction and Transformation metadata , End-user
Metadata
Your Answer
Operational Metadata , Extraction and Transformation metadata , End-user
Metadata

Select The Blank
Question
Semantic integration of ________ genome database is the important task of
DNA analysis.
Correct Answer
Heterogeneous and distributed
Your Answer
Heterogeneous and distributed


Multiple Choice Single Answer
Question
Main advantage of following which method is it's fast processing?
Correct Answer
Grid based
Your Answer
Partioning based


Select The Blank
Question
With the widespread option of ________ real-time connection is viable for
data warehouse.
Correct Answer
TCP/IP
Your Answer
HTTP


Select The Blank
Question
________ are responsible for running queries and reports against data
warehouse tables.
Correct Answer
End users
Your Answer
End users


Multiple Choice Multiple Answer
Question
Advantages of Wavelet transformation for clustering are :-
Correct Answer
Unsupervised clustering , Detection of cluster for accuracy , Clustering is
fast
Your Answer
Unsupervised clustering , Clustering is fast , Decomposition of cluster for
accuracy


Multiple Choice Single Answer
Question
Query tool is meant for :-
Correct Answer
Data acquisition
Your Answer
Information delivery


Multiple Choice Single Answer
Question
Which of the following function involves data cleaning, data standardizing
and summarizing?
Correct Answer
Transforming data
Your Answer
Storing data


Multiple Choice Multiple Answer
Question
Which of the following clustering analysis method uses multiresolution
approach?
Correct Answer
STING , Wave Cluster
Your Answer
STING , Wave Cluster


Multiple Choice Single Answer
Question
Which type of following clustering computes augumented cluster ordering?
Correct Answer
OPTICS
Your Answer
CLQUE


Multiple Choice Multiple Answer
Question
Time variant nature of the data in data warehouse :-
Correct Answer
Allows for analysis of the past , Relate information to the present ,
Enables forecasts for the future
Your Answer
Allows for analysis of the past , Relate information to the present ,
Enables forecasts for the future


True/False
Question
The Structure that brings all the components together is known as
Architecture.
Correct Answer
True
Your Answer
True


Multiple Choice Multiple Answer
Question
Data compression is to compress the given data by encoding in terms of :-
Correct Answer
Association rule , Decision tree , Cluster
Your Answer
Bytes , Cluster


Multiple Choice Multiple Answer
Question
The different definitions of metadata are :-
Correct Answer
Data about data , Catalog of data , Data warehouse roadmap
Your Answer
Data about data , Catalog of data , Data warehouse roadmap


True/False
Question
A distinct feature of DB Miner is its data cube based online analytical
mining.
Correct Answer
True
Your Answer
False


Multiple Choice Single Answer
Question
Association rules mining is based on :-
Correct Answer
Clustering and Employing rules for classification
Your Answer
Clustering and Employing rules for classification


True/False
Question
A distinguishing feature of Clementine is its object oriented extended
module interface.
Correct Answer
True
Your Answer
True


Select The Blank
Question
________ includes Normalization and Aggregation as data preprocessing
procedures.
Correct Answer
Data transformation
Your Answer
Data transformation


True/False
Question
To remove noise from data is called as Smoothing.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Data matrix is :-
Correct Answer
Object by variable structure
Your Answer
Object by variable structure


True/False
Question
Data updates are common place in an operational database.
Correct Answer
True
Your Answer
True


True/False
Question
In decision tree internal nodes are denoted by ovals and leaf nodes are
denoted by rectangles
Correct Answer
False
Your Answer
True


True/False
Question
From a Dataware house perspective data mining canbe viewed as an advanced
stage of Online Analytical Programming.
Correct Answer
True
Your Answer
True


Match The Following
Question
Correct Answer
Your Answer

Disparate data
Production data
Query and analysis

Non volatile data
Query and analysis
Archive data

Data granularity
Level of detail
Level of detail

Data from external source
External data
External data



Multiple Choice Multiple Answer
Question
In physical design of data warehouse administration provides features like
:-
Correct Answer
Avoiding reorganizing of tables , Support backup and recovery , Query
processing
Your Answer
Support backup and recovery , Manage store area , Query processing


Select The Blank
Question
________ is the user who has system access privileges but no database
administration privileges as well as not for table and views.
Correct Answer
Network administrator
Your Answer
End user


Multiple Choice Multiple Answer
Question
Data mining Functionalities are :-
Correct Answer
Charactrization and Discrimination , Association Analysis , Cluster Analysis

Your Answer
Association Analysis , Cluster Analysis , Time series Data Analysis


Select The Blank
Question
________ dimension of database in which primitive level data are spatial but
generalization becomes non spatial.
Correct Answer
Spatial to non spatial
Your Answer
Spatial to non spatial


Multiple Choice Multiple Answer
Question
Source Data Component may be grouped into following categories :-
Correct Answer
Production Data , Internal External Data
Your Answer
Internal External Data , Analyzed data , Non Analyzed data


Select The Blank
Question
________ technique is the statistical technique for analyzing data.
Correct Answer
Time series
Your Answer
Time series


Multiple Choice Multiple Answer
Question
The strategies for data reduction are :-
Correct Answer
Data aggregation , Dimension reduction , Numerocity reduction
Your Answer
Data aggregation , Dimension reduction , Numerocity reduction


Multiple Choice Single Answer
Question
Classification rules are extracted from
Correct Answer
Decision Tree
Your Answer
Root-Node


Match The Following
Question
Correct Answer
Your Answer

Data Mining
Knowledge discovery
Knowledge discovery

Metadata
Roadmap for user
Details of summary

Data storage
Data management
Data management

Data staging
Workbench for data
Workbench for data



True/False
Question
Data cube stores multidimensional aggregate information.
Correct Answer
True
Your Answer
True


Select The Blank
Question
________ is the method used to predict the value of response variable from
one to more variables.
Correct Answer
Regression
Your Answer
Regression


Select The Blank
Question
________ databases are one of the most poplularly available and rich
information repositories.
Correct Answer
Relational
Your Answer
Object oriented


True/False
Question
COBWEB is a method of incremental conceptual clustering.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Many methods for data smoothing are also methods for data reduction
involving :-
Correct Answer
Discretization
Your Answer
Clustering


Multiple Choice Single Answer
Question
Dimensionality reduction reduces the data set size by removing :-
Correct Answer
Irrelevant attributes
Your Answer
Irrelevant attributes


Multiple Choice Single Answer
Question
Effect of one attibute value on a given class is independent of values of
other attibute is called
Correct Answer
Value independence
Your Answer
Class Conditional independence


Multiple Choice Single Answer
Question
Which from the following are special programs that are stored on database
and fired when certain predefined action occurs?
Correct Answer
Triggers
Your Answer
Triggers


Select The Blank
Question
A web server usually registers ________ entry for every access of a web page
Correct Answer
Weblog
Your Answer
Log


Multiple Choice Single Answer
Question
Bayes Theorem is :-
Correct Answer
P(H|X)=P(X|H)(P)/P(X)
Your Answer
P(H|X)=P(X|H)(P)/P(X)


True/False
Question
Visual display can help user to give clear impression and overview of the
data characteristics in a database.
Correct Answer
True
Your Answer
True


Multiple Choice Single Answer
Question
Which of the following is based on set of density distribution function
clustering?
Correct Answer
DBSCAN
Your Answer
DBSCAN


Multiple Choice Multiple Answer
Question
Metadata in a data warehouse falls into following categories :-
Correct Answer
Operational Metadata , Extraction and Transformation metadata , End-user
Metadata
Your Answer
Operational Metadata , Extraction and Transformation metadata , End-user
Metadata


Multiple Choice Multiple Answer
Question
Knowledge discovery process includes :-
Correct Answer
Data Cleaning , Data Intergration , Data Selectin
Your Answer
Data Cleaning , Data Intergration , Data Selectin


Select The Blank
Question
Human being have around ________ gene.
Correct Answer
100000
Your Answer
1000000

"To view papers click to above link or "+""