Data Mining Set 1 ----SCDL

Plz Click on the link Below to access the Papers of Data Mining:

Data Mining 1


Data Mining 2

Data Mining 2--SCDL

  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

Data Mining 1--SCDL

 Data Mining 1:

LIST OF ATTEMPTED QUESTIONS AND ANSWERS

 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