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
No comments:
Post a Comment