Data Mining - 2

LIST OF ATTEMPTED QUESTIONS AND ANSWERS

 
 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