CS614 Solved MCQs Spring 2013 by Dr Tariq Hanif

1. _________ is one class of decision support environment.

OLAP 30page OLTP

ETL

2. The confusion created by data redundancy makes it difficult for companies to
3. Effects of de-normalization on database performance are

Unpredictable pg 62 Predictable Conventional Unsurprising

4. OLAP is a (n) ___________ of application.

Blending

5. DOLAP model facilitates ___________ computing paradigm.

Mobile pg 78 Permanent Rigid Strict

6. ______ is the lowest level of detail or the atomic level of data stored in the warehouse.

Cube Grain pg 111 Aggregate

7. Extract, Transform, Load (ETL) process consist of steps which are ______________. Independent and Interrelated 131

Independent or Interrelated Dependent and Interrelated Dependent or Interrelated

8. In _________ system, the contents change with time.

OLTP pg 20 DSS ATM OLAP

9. ________ is an application of intelligence and experience.

Skill Power Wisdom pg 11 Knowledge

10. 3NF removes even more data redundancy than 2NF but it is at the cost of

Relations

11. Collapsing tables can be done on the ___________ relationship(s)

Only One-to-One Only Many-to-Many Only One-to-Many Both One-to-One and Many-to-Many pg 52

12. Transactional fact tables do not have records for events that do not occur. These are called

Not Recording Facts pg 120 Fact-less Facts Null Facts Empty Facts

13. Semantically " Dirty Data" class of anomalies includes which of the following:

I) Lexical Errors II) Integrity Constraints Violation III) Business Rule Contradiction IV) Irregularities V) Duplication (I) and (II) only (I), (II), and (III) (II), (III), and (V) only pg 160 (I), (IV), and (V) only

14. Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.

Only One Direction Any Direction pg 19 Two Directions Partitions

15. One major goal of horizontal splitting is

Splitting rows for exploiting parallelism pg 54 Splitting columns for exploiting parallelism Splitting schema for exploiting parallelism Splitting relationships for exploiting parallelism

16. MOLAP usually builds “cubes” in proprietary file format of a multi-dimensional database (MDD) or a user defined data structure, therefore _______ is not supported.

ANSI pg 78 Microsoft Oracle SAP

17. A company has implemented data warehouse for analytical purpose. Quantity sold is stored as a fact. This quantity sold is

Additive Fact 115 Non-Additive Fact Associative Fact Non-Associative Fact

18. Typically a data mart is much smaller to data warehouse and it is pretty easy to take its ______ as compare to data warehouse.

Backup pg 131 Cube Load Schema

19. " Change Data Capture" is one of the challenging technical issues in _____________

Data Extraction pg 149 Data Loading Data Transformation

20. Within the data warehousing domain, data ________ is applied especially when several databases are merged.

Loading Cleansing pg 168 Join

1. Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as

Distributed Systems Architecture Legacy Systems Architecture pg 14