CS614 Grand Quiz 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. Grain of a fact table means : The meaning of one fact table row page 109 The meaning of one dimensional table row Summary of aggregates in all fact tables Summary of aggregates in all dimension tables
4. Normalization ----------------- : Reduces redundancy page 41 Increases redundancy Reduces joins Reduces tables
5. Which of the following is not an example of a typical grain : Individual transaction Daily aggregates Monthly aggregates Normalized attributes page 111
6. Multi-dimensional databases(MDDs) typically use -------------------- formats to store pre- summarized cube structures: SQL Proprietary file page 79 Object oriented Non-proprietary file
7. ------------ provides a combination of “relational databases access” and “cube” data structures within a single framework: HOLAP page 78 DOLAP MOLAP ROLAP
8. Data Warehouse provides the best support for analysis while OLAP carries out the ------------- task: Mandatory Whole Analysis page 69 Prediction
9. ------------------ involves splitting a table by columns so that a group of columns is placed into the new table and the remaining columns are placed in another new table:

Adding redundant column

10. OLAP implementations are highly/completely ------------------ : Normalized Demoralized page 69 Predictive Additive
11. If each cell of Relation R contains a single value ( no repeating values) then it is confirmed that : Relation R is in 1st Normal Form page 43 Relation R is in 2nd Normal Form Relation R is in 3rd Normal Form Relation R is in 3rd Normal Form but not in 2nd Normal Form
12. Which kind of relationships is captured by Fact less fact table: Many- to- Many page 121 One-to-many One-to-one
13. Which of the following is not an example of dimension: Product

Region Sales volume page 78

14. Which people criticize Dimensional Modeling (DM) as being a data mart oriented approach? Those that consider ER models as Data marts Those that consider Business processes as Data marts page 110 Those that consider Data marts as Data warehouse Those that consider dimensional model Those that consider dimensional modeling as de-normalization approach