CS614 GRAND QUIZ – MCQs
Q1: Online Extraction is a kind of data extraction.
(A) Logical
(B) Dimensional
(C) Physical
(D) Multi-valued
Answer: (C) Physical
Q2: The advent of disk storage, or DASD (Direct Access Storage Device) occurred in:
(A) 1960s
(B) 1970s
(C) 1950s
(D) 1990s
Answer: (B) 1970s
Q3: Normally it becomes difficult to extract data from different sources because these sources are:
(A) Heterogeneous
(B) Homogeneous
(C) Centralized
(D) Baseline
Answer: (A) Heterogeneous
Q4: Which of the following is not a task of Data Transformation?
(A) Conversion
(B) Summarization
(C) Enrichment
(D) Full Data Refresh
Answer: (D) Full Data Refresh
Q5: Which of the following is not an Orr’s Law of Data Quality?
(A) Data that is not used cannot be corrected
(B) Data quality is a function of its use, not its collection
(C) Data will be no better than its most stringent use
(D) Data duplication can be harmful for the organization
Answer: (D) Data duplication can be harmful for the organization
Q6: Flat files are one of the prevalent structures used in data extraction:
(A) Online
(B) Offline
(C) Incremental
(D) Full
Answer: (B) Offline
Q7: Which of the following is NOT an advantage of changed data capture (CDC) technique?
(A) Flat files are not required
(B) Limited query interface is required
(C) No incremental online I/O required for log tape
(D) Extraction of changed data occurs immediately
Answer: (B) Limited query interface is required
Q8: The most common range partitioning is on:
(A) Color
(B) Date
(C) PhoneNo
(D) Name
Answer: (B) Date
Q9: A relation is in first normal form (1NF) if it does not contain:
(A) Single value column
(B) Multi-valued column
(C) Derived column
(D) Composite column
Answer: (B) Multi-valued column
Q10: In a fully normalized database, too many ___ are required:
(A) Values
(B) Joins
(C) Queries
(D) Conditions
Answer: (B) Joins
Q11: In the data warehouse, data is collected from:
(A) Homogeneous
(B) Heterogeneous
(C) External
(D) Internal
Answer: (B) Heterogeneous
Q12: De-normalization is more like a “controlled crash” with the aim to ___ without loss of information:
(A) Check
(B) Balance
(C) Decrease
(D) Enhance
Answer: (C) Decrease
Q13: ___ is making all efforts to increase effectiveness and efficiency in meeting an accepted customer expectation:
(A) Quality assurance
(B) Quality improvement
(C) Quality maintenance
(D) Quality establishment
Answer: (B) Quality improvement
Q14: ___ is the application of intelligence and experience to get common goals:
(A) Wisdom
(B) Education
(C) Power
(D) Information
Answer: (A) Wisdom
Q15: In data transformation, ___ is the rearrangement and simplification of individual data:
(A) Aggregation
(B) Enrichment
(C) Splitting/joining
(D) Conversion
Answer: (C) Splitting/joining
Q16: Grain of a fact table means:
(A) The meaning of one fact table row
(B) The meaning of one dimensional table row
(C) Summary of aggregates in all fact tables
(D) Summary of aggregates in all dimension tables
Answer: (A) The meaning of one fact table row
Q17: Normalization:
(A) Reduces redundancy
(B) Increases redundancy
(C) Reduces joins
(D) Reduces tables
Answer: (A) Reduces redundancy
Q18: Which of the following is not an example of a typical grain?
(A) Individual transaction
(B) Daily aggregates
(C) Monthly aggregates
(D) Normalized attributes
Answer: (D) Normalized attributes
Q19: Multi-dimensional databases (MDDs) typically use ___ formats to store pre-summarized cube structures:
(A) SQL
(B) Proprietary file
(C) Object-oriented
(D) Non-proprietary file
Answer: (B) Proprietary file
Q20: ___ provides a combination of “relational database access” and “cube” data structures within a single framework:
(A) DOLAP
(B) MOLAP
(C) ROLAP
(D) HOLAP
Answer: (C) ROLAP
Q21: Data Warehouse provides the best support for analysis while OLAP carries out the ___ task:
(A) Mandatory
(B) Whole
(C) Analytical
(D) Prediction
Answer: (C) Analytical
Q22: ___ 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:
(A) Vertical splitting
(B) Horizontal splitting
(C) Adding redundant column
(D) None of the given option
Answer: (A) Vertical splitting
Q23: OLAP implementations are highly/completely ___:
(A) Normalized
(B) Demoralized
(C) Predictive
(D) Additive
Answer: (B) Demoralized
Q24: If each cell of Relation R contains a single value (no repeating values), then it is confirmed that:
(A) Relation R is in 1st Normal Form
(B) Relation R is in 2nd Normal Form
(C) Relation R is in 3rd Normal Form
(D) Relation R is in 3rd Normal Form but not in 2nd Normal Form
Answer: (A) Relation R is in 1st Normal Form
Q25: Fact-less fact table captures ___ relationships:
(A) Many-to-Many
(B) One-to-Many
(C) One-to-One
(D) None of the given option
Answer: (A) Many-to-Many
Q26: Which of the following is not an example of dimension?
(A) Product
(B) Date
(C) Region
(D) None of the given
Answer: (D) None of the given
Q27: People who criticize Dimensional Modeling (DM) as being a data mart oriented approach are:
(A) Those that consider ER models as Data marts
(B) Those that consider Business processes as Data marts
(C) Those that consider Data marts as Data warehouse
(D) Those that consider dimensional modeling as de-normalization approach
Answer: (B) Those that consider Business processes as Data marts
Q28: Which of the following is an example of Non-Additive Facts?
(A) Quality sold
(B) Total sale in Rs.
(C) Discount in percentage
(D) Count of orders in a store
Answer: (C) Discount in percentage
Q29: Which of the following is not a CUBE operation?
(A) ANSI SQL
(B) Roll Up
(C) Drill Down
(D) Pivoting
Answer: (A) ANSI SQL
Q30: ROLAP provides access to information via a relational database using:
(A) ANSI standard SQL
(B) Proprietary file format
(C) Comma Separated Values
(D) All of the given options
Answer: (A) ANSI standard SQL