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

Read more »

Posted in: Data Mining (Set - 1)

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

Read more »

Posted in: Data Mining (Set - 1)