CS614 – MF-2010
Paper 1
By processing, summarizing, or analyzing data organizations create information, which should be designed to increase __________ of individual.
Knowledge
Profit
Intelligence
None of these
A typical example of the crisis in credibility in the naturally evolving architecture is the decision of CEO based on politics and personalities on receiving two different reports for the same query. We say CEO is
Very Subjective and Non-Scientific
Very Objective and Non-Scientific
Very Subjective and Scientific
Very Objective and Scientific
B-Tree is used as an index to provide access to records
Without scanning the entire table
By scanning the entire table
By scanning the entire meta data
None of these
Normally Selectivity of query in data warehouse is
High
Low
Not measured
Normalization is the process of efficiently organizing data in a database by ________ a relational table into smaller tables by projection.
Composing
Joining / Merging
Combining
Decomposing
3NF removes even more data redundancy than 2NF but it is at the cost of
Simplicity and Performance
Complexity
Number of tables
Relations
Geography is a good example of
One-dimensional Hierarchy
Multidimensional Hierarchy
Non-Dimensional
Linear Hierarchy
OLAP is Analytical Processing instead of Transaction Processing, and OLAP is a
Physical database design
Implementation technique
Framework
The environment is smart enough to develop or compute higher level aggregates using lower level or more detailed aggregates. Which of the following approach is described by the above statement?
Aggregate awareness
Cube partitioning
Indexing
MOLAP cube aggregation
ER is a logical design technique that seeks to remove the ________ in data.
Redundancy
Normalization
Anomalies
The goal of star schema design is to simplify ________
Logical data model
Physical data model
Conceptual data model
None of these
A ________ dimension is a collection of random transactional codes, flags and/text attributes that are unrelated to any particular dimension. The ______ dimension is simply a structure that provides a convenient place to store the ______ attributes.
Junk
Time
Parallel
None of these
Change Data Capture is one of the challenging technical issues in _____________
Data Extraction
Data Loading
Data Transformation
Data Cleansing
Merging information is one of the major types of ____________________
Transformation
Extraction
Loading
None of these
Lexical errors fall in which type of class of anomalies
Syntactically Dirty Data
Semantically Dirty Data
Coverage Anomalies
Missing Values Anomalies
Syntactically Dirty Data class of anomalies includes which of the following:
1. Lexical Errors
2. Integrity Constraints Violation
3. Business Rule Contradiction
4. Irregularities
5. Duplication
- Option 1 and 4
- Option 2 and 3
- Option 2, 3, and 5
- Option 1, 4, and 5
As consumers, human beings judge the quality of things during their life-time.
I Consciously
II Subconsciously
III Unconsciously
Which of the following statement is true?
- I Only
- II Only
- III Only
- I & II Only
The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
True
False
If we remove the modification anomalies the table comes in ________ form
1NF
2NF
3NF
4NF
In ROLAP access to information is provided via relational database using _________ standard SQL.
ANSI
Microsoft
Oracle
SAP
What problem may occur with pre-aggregates in ROLAP environment? 2
What is the advantage of CDC in case of INSERT, UPDATE, and DELETE? 2
How dimensions can be identified? Explain with a suitable example. 3
How decisions taken at government level using wrong data produce undesirable results? 3
Explain why and when junk dimension is used. 5
Briefly explain Orr’s laws of data quality? 5
