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