CS614 Midterm Solved Grand Quiz

CS614 GRAND QUIZ

Onlline Extraction is a kind of---------------------------------data extraction.

o

Logical

o

Dimensional

o Physical page 132

o

Multi valued The ---------------- saw the advent of disk storage, or DASD( direct Access Storage Device) : 1960s

1970s page 13

1950s 1990s

In context of data warehouse, normally it becomes difficult to extract data from different sources because these sources are normally.

Centralized Baseline

Which of the following is not a task of Data Transformation?

Summarization Enrichment Full Data Refresh page 135

Which of the following is not an Orr’s Law of Data Quality”?

“Data that is not used cannot be corrected!” “Data quality is a function of its use, not its collection!” “Data will be no better than its most stringent use!”

“Data duplication can be harmful for the organization! ”

page

Flat files are one of the prevalent structures used in ------------------- data extraction: Online

Offline

Incremental Full Which of the following is NOT one of the advantages of changed data capture (CDC) technique? Flat files are not required

Limited query interface is required for data extraction

page

No incremental on-line I/O required for log tape Extraction of changed data occurs immediately The most common range partitioning is on Color

PhoneNo

A relation is said to be in first normal form(1NF), if it does not contain ________ Single value column

Multi-valued column

Derived column Composite column In a fully normalized database, too many ____________are required Values

Joins

Queries Conditions

In the data warehouse, data is collection from -------------------- sources:

External Internal

De-normalization is more like a “controlled crash” with the aim to ------------ without loss of information: Check Balance Decrease

Enhance

----------------- is making all efforts to increase effectiveness and efficiency in meeting and accepted customer expectation: Quality assurance

Quality improvement

Quality maintenance Quality Establishment

------------- is the application of intelligence and experience to get common goals.

Wisdom

Education Power Information

In the data transformation, ---------- is the rearrangement and simplification of individual Aggregation

Enrichment page 136

Splitting joining

Grain of a fact table means :

The meaning of one fact table row

The meaning of one dimensional table row Summary of aggregates in all fact tables Summary of aggregates in all dimension tables

Reduces redundancy

Increases redundancy Reduces joins Reduces tables

Which of the following is not an example of a typical grain : Individual transaction Daily aggregates Monthly aggregates

Normalized attributes

Multi-dimensional databases(MDDs) typically use -------------------- formats to store pre-summarized cube structures: SQL

Proprietary file

Object oriented Non-proprietary file