CS614 Midterm Past Papers 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

• 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
• Date
• PhoneNo
• Name

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 page 49

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