CS614 Midterm Solved MCQs by Junaid

1. Onlline Extraction is a kind of---------------------------------data extraction. o Logical o Dimensional

o Physical page 132

o Multi valued

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

1970s page 13

1950s 1990s

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

Centralized Baseline

Q4. 5Which of the following is not a task of Data Transformation?

Summarization Enrichment

Full Data Refresh

Q5. . 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! ”

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

Offline

Incremental Full

Q7. 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 152

No incremental on-line I/O required for log tape Extraction of changed data occurs immediately

8. The most common range partitioning is on Color

PhoneNo

9. A relation is said to be in first normal form(1NF), if it does not contain ________ Single value column Multi-valued column page 43 Derived column Composite column
10. In a fully normalized database, too many ____________are required Values

Joins

Queries Conditions

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

External Internal

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

Enhance

13. 1----------------- is making all efforts to increase effectiveness and efficiency in meeting and accepted customer expectation: Quality assurance Quality improvement page 183 Quality maintenance Quality Establishment
14. ------------- is the application of intelligence and experience to get common goals.

Wisdom

Education Power Information

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

Enrichment page 136

Splitting joining

16. 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

17. Normalization ----------------- :

Reduces redundancy

Increases redundancy Reduces joins Reduces tables

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

Normalized attributes

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

Proprietary file

Object oriented Non-proprietary file

20. ------------ provides a combination of “relational databases access” and “cube” data structures within a single framework:

HOLAP

DOLAP MOLAP