CS614 Grand Quiz Set 2 by Arsal Shani and Aina Malik

CS614 GRAND QUIZ · SOLUTION MADE BY: · ARSL SHANI, AINA MALIK & MCS FAMILY GROUP TEAM

1. Online Extraction is a kind of -------------------- data extraction: Physical page 132 Logical Dimensional 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. Which of the following is not a task of Data Transformation?

Summarization Enrichment Full Data Refresh page 135

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! ” page 181

6. Flat files are one of the prevalent structures used in ------------------- data extraction: Online Offline page 134 Incremental Full
7. 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 Date page 66 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