CS614 Midterm Past Papers by VUBuddy

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 Create online processing capabilities.

Work in batch processing load. Use a distributed database. Integrate data from different sources.

3. Effects of de-normalization on database performance are

Unpredictable

Predictable Conventional Unsurprising

5. DOLAP model facilitates ___________ computing paradigm.

Mobile

Permanent Rigid Strict

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

Independent and Interrelated

Independent or Interrelated Dependent and Interrelated Dependent or Interrelated

9. ________ is an application of intelligence and experience.

Skill Power

Wisdom

Knowledge

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

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

Not Recording Facts

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

(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

Two Direction Partitions

15. One major goal of horizontal splitting is

Splitting rows for exploiting parallelism

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

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

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

Cube Load Schema

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

Data Extraction

Data Loading Data Transformation

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

Loading

Cleansing

Join

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

Distributed Systems Architecture